Table: Staff_Rate_Table | |||
Columns | |||
Name | Type | Constraints | Description |
staff_rate_table_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_KEY | int | NOT NULL | Foreign key of the staff this Rate Table belongs to. |
effective_date | smalldatetime | NOT NULL | The date this rate table becomes effective. |
hourly_cost | decimal (9, 2) | NOT NULL | The cost per hour. |
create_date_utc | datetime | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Staff_Rate_Table$staff_rate_table_KEY | staff_rate_table_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Staff_Rate_Table$staff_KEY$effective_date | staff_KEY, effective_date |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Staff_Rate_Table__Staff__staff_KEY | staff_KEY | Staff |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Staff_Billing_Rate__Staff_Rate_Table__staff_rate_table_KEY | staff_rate_table_KEY | Staff_Billing_Rate | on delete cascade; |