Table: dbo.Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item
This dictionary table associates payable transaction worker compensation items with the liabilities created from them.
Columns
NameTypeConstraintsDescription
payable_transaction_n_payroll_bank_transaction_worker_compensation_item_KEYint (4)NOT NULLSurrogate primary key for the table.
payable_transaction_KEYint (4)NOT NULLForeign key to Payable_Transaction table.
payroll_bank_transaction_worker_compensation_item_KEYint (4)NOT NULLForeign key to Payroll_Bank_Transaction_Worker_Compensation_Item table.
Primary key
NameColumnsDescription
PK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Itempayable_transaction_n_payroll_bank_transaction_worker_compensation_item_KEY
Unique constraints
NameColumnsDescription
UK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item$payroll_bank_transaction_worker_compensation_item_KEYpayroll_bank_transaction_worker_compensation_item_KEY, payable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item__Payroll_Bank_Transaction_Worker_Compensation_Item__ppayroll_bank_transaction_worker_compensation_item_KEYPayroll_Bank_Transaction_Worker_Compensation_Item (payroll_bank_transaction_worker_compensation_item_KEY)
FK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)

Schema diagram