The Activity Table: DSN8810.ACT

The Activity Table: DSN8810.ACT

DSN8810.ACT describes activities that can be performed for projects. This table simply provides activity information. It does not tie each activity to a project. The following information about an activity is recorded: the activity number, the activity keyword, and the activity description. The activity number ( ACTNO ) is the primary key for this table.

DSN8810.ACT is a parent table for DSN8810.PROJACT . Two indexes have been built for this table: DSN8810.XACT1 is a primary key index on ACTNO , and DSN8810.XACT2 is a unique index on ACTKWD .

DSN8810.ACT Table DDL

 CREATE TABLE DSN8810.ACT  (ACTNO             SMALLINT       NOT NULL,   ACTKWD            CHAR(6)        NOT NULL,   ACTDESC           VARCHAR(20)    NOT NULL,   PRIMARY KEY (ACTNO) ) IN DSN8D81A.DSN8S81P CCSID EBCDIC;