Table: Education_Course | |||
Columns | |||
Name | Type | Constraints | Description |
education_course_KEY | int | NOT NULL | |
update__staff_KEY | int | NOT NULL | |
update_date | datetime | NOT NULL | |
schedule_item_KEY | int | NOT NULL | |
education_sponsor_KEY | int | NOT NULL | |
education_delivery_format_KEY | int | NOT NULL | |
location | nvarchar (30) | NOT NULL | |
instructor | nvarchar (30) | NOT NULL | |
cost | decimal (9, 2) | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Education_Course$education_course_KEY | education_course_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Education_Course__schedule_item_KEY | schedule_item_KEY | Each [Education_Course] is its own [Schedule_Item]. | |
Indexes | |||
Name | Columns | Description | |
IX_Education_Course$education_delivery_format_KEY | education_delivery_format_KEY | Index supports foreign key FK_Education_Course__Education_Delivery_Format__education_delivery_format_KEY | |
IX_Education_Course$education_sponsor_KEY | education_sponsor_KEY | Index supports foreign key FK_Education_Course__Education_Sponsor__education_sponsor_KEY |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Education_Credit__Education_Course__education_course_KEY | education_course_KEY | Education_Credit | |
FK_Sheet_Entry__Education_Course__education_course_KEY | education_course_KEY | Sheet_Entry |