Table: dbo.Tax_Deferral_Reason
This type table enables us to know the exact reason for which the tax has been deferred.
Columns
NameTypeConstraintsDescription
tax_deferral_reason_KEYtinyint (1)NOT NULLPrimary key for type table
descriptionnvarchar (100)NOT NULLThe reason for the tax deferral
Primary key
NameColumnsDescription
PK_Tax_Deferral_Reasontax_deferral_reason_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Deferral_Reason$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payable_Transaction__Tax_Deferral_Reason__tax_deferral_reason_KEYtax_deferral_reason_KEYPayable_Transaction

Schema diagram