Table: dbo.Bank_Feeds_Bank_Transaction
This table keeps track of which bank transactions were imported from a yodlee transaction or matched to a yodlee transaction.
Columns
NameTypeConstraintsDescription
bank_feeds_bank_transaction_KEYint (4)NOT NULLThe primary key of bank_feeds_bank_transaction. This column is introduced to accommodate future filtering needs.
bank_transaction_KEYint (4)NOT NULLThe bank transaction that was matched or imported via bank feeds.
transaction_idbigint (8)NOT NULLThe id of the yodlee transaction.
Primary key
NameColumnsDescription
PK_Bank_Feeds_Bank_Transactionbank_feeds_bank_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Feeds_Bank_Transaction$bank_transaction_KEY$transaction_idbank_transaction_KEY, transaction_id
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Feeds_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)

Schema diagram