The Project Activity Table: DSN8810.PROJACT

 <  Day Day Up  >  

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; 

 <  Day Day Up  >  


DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net