Table: Billing_Rate_Type
Columns
Name | Type | Constraints | Description
billing_rate_type_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
description | nvarchar (30) | NOT NULL | User defined description.
create_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Billing_Rate_Type$billing_rate_type_KEY | billing_rate_type_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Billing_Rate_Type__description | description | Each description must be unique.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Activity__Billing_Rate_Type__billing_rate_type_KEY | billing_rate_type_KEY | Activity |
FK_Engagement__Billing_Rate_Type__billing_rate_type_KEY | billing_rate_type_KEY | Engagement |
FK_Staff_Billing_Rate__Billing_Rate_Type__billing_rate_type_KEY | billing_rate_type_KEY | Staff_Billing_Rate |
FK_Staff_Target_Range_Rate__Billing_Rate_Type__billing_rate_type_KEY | billing_rate_type_KEY | Staff_Target_Range_Rate |
FK_User_Preference__Billing_Rate_Type__entry_expense__billing_rate_type_KEY | entry_expense__billing_rate_type_KEY | User_Preference |
FK_User_Preference__Billing_Rate_Type__entry_time__billing_rate_type_KEY | entry_time__billing_rate_type_KEY | User_Preference |