Table: dbo.Employee_Type
Table used to store the status of the an employee record.
Columns
NameTypeConstraintsDescription
employee_type_KEYint (4)NOT NULLInteger value representing the status.
descriptionnvarchar (60)NOT NULLDescription of the employee status.
Primary key
NameColumnsDescription
PK_Employee_Typeemployee_type_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee__Employee_Type__employee_type_KEYemployee_type_KEYEmployee

Schema diagram