Project activity table (PROJACT)

 

The project activity table describes each project activity that the business is currently undertaking. Data contained in each row includes the project number, activity number, and schedule dates.

The project activity table is created with the following CREATE TABLE and ALTER TABLE statements:

CREATE TABLE PROJACT 
             (PROJNO CHAR(6) NOT NULL, 
              ACTNO SMALLINT NOT NULL, 
              ACSTAFF DECIMAL(5,2), 
              ACSTDATE DATE NOT NULL, 
              ACENDATE DATE , 
              PRIMARY KEY (PROJNO, ACTNO, ACSTDATE))


ALTER TABLE PROJACT 
              ADD FOREIGN KEY RPAP (PROJNO) 
              REFERENCES PROJECT 
              ON DELETE RESTRICT

The following foreign key is added later:

ALTER TABLE PROJACT             ADD FOREIGN KEY RPAA (ACTNO)
                REFERENCES ACT                 ON DELETE RESTRICT

The following index is created:

CREATE UNIQUE INDEX XPROJAC1 
              ON PROJACT (PROJNO, ACTNO, ACSTDATE)

The table below shows the contents of the columns:

Column name	Description
PROJNO	Project number
ACTNO	Activity number
ACSTAFF	Estimated mean staffing
ACSTDATE	Activity start date
ACENDATE	Activity end date

• PROJACT
  Here is a complete listing of the data in the PROJACT table.

 

Parent topic:

DB2 Universal Database for iSeries sample tables