Table: Education_Sponsor
Columns
NameTypeConstraintsDescription
education_sponsor_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
create_date_utcdatetimeNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
education_sponsor_idnvarchar (11)NOT NULLUser defined identifier (unique).
descriptionnvarchar (250)NOT NULLUser defined description.
education_sponsor_id_sortablevarchar (48)NOT NULLA representation of the education_sponsor_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of education_sponsor_id.
Primary key
NameColumnsDescription
PK_Education_Sponsor$education_sponsor_KEYeducation_sponsor_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Education_Sponsor$education_sponsor_ideducation_sponsor_idEach education sponsor must be unique.
UK_Education_Sponsor$education_sponsor_id_sortableeducation_sponsor_id_sortableAn index by the sortable ID is desired, and the algorithm ends up producing unique values.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Schedule_Item__Education_Sponsor__education_sponsor_KEYeducation_sponsor_KEYSchedule_Item

Schema diagram