Table: Client_Staff_Grouping | |||
Columns | |||
Name | Type | Constraints | Description |
client_staff_grouping_KEY | int | NOT NULL | |
client_KEY | int | NOT NULL | |
client_staff_grouping_type_KEY | int | NOT NULL | |
lower_date_inclusive | smalldatetime | NOT NULL | |
staff_KEY | int | ||
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Client_Staff_Grouping$client_KEY$client_staff_grouping_type_KEY$lower_date_inclusive | client_KEY, client_staff_grouping_type_KEY, lower_date_inclusive | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Client_Staff_Grouping$client_staff_grouping_KEY | client_staff_grouping_KEY | ||
Indexes | |||
Name | Columns | Description | |
IX_Client_Staff_Grouping$client_staff_grouping_type_KEY | client_staff_grouping_type_KEY | Index supports foreign key FK_Client_Staff_Grouping__Client_Staff_Grouping_Type__client_staff_grouping_type_KEY | |
IX_Client_Staff_Grouping$staff_KEY | staff_KEY | Index supports foreign key FK_Client_Staff_Grouping__Staff__staff_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Client_Staff_Grouping__Client__client_KEY | client_KEY | Client | on delete cascade; |
FK_Client_Staff_Grouping__Staff__staff_KEY | staff_KEY | Staff |