Table: dbo.Tax_Period_Frequency
Columns
NameTypeConstraintsDescription
tax_period_frequency_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (60)NOT NULLDescription
periods_per_yearint (4)NOT NULLNumber of tax periods for this frequency per year
Primary key
NameColumnsDescription
PK_Tax_Period_Frequencytax_period_frequency_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Period_Frequency$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Agent_Direct_Deposit_Tax_Payment_Information__Tax_Period_Frequency__tax_period_frequency_KEYtax_period_frequency_KEYTax_Agent_Direct_Deposit_Tax_Payment_Information

Schema diagram