activity type table structure

activity type table structure#

THIS TABLE ACTIVITY TYPE CODES TO THEIR TEXT DESCRIPTION

Table Structure#

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)