Table: Staff_Billing_Rate
Columns
Name | Type | Constraints | Description
staff_billing_rate_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
staff_rate_table_KEY | int | NOT NULL | Foreign key to the Staff Rate Table. There can be several Staff Billing Rates per Staff Rate Table
billing_rate_type_KEY | int | NOT NULL | Foreign key to one of the already set up Billing Rate Types (unique per staff_rate_table_KEY).
billable_rate | decimal (9, 2) | NOT NULL | The rate billed per hour for this Staff Billing Rate.
create_date_utc | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Staff_Billing_Rate$staff_billing_rate_KEY | staff_billing_rate_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Staff_Billing_Rate$staff_rate_table_KEY$billing_rate_type_KEY | staff_rate_table_KEY, billing_rate_type_KEY |
Indexes
Name | Columns | Description
IX_Staff_Billing_Rate$billing_rate_type_KEY | billing_rate_type_KEY | Index 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_utc | An index that greatly speeds up importing conversion data.

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_Billing_Rate__Billing_Rate_Type__billing_rate_type_KEY | billing_rate_type_KEY | Billing_Rate_Type |
FK_Staff_Billing_Rate__Staff_Rate_Table__staff_rate_table_KEY | staff_rate_table_KEY | Staff_Rate_Table | on delete cascade;

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Sheet_Entry__Staff_Billing_Rate__staff_billing_rate_KEY | staff_billing_rate_KEY | Sheet_Entry |