| Table: dbo.Firm_Notification_Hourly_Pay_Rate | |||
| A table to store standard hourly pay rate used as a threshold in determining if an alert is needed. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| firm_notification_information_KEY | tinyint (1) | NOT NULL | The primary key and Firm notification_information KEY associated with Firm notification information. |
| hourly_pay_rate | decimal (9, 4) | NOT NULL | hourly pay rate for associated firm notification information. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Firm_Notification_Hourly_Pay_Rate$firm_notification_information_KEY | firm_notification_information_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Firm_Notification_Hourly_Pay_Rate__Firm_Notification_Information__firm_notification_information_KEY | firm_notification_information_KEY | Firm_Notification_Information (firm_notification_information_KEY) | |