Table: Education_Credit
Columns
NameTypeConstraintsDescription
education_credit_KEYintNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
schedule_item_KEYintNOT NULL
education_accountancy_KEYintNOT NULL
education_accountancy_category_KEYintNOT NULL
education_accountancy_type_KEYintNOT NULL
creditdecimal (9, 2)NOT NULL
Primary key
NameColumnsDescription
PK_Education_Credit$education_credit_KEYeducation_credit_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Education_Credit$education_accountancy_KEYeducation_accountancy_KEYIndex supports foreign key FK_Education_Credit__Education_Accountancy__education_accountancy_KEY
IX_Education_Credit$education_accountancy_KEY$education_accountancy_category_KEYeducation_accountancy_KEY, education_accountancy_category_KEYIndex supports foreign key FK_Education_Credit__Education_Accountancy_Category__education_accountancy_KEY__education_accountancy_category_KEY
IX_Education_Credit$education_accountancy_KEY$education_accountancy_type_KEYeducation_accountancy_KEY, education_accountancy_type_KEYIndex supports foreign key FK_Education_Credit__Education_Accountancy_Type__education_accountancy_KEY__education_accountancy_type_KEY
IX_Education_Credit$schedule_item_KEYschedule_item_KEYIndex supports foreign key FK_Education_Credit__Schedule_Item__schedule_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Education_Credit__Education_Accountancy__education_accountancy_KEYeducation_accountancy_KEYEducation_Accountancy
FK_Education_Credit__Education_Accountancy_Category__education_accountancy_category_KEYeducation_accountancy_category_KEYEducation_Accountancy_Category
FK_Education_Credit__Education_Accountancy_Category__education_accountancy_category_KEY__education_accountancy_KEYeducation_accountancy_category_KEY, education_accountancy_KEYEducation_Accountancy_Category
FK_Education_Credit__Education_Accountancy_Type__education_accountancy_type_KEYeducation_accountancy_type_KEYEducation_Accountancy_Type
FK_Education_Credit__Education_Accountancy_Type__education_accountancy_type_KEY__education_accountancy_KEYeducation_accountancy_type_KEY, education_accountancy_KEYEducation_Accountancy_Type
FK_Education_Credit__Schedule_Item__schedule_item_KEYschedule_item_KEYSchedule_Item

Schema diagram