Table: dbo.Bank_Feeds_Retrieved_Transaction_Rule_Applied
This table holds the information about bank feeds retrieve transactions on which bank feeds rules has been applied.
Columns
NameTypeConstraintsDescription
bank_feeds_retrieved_transaction_KEYint (4)NOT NULLThe key of bank feeds retrieve transaction table. This column is part of the 2-column primary key of this table.
bank_feeds_assignment_rule_KEYint (4)NOT NULLThe key of bank feeds assignment rule table. This column is part of the 2-column primary key of this table.
Primary key
NameColumnsDescription
PK_Bank_Feeds_Retrieved_Transaction_Rule_Applied$bank_feeds_retrieved_transaction_KEY$bank_feeds_assignment_rule_KEYbank_feeds_retrieved_transaction_KEY, bank_feeds_assignment_rule_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Feeds_Retrieved_Transaction_Rule_Applied$bank_feeds_retrieved_transaction_KEYbank_feeds_retrieved_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Feeds_Retrieved_Transaction_Rule_Applied__Bank_Feeds_Retrieved_Transaction__bank_feeds_retrieved_transaction_KEYbank_feeds_retrieved_transaction_KEYBank_Feeds_Retrieved_Transaction (bank_feeds_retrieved_transaction_KEY)
FK_Bank_Feeds_Retrieved_Transaction_Rule_Applied__Bank_Feeds_Assignment_Rule__bank_feeds_assignment_rule_KEYbank_feeds_assignment_rule_KEYBank_Feeds_Assignment_Rule (bank_feeds_assignment_rule_KEY)

Schema diagram