Table: Education_Credit
Columns
Name | Type | Constraints | Description
education_credit_KEY | int | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
education_course_KEY | int | NOT NULL |
education_accountancy_KEY | int | NOT NULL |
education_accountancy_category_KEY | int | NOT NULL |
education_accountancy_type_KEY | int | NOT NULL |
credit | decimal (9, 2) | NOT NULL |

Primary key
Name | Columns | Description
PK_Education_Credit$education_credit_KEY | education_credit_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Education_Credit$education_accountancy_KEY | education_accountancy_KEY | Index supports foreign key FK_Education_Credit__Education_Accountancy__education_accountancy_KEY
IX_Education_Credit$education_accountancy_KEY$education_accountancy_category_KEY | education_accountancy_KEY, education_accountancy_category_KEY | Index 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_KEY | education_accountancy_KEY, education_accountancy_type_KEY | Index supports foreign key FK_Education_Credit__Education_Accountancy_Type__education_accountancy_KEY__education_accountancy_type_KEY
IX_Education_Credit$education_course_KEY | education_course_KEY | Index supports foreign key FK_Education_Credit__Education_Course__education_course_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Education_Credit__Education_Accountancy__education_accountancy_KEY | education_accountancy_KEY | Education_Accountancy |
FK_Education_Credit__Education_Accountancy_Category__education_accountancy_category_KEY__education_accountancy_KEY | education_accountancy_category_KEY, education_accountancy_KEY | Education_Accountancy_Category |
FK_Education_Credit__Education_Accountancy_Type__education_accountancy_type_KEY__education_accountancy_KEY | education_accountancy_type_KEY, education_accountancy_KEY | Education_Accountancy_Type |
FK_Education_Credit__Education_Course__education_course_KEY | education_course_KEY | Education_Course |