Table: Education_Accountancy_Type
Columns
NameTypeConstraintsDescription
education_accountancy_type_KEYintNOT NULL
education_accountancy_KEYintNOT NULL
descriptionnvarchar (50)NOT NULL
Primary key
NameColumnsDescription
PK_Education_Accountancy_Type$education_accountancy_type_KEYeducation_accountancy_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Education_Accountancy_Type$education_accountancy_KEY$descriptioneducation_accountancy_KEY, descriptionEach education accountancy and description must be unique.
UK_Education_Accountancy_Type$education_accountancy_type_KEY$education_accountancy_KEYeducation_accountancy_type_KEY, education_accountancy_KEYEach education accountancy and accountancy type must be unique.
Foreign keys
NameColumnsReferenced tableDescription
FK_Education_Accountancy_Type__Education_Accountancy__education_accountancy_KEYeducation_accountancy_KEYEducation_Accountancyon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Education_Credit__Education_Accountancy_Type__education_accountancy_type_KEYeducation_accountancy_type_KEYEducation_Credit
FK_Education_Credit__Education_Accountancy_Type__education_accountancy_type_KEY__education_accountancy_KEYeducation_accountancy_type_KEY, education_accountancy_KEYEducation_Credit

Schema diagram