Footprints Data Model

Table
Name asgnmt_type
Comment
The assignment type indicates the notification level of the assignment.  The
current types consist of the following: Regular Assignment, CC Assignment,
Primary Assignment .

Column
Name Datatype Comment Is PK Is FK
asgnmt_type_id int The automatically generated primary key of the asgnmt_type table. Yes No
asgnmt_type_name varchar(255) The name of the Assignment Type. No No
asgnmt_type_descr varchar(512)
A descriptive name of the Assignment Type.  This descriptive name may be
localized.
No No