Table: dbo.Direct_Deposit_Bank_Transaction
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLPrimary key and foreign key to the parent bank transaction
fund_payroll_transaction_type_KEYint (4)NOT NULLContains a key to the type of fund payroll transaction selected when this transaction was processed.
Primary key
NameColumnsDescription
PK_Direct_Deposit_Bank_Transaction$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Direct_Deposit_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Direct_Deposit_Bank_Transaction__Fund_Payroll_Transaction_Type__fund_payroll_transaction_type_KEYfund_payroll_transaction_type_KEYFund_Payroll_Transaction_Type (fund_payroll_transaction_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Direct_Deposit_Bank_Transaction_Allocation__Direct_Deposit_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYDirect_Deposit_Bank_Transaction_Allocation

Schema diagram