Table: dbo.Benefit_Transaction_Type
The table defines benefit transaction types.
Columns
NameTypeConstraintsDescription
benefit_transaction_type_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (40)NOT NULLBenefit transaction type description.
Primary key
NameColumnsDescription
PK_Benefit_Transaction_Typebenefit_transaction_type_KEY
Unique constraints
NameColumnsDescription
UK_Benefit_Transaction_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Benefit_Transaction__Benefit_Transaction_Type__benefit_transaction_type_KEYbenefit_transaction_type_KEYBenefit_Transaction

Schema diagram