Table: dbo.Direct_Deposit_Bank_Transaction
Columns
Name | Type | Constraints | Description
bank_transaction_KEY | int (4) | NOT NULL | Primary key and foreign key to the parent bank transaction
fund_payroll_transaction_type_KEY | int (4) | NOT NULL | Contains a key to the type of fund payroll transaction selected when this transaction was processed.

Primary key
Name | Columns | Description
PK_Direct_Deposit_Bank_Transaction$bank_transaction_KEY | bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Direct_Deposit_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Direct_Deposit_Bank_Transaction__Fund_Payroll_Transaction_Type__fund_payroll_transaction_type_KEY | fund_payroll_transaction_type_KEY | Fund_Payroll_Transaction_Type (fund_payroll_transaction_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Direct_Deposit_Bank_Transaction_Allocation__Direct_Deposit_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Direct_Deposit_Bank_Transaction_Allocation |