Activity table (ACT)

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.