Table: Billing_Rate_Type
Columns
NameTypeConstraintsDescription
billing_rate_type_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
descriptionnvarchar (30)NOT NULLUser defined description.
create_datedatetimeNOT 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_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_Staff_Target_Range_Rate__Billing_Rate_Type__billing_rate_type_KEYbilling_rate_type_KEYStaff_Target_Range_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