Table: dbo.Limit_Period_Type
This tables holds the limit periods.
Columns
NameTypeConstraintsDescription
limit_period_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (20)NOT NULLThe description for the limit period
Primary key
NameColumnsDescription
PK_Limit_Period_Typelimit_period_type_KEY
Unique constraints
NameColumnsDescription
UK_Limit_Period_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Item__Limit_Period_Type__limit_period_type_KEYlimit_period_type_KEYClient_Payroll_Item
FK_Employee_Payroll_Item__Limit_Period_Type__limit_period_type_KEYlimit_period_type_KEYEmployee_Payroll_Item

Schema diagram