Table: Education_Accountancy_Category
Columns
NameTypeConstraintsDescription
education_accountancy_category_KEYintNOT NULL
education_accountancy_KEYintNOT NULL
descriptionnvarchar (50)NOT NULL
Primary key
NameColumnsDescription
PK_Education_Accountancy_Category$education_accountancy_category_KEYeducation_accountancy_category_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Education_Accountancy_Category$education_accountancy_category_KEY$education_accountancy_KEYeducation_accountancy_category_KEY, education_accountancy_KEYEach education accountancy and education accountancy category must be unique.
UK_Education_Accountancy_Category$education_accountancy_KEY$descriptioneducation_accountancy_KEY, descriptionEach education accountancy and description must be unique.
Foreign keys
NameColumnsReferenced tableDescription
FK_Education_Accountancy_Category__Education_Accountancy__education_accountancy_KEYeducation_accountancy_KEYEducation_Accountancyon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Education_Credit__Education_Accountancy_Category__education_accountancy_category_KEYeducation_accountancy_category_KEYEducation_Credit
FK_Education_Credit__Education_Accountancy_Category__education_accountancy_category_KEY__education_accountancy_KEYeducation_accountancy_category_KEY, education_accountancy_KEYEducation_Credit

Schema diagram