Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(60)   Default = '' Name of the Class.
 SECTION nvarchar(20)   Default = '' Class section.
 STARTDATE date   This is the first date covered by this class.
 ENDDATE date   This is the last date covered by this class.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 CLASSSIZEMINIMUM smallint   Default = ((0))
 CLASSSIZETARGET smallint   Default = ((0))
 CLASSSIZEMAXIMUM smallint   Default = ((0))
 CLASSESPERTERMMINIMUM smallint   Default = ((0))
 CLASSESPERTERMTARGET smallint   Default = ((0))
 CLASSESPERTERMMAXIMUM smallint   Default = ((0))
 USECATEGORYPERCENTAGES bit   Default = 0 Indicates whether the class is graded using category percentages or total points.

Foreign Key Field Type Null Notes Description
 COURSEID uniqueidentifier   COURSE.ID A foreign key to the course table.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_CLASS_DATEADDED DATEADDED    
 IX_CLASS_DATECHANGED DATECHANGED      
 PK_CLASS ID  

Trigger Name Description
 TR_CLASS_AUDIT_UPDATE
 TR_CLASS_AUDIT_DELETE

Referenced by Field
 CLASSASSIGNMENT CLASSID
 CLASSCATEGORY CLASSID
 CLASSMEETINGGROUP CLASSID

Entity-Relationship diagram of this table