Table: Staff_Rate_Table
Columns
NameTypeConstraintsDescription
staff_rate_table_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
staff_KEYintNOT NULLForeign key of the staff this Rate Table belongs to.
effective_datesmalldatetimeNOT NULLThe date this rate table becomes effective.
hourly_costdecimal (9, 2)NOT NULLThe cost per hour.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Staff_Rate_Table$staff_rate_table_KEYstaff_rate_table_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Rate_Table$staff_KEY$effective_datestaff_KEY, effective_date
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Rate_Table__Staff__staff_KEYstaff_KEYStaff
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Staff_Billing_Rate__Staff_Rate_Table__staff_rate_table_KEYstaff_rate_table_KEYStaff_Billing_Rateon delete cascade;

Schema diagram