Table: dbo.Tip_Allocation_Method
The table used to store the different types of Tip Allocation methods.
Columns
NameTypeConstraintsDescription
tip_allocation_method_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (30)NOT NULLDescription of the Tip Allocation method.
Primary key
NameColumnsDescription
PK_Tip_Allocation_Methodtip_allocation_method_KEY
Unique constraints
NameColumnsDescription
UK_Tip_Allocation_Method$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_Tip_Total__Tip_Allocation_Method__tip_allocation_method_KEYtip_allocation_method_KEYEmployee_Tip_Total

Schema diagram