The Project Activity Table: DSN8810.PROJACT DSN8810.PROJACT records the activities for each project. It stores the following information: the project's number, the activity's number, the number of employees needed to staff the activity, and the estimated activity start date and end date. DSN8810.PROJACT is a parent of the DSN8810.EMPPROJACT table and functions as a child table for DSN8810.ACT and DSN8810.PROJ . This table has one index: DSN8810.XPROJAC1 is a unique primary key index on PROJNO , ACTNO , and ACSTDATE . DSN8810.PROJACT Table DDL CREATE TABLE DSN8810.PROJACT (PROJNO CHAR(6) NOT NULL, ACTNO SMALLINT NOT NULL, ACSTAFF DECIMAL(5,2), ACSTDATE DATE NOT NULL, ACENDATE DATE, MAJPROJ CHAR(6), PRIMARY KEY (PROJNO, ACTNO, ACSTDATE), FOREIGN KEY RPAP (PROJNO) REFERENCES DSN8810.PROJ ON DELETE RESTRICT, FOREIGN KEY RPAA (ACTNO) REFERENCES DSN8810.ACT ON DELETE RESTRICT ) IN DSN8D81A.DSN8S81P CCSID EBCDIC; |