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 |