Table: Education_Credit
Columns
NameTypeConstraintsDescription
education_credit_KEYintNOT NULL
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
education_course_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$education_course_KEYeducation_course_KEYIndex supports foreign key FK_Education_Credit__Education_Course__education_course_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_KEY__education_accountancy_KEYeducation_accountancy_category_KEY, education_accountancy_KEYEducation_Accountancy_Category
FK_Education_Credit__Education_Accountancy_Type__education_accountancy_type_KEY__education_accountancy_KEYeducation_accountancy_type_KEY, education_accountancy_KEYEducation_Accountancy_Type
FK_Education_Credit__Education_Course__education_course_KEYeducation_course_KEYEducation_Course

Schema diagram