Table: dbo.Swipe_Clock_Options_Type
This table holds the description of Swipe Clock Option Type available. It is used to provide options in combo box.
Columns
NameTypeConstraintsDescription
swipe_clock_options_type_KEYtinyint (1)NOT NULLKey for swipe clock options type table
descriptionnvarchar (100)NOT NULLdescription for swipe clock option type
Primary key
NameColumnsDescription
PK_Swipe_Clock_Options_Typeswipe_clock_options_type_KEY
Unique constraints
NameColumnsDescription
UK_Swipe_Clock_Options_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Information__Swipe_Clock_Options_Type__swipe_clock_options_type_KEYswipe_clock_options_type_KEYClient_Payroll_Information

Schema diagram