activity type table structure#
THIS TABLE ACTIVITY TYPE CODES TO THEIR TEXT DESCRIPTION
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
---|---|---|---|---|---|
activity_type_id* |
INTEGER |
NO |
|||
activity_type_description |
TEXT |
NO |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Activity_Type" (
"activity_type_id" INTEGER NOT NULL PRIMARY KEY,
"activity_type_description" TEXT NOT NULL)