Table: dbo.Deduction_Type
Columns
NameTypeConstraintsDescription
deduction_type_KEYint (4)NOT NULLPrimary surrogate key for this table
deduction_idnvarchar (70)NOT NULLBenefit number
descriptionnvarchar (60)NOT NULLBenefit description
Primary key
NameColumnsDescription
PK_Deduction_Typededuction_type_KEY
Unique constraints
NameColumnsDescription
UK_Deduction_Type$deduction_iddeduction_id
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Item__Deduction_Type__special__deduction_type_KEYspecial__deduction_type_KEYClient_Payroll_Item

Schema diagram