Table: dbo.Payroll_Journal_Entry_Option_Date_Type
Type table describing the date types of the Payroll_Journal_Entry_Option table
Columns
NameTypeConstraintsDescription
payroll_journal_entry_option_date_type_KEYint (4)NOT NULLPrimary key of the Payroll_Journal_Entry_Option_Date_Type
descriptionnvarchar (60)NOT NULLDescription of what each key means
Primary key
NameColumnsDescription
PK_Payroll_Journal_Entry_Option_Date_Typepayroll_journal_entry_option_date_type_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Journal_Entry_Option_Date_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Journal_Entry_Option__Payroll_Journal_Entry_Option_Date_Type__payroll_journal_entry_option_date_type_KEYpayroll_journal_entry_option_date_type_KEYPayroll_Journal_Entry_Option

Schema diagram