Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(60)   Default = '' Name of the Course.
 DESCRIPTION nvarchar(1024)   Default = '' Description of the Course.
 COURSEID nvarchar(12)   Default = '' Course number.
 ISINACTIVE bit   Default = 0 Indicates whether the course is no longer offered.
 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.
 GENDERCODE tinyint   Default = 0 The gender of the course.
 GENDER nvarchar(6) (Computed) CASE [GENDERCODE] WHEN 0 THEN N'Coed' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' END Provides a translation for the 'GENDERCODE' field.
 CLASSSIZEMINIMUM smallint   Default = ((0))
 CLASSSIZETARGET smallint   Default = ((0))
 CLASSSIZEMAXIMUM smallint   Default = ((0))
 CLASSESPERTERMMINIMUM smallint   Default = ((0))
 CLASSESPERTERMTARGET smallint   Default = ((0))
 CLASSESPERTERMMAXIMUM smallint   Default = ((0))
 SELECTEDTYPESCODE tinyint   Default = 0 Flag indicating which course types are included.
 SELECTEDDEPARTMENTSCODE tinyint   Default = 2 Flag indicating which departments are included.
 SELECTEDTYPES nvarchar(34) (Computed) CASE [SELECTEDTYPESCODE] WHEN 0 THEN N'Specify all course types on course' WHEN 1 THEN N'Only the following course types' WHEN 2 THEN N'No course types' END Provides a translation for the 'SELECTEDTYPESCODE' field.
 SELECTEDDEPARTMENTS nvarchar(33) (Computed) CASE [SELECTEDDEPARTMENTSCODE] WHEN 0 THEN N'Specify all departments on course' WHEN 1 THEN N'Only the following departments' WHEN 2 THEN N'No departments' END Provides a translation for the 'SELECTEDDEPARTMENTSCODE' field.
 PRINTONSCHEDULE bit   Default = 1 Indicates whether the course should be included when printing schedules.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 SCHOOLID uniqueidentifier   SCHOOL.ID A foreign key to the school giving the course.

Index Name Field(s) Unique Primary Clustered
 IX_COURSE_DATEADDED DATEADDED    
 IX_COURSE_DATECHANGED DATECHANGED      
 PK_COURSE ID  
 UIX_COURSE_COURSEID_SCHOOLID COURSEID, SCHOOLID    

Trigger Name Description
 TR_COURSE_AUDIT_UPDATE
 TR_COURSE_AUDIT_DELETE

Referenced by Field
 CLASS COURSEID
 CORECURRICULUMCOURSE COURSEID
 COURSEACADEMICCATALOGDEPARTMENT COURSEID
 COURSEASSIGNMENT COURSEID
 COURSEATTACHMENT COURSEID
 COURSEGRADELEVEL COURSEID
 COURSEGRADING COURSEID
 COURSEMEDIALINK COURSEID
 COURSENOTE COURSEID
 COURSERESTRICTION COURSEID
 COURSETYPE COURSEID
 FACULTYCOURSE COURSEID
 STUDENTCOURSE COURSEID
 STUDENTSKILLCOURSE COURSEID

Entity-Relationship diagram of this table