DB2 Server for VSE & VM: Interactive SQL Guide and Reference

PROJ_ACT Table

The PROJ_ACT table lists the activities performed for each project. The table contains information on the start and completion dates of the project activity as well as staffing requirements as shown in Figure 66. Figure 67 shows a description of the columns.

Figure 66. Partial Contents of PROJ_ACT Table

PROJNO ACTNO ACSTAFF ACSTDATE ACENDATE AD3100 10 0.50 1982-01-01 1982-07-01 AD3110 10 1.00 1982-01-01 1983-01-01 AD3111 60 0.80 1982-01-01 1982-04-15 AD3111 70 1.50 1982-02-15 1982-10-15 AD3111 80 1.25 1982-04-15 1983-01-15 AD3111 180 1.00 1982-10-15 1983-01-15 AD3112 60 0.75 1982-01-01 1982-05-15 AD3112 60 0.75 1982-12-01 1983-01-01 AD3112 70 0.75 1982-01-01 1982-10-15 AD3112 80 0.35 1982-08-15 1982-12-01 AD3112 180 0.50 1982-08-15 1983-01-01 AD3113 60 0.75 1982-03-01 1982-10-15 AD3113 70 1.25 1982-06-01 1982-12-15 AD3113 80 1.75 1982-01-01 1982-04-15 AD3113 180 0.75 1982-03-01 1982-07-01 IF1000 10 0.50 1982-01-01 1983-01-01 IF1000 90 1.00 1982-01-01 1983-01-01 IF1000 100 0.50 1982-01-01 1983-01-01 IF2000 10 0.50 1982-01-01 1983-01-01 IF2000 100 0.75 1982-01-01 1982-07-01 IF2000 110 0.50 1982-03-01 1982-07-01 IF2000 110 0.50 1982-10-01 1983-01-01 MA2100 10 0.50 1982-01-01 1982-11-01 MA2100 20 1.00 1982-01-01 1982-03-01 MA2110 10 1.00 1982-01-01 1983-02-01 MA2111 40 1.00 1982-01-01 1983-02-01 MA2111 50 1.00 1982-01-01 1092-06-01 MA2111 60 1.00 1982-06-01 1983-02-01 MA2112 60 2.00 1982-01-01 1982-07-01 MA2112 70 1.50 1983-02-01 1983-02-01 · · · · · · · · · · · · · · ·

Figure 67. Columns of the PROJ_ACT Table

Column Name	Description
PROJNO	Project number
ACTNO	Activity number
ACSTAFF	Estimated mean number of employees needed to staff the activity
ACSTDATE	Estimated activity start date
ACENDATE	Estimated activity completion date

The table has a composite primary key and was created with:

     CREATE TABLE PROJ_ACT
          (PROJNO     CHAR(6)      NOT NULL,
           ACTNO      SMALLINT     NOT NULL,
           ACSTAFF    DECIMAL(5,2)         ,
           ACSTDATE   DATE         NOT NULL,
           ACENDATE   DATE                 ,
           PRIMARY KEY (PROJNO, ACTNO, ACTSTDATE),
           FOREIGN KEY R_PROJ2 (PROJNO) REFERENCES PROJECT
                   ON DELETE RESTRICT,
           FOREIGN KEY R_ACTIV (ACTNO) REFERENCE ACTIVITY
                   ON DELETE RESTRICT)

Relationship to Other Tables

PROJ_ACT is a parent of the EMP_ACT table.

It is a dependent of:

• The ACTIVITY table; the foreign key on ACTNO in the PROJ_ACT table references the primary key, ACTNO, in the ACTIVITY table.
• The PROJECT table; the foreign key on PROJNO in the PROJ_ACT table references the primary key, PROJNO, in the PROJECT table.