Table: Education_Accountancy
Columns
NameTypeConstraintsDescription
education_accountancy_KEYintNOT NULL
descriptionnvarchar (50)NOT NULL
Primary key
NameColumnsDescription
PK_Education_Accountancy$education_accountancy_KEYeducation_accountancy_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Education_Accountancy$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Education_Accountancy_Category__Education_Accountancy__education_accountancy_KEYeducation_accountancy_KEYEducation_Accountancy_Categoryon delete cascade;
FK_Education_Accountancy_Type__Education_Accountancy__education_accountancy_KEYeducation_accountancy_KEYEducation_Accountancy_Typeon delete cascade;
FK_Education_Credit__Education_Accountancy__education_accountancy_KEYeducation_accountancy_KEYEducation_Credit

Schema diagram