Table: dbo.Form_5498_Repayment_Code
Table for the repayment codes for the 5498
Columns
NameTypeConstraintsDescription
form_5498_repayment_code_KEYint (4)NOT NULLPrimary key for this table.
repayment_codenvarchar (4)NOT NULLTwo digit code for the repayment type.
descriptionnvarchar (100)NOT NULLDescription of the repayment type.
Primary key
NameColumnsDescription
PK_Form_5498_Repayment_Codeform_5498_repayment_code_KEY
Unique constraints
NameColumnsDescription
UK_Form_5498_Repayment_Code$repayment_coderepayment_code
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_5498_Option__Form_5498_Repayment_Code__corrected_override__form_5498_repayment_code_KEYcorrected_override__form_5498_repayment_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Repayment_Code__form_5498_repayment_code_KEYform_5498_repayment_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Repayment_Code__original_override__form_5498_repayment_code_KEYoriginal_override__form_5498_repayment_code_KEYForm_5498_Option
FK_Form_5498_Option__Form_5498_Repayment_Code__override__form_5498_repayment_code_KEYoverride__form_5498_repayment_code_KEYForm_5498_Option

Schema diagram