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

ACTIVITY Table

The ACTIVITY tables describes the activities that can be performed during a project. The table acts as a master list of possible activities, identifying the activity number, and providing a description of the activity. Figure 64 shows table contents; Figure 65 shows a description of the columns.

Figure 64. ACTIVITY Table Contents

ACTNO	ACTKWD	ACTDESC
160	ADMDB	Adm databases
170	ADMDC	Adm data comm
90	ADMQS	Adm query system
150	ADMSYS	Adm operating sys
70	CODE	Code programs
110	COURSE	Develop courses
30	DEFINE	Define specs
180	DOC	Document
20	ECOST	Estimate cost
40	LEADPR	Lead program/design
60	LOGIC	Describe logic
140	MAINT	Maint software sys
10	MANAGE	Manage/advise
130	OPERAT	Oper computer sys
50	SPECS	Write specs
120	STAFF	Pers and staffing
100	TEACH	Teach classes
80	TEST	Test programs

Figure 65. Columns of the ACTIVITY Table

Column Name Description ACTNO Activity number (the primary key) ACTKWD Activity keyword (up to six characters) ACTDESC Activity description

The ACTIVITY table is created with:

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

Relationship to Other Tables

ACTIVITY is a parent of the PROJ_ACT table.