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 | tinyint (3) | 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__Client_Staff_Grouping_Type__client_staff_grouping_type_KEY | client_staff_grouping_type_KEY | Client_Staff_Grouping_Type |
FK_Client_Staff_Grouping__Staff__staff_KEY | staff_KEY | Staff |