Table: Client_Staff_Grouping
Columns
NameTypeConstraintsDescription
client_staff_grouping_KEYintNOT NULL
client_KEYintNOT NULL
client_staff_grouping_type_KEYintNOT NULL
lower_date_inclusivesmalldatetimeNOT NULL
staff_KEYint
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
Primary key
NameColumnsDescription
PK_Client_Staff_Grouping$client_KEY$client_staff_grouping_type_KEY$lower_date_inclusiveclient_KEY, client_staff_grouping_type_KEY, lower_date_inclusiveCLUSTERED
Unique constraints
NameColumnsDescription
UK_Client_Staff_Grouping$client_staff_grouping_KEYclient_staff_grouping_KEY
Indexes
NameColumnsDescription
IX_Client_Staff_Grouping$client_staff_grouping_type_KEYclient_staff_grouping_type_KEYIndex supports foreign key FK_Client_Staff_Grouping__Client_Staff_Grouping_Type__client_staff_grouping_type_KEY
IX_Client_Staff_Grouping$staff_KEYstaff_KEYIndex supports foreign key FK_Client_Staff_Grouping__Staff__staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Staff_Grouping__Client__client_KEYclient_KEYClienton delete cascade;
FK_Client_Staff_Grouping__Staff__staff_KEYstaff_KEYStaff

Schema diagram