Table: Billing_Rate_Type
Columns
NameTypeConstraintsDescription
billing_rate_type_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLUser defined description.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Billing_Rate_Type$billing_rate_type_KEYbilling_rate_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Billing_Rate_Type$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Activity__Billing_Rate_Type__billing_rate_type_KEYbilling_rate_type_KEYActivity
FK_Staff_Target_Range__Billing_Rate_Type__billing_rate_type_KEYbilling_rate_type_KEYStaff_Target_Range
FK_Engagement__Billing_Rate_Type__billing_rate_type_KEYbilling_rate_type_KEYEngagement
FK_Staff_Billing_Rate__Billing_Rate_Type__billing_rate_type_KEYbilling_rate_type_KEYStaff_Billing_Rate
FK_User_Preference__Billing_Rate_Type__entry_expense__billing_rate_type_KEYentry_expense__billing_rate_type_KEYUser_Preference
FK_User_Preference__Billing_Rate_Type__entry_time__billing_rate_type_KEYentry_time__billing_rate_type_KEYUser_Preference

Schema diagram