Table: Education_Credit
Columns
Name | Type | Constraints | Description
education_credit_KEY | int | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
schedule_item_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$schedule_item_KEY | schedule_item_KEY | Index supports foreign key FK_Education_Credit__Schedule_Item__schedule_item_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_category_KEY | Education_Accountancy_Category |
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_type_KEY | Education_Accountancy_Type |
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__Schedule_Item__schedule_item_KEY | schedule_item_KEY | Schedule_Item |