Project activity table (PROJACT)

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: