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
NameTypeConstraintsDescription
firm_notification_information_KEYtinyint (1)NOT NULLThe primary key and Firm notification_information KEY associated with Firm notification information.
hourly_pay_ratedecimal (9, 4)NOT NULLhourly pay rate for associated firm notification information.
Primary key
NameColumnsDescription
PK_Firm_Notification_Hourly_Pay_Rate$firm_notification_information_KEYfirm_notification_information_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Notification_Hourly_Pay_Rate__Firm_Notification_Information__firm_notification_information_KEYfirm_notification_information_KEYFirm_Notification_Information (firm_notification_information_KEY)

Schema diagram