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 |