Table: dbo.Form_5498_Other_Contribution_Code
Table for the other contribution codes for the 5498
Columns
NameTypeConstraintsDescription
form_5498_other_contribution_code_KEYint (4)NOT NULLPrimary key for this table.
other_contribution_codenvarchar (4)NOT NULLTwo digit code for the other contribution type.
descriptionnvarchar (80)NOT NULLDescription of the other contribution type.
Primary key
NameColumnsDescription
PK_Form_5498_Other_Contribution_Codeform_5498_other_contribution_code_KEY
Unique constraints
NameColumnsDescription
UK_Form_5498_Other_Contribution_Code$other_contribution_codeother_contribution_code
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__corrected_override__form_5498_other_contribution_code_KEYcorrected_override__form_5498_other_contribution_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__form_5498_other_contribution_code_KEYform_5498_other_contribution_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__original_override__form_5498_other_contribution_code_KEYoriginal_override__form_5498_other_contribution_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__override__form_5498_other_contribution_code_KEYoverride__form_5498_other_contribution_code_KEYForm_5498_Option

Schema diagram