Table: Education_Course
Columns
NameTypeConstraintsDescription
education_course_KEYintNOT NULL
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
schedule_item_KEYintNOT NULL
education_sponsor_KEYintNOT NULL
education_delivery_format_KEYintNOT NULL
locationnvarchar (30)NOT NULL
instructornvarchar (30)NOT NULL
costdecimal (9, 2)NOT NULL
Primary key
NameColumnsDescription
PK_Education_Course$education_course_KEYeducation_course_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Education_Course__schedule_item_KEYschedule_item_KEYEach [Education_Course] is its own [Schedule_Item].
Indexes
NameColumnsDescription
IX_Education_Course$education_delivery_format_KEYeducation_delivery_format_KEYIndex supports foreign key FK_Education_Course__Education_Delivery_Format__education_delivery_format_KEY
IX_Education_Course$education_sponsor_KEYeducation_sponsor_KEYIndex supports foreign key FK_Education_Course__Education_Sponsor__education_sponsor_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Education_Course__Education_Delivery_Format__education_delivery_format_KEYeducation_delivery_format_KEYEducation_Delivery_Format
FK_Education_Course__Education_Sponsor__education_sponsor_KEYeducation_sponsor_KEYEducation_Sponsor
FK_Education_Course__Schedule_Item__schedule_item_KEYschedule_item_KEYSchedule_Item
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Education_Credit__Education_Course__education_course_KEYeducation_course_KEYEducation_Credit
FK_Sheet_Entry__Education_Course__education_course_KEYeducation_course_KEYSheet_Entry

Schema diagram