Table: dbo.Pay_Frequency
Columns
NameTypeConstraintsDescription
pay_frequency_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (60)NOT NULLDescription
pay_periods_per_yearint (4)NOT NULLNumber of pay periods for this frequency per year
Primary key
NameColumnsDescription
PK_Pay_Frequencypay_frequency_KEY
Unique constraints
NameColumnsDescription
UK_Pay_Frequency$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Pay_Schedule__Pay_Frequency__pay_frequency_KEYpay_frequency_KEYClient_Pay_Schedule
FK_Payroll_Bank_Transaction__Pay_Frequency__pay_frequency_KEYpay_frequency_KEYPayroll_Bank_Transaction

Schema diagram