Table: Staff_Billing_Rate
Columns
NameTypeConstraintsDescription
staff_billing_rate_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
staff_rate_table_KEYintNOT NULLForeign key to the Staff Rate Table. There can be several Staff Billing Rates per Staff Rate Table
billing_rate_type_KEYintNOT NULLForeign key to one of the already set up Billing Rate Types (unique per staff_rate_table_KEY).
billable_ratedecimal (9, 2)NOT NULLThe rate billed per hour for this Staff Billing Rate.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Staff_Billing_Rate$staff_billing_rate_KEYstaff_billing_rate_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Billing_Rate$staff_rate_table_KEY$billing_rate_type_KEYstaff_rate_table_KEY, billing_rate_type_KEY
Indexes
NameColumnsDescription
IX_Staff_Billing_Rate$billing_rate_type_KEYbilling_rate_type_KEYIndex supports foreign key FK_Staff_Billing_Rate__Billing_Rate_Type__billing_rate_type_KEY
IX_Staff_Billing_Rate$staff_rate_table_KEY@@@staff_rate_table_KEY, billable_rate, billing_rate_type_KEY, staff_billing_rate_KEY, update__staff_KEY, update_date_utcAn index that greatly speeds up importing conversion data.
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Billing_Rate__Billing_Rate_Type__billing_rate_type_KEYbilling_rate_type_KEYBilling_Rate_Type
FK_Staff_Billing_Rate__Staff_Rate_Table__staff_rate_table_KEYstaff_rate_table_KEYStaff_Rate_Tableon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Sheet_Entry__Staff_Billing_Rate__staff_billing_rate_KEYstaff_billing_rate_KEYSheet_Entry

Schema diagram