Activity table (ACT)

The activity table describes each activity.

The activity table is created with the following CREATE TABLE statement:

CREATE TABLE ACT 
             (ACTNO SMALLINT NOT NULL, 
              ACTKWD CHAR(6) NOT NULL, 
              ACTDESC VARCHAR(20) NOT NULL, 
              PRIMARY KEY (ACTNO))

The following indexes are created:

CREATE UNIQUE INDEX XACT1 
              ON ACT (ACTNO)

CREATE UNIQUE INDEX XACT2 
              ON ACT (ACTKWD)

The table below shows the contents of the columns.

Column name Description
ACTNO Activity number
ACTKWD Keyword for activity
ACTDESC Description of activity