Table: dbo.Employee_Earning_Type
The table used to store the employee earning type options.
Columns
NameTypeConstraintsDescription
employee_earning_type_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (60)NOT NULLDescription for this type table.
Primary key
NameColumnsDescription
PK_Employee_Earning_Typeemployee_earning_type_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Earning_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee__Employee_Earning_Type__current__employee_earning_type_KEYcurrent__employee_earning_type_KEYEmployee
FK_Payroll_Bank_Transaction__Employee_Earning_Type__employee_earning_type_KEYemployee_earning_type_KEYPayroll_Bank_Transaction

Schema diagram