The BANK_INSTRUCTION arm of bankAccountView — CFX's own accounts at
each partner bank, with balances implied from the bank_transaction feed.
The only arm with no owner columns at all. That is not missing data: these
accounts belong to CFX, so there is no customer or entity to resolve, and
projecting the operating customer here would be a claim the schema does not
make.
It is also the only arm where keyable is genuinely computed rather than a
TRUE literal — see bankInstructionAccountView for the two shapes
that lack half the key. Those rows still appear, with NULL across all nine
balance columns; suppressing them would hide a real account, and rendering
0 would assert it is empty.
dbmate owns the DDL: the body below is mirrored by
20261017164913_bank_account_view_search_text.sql.
The
BANK_INSTRUCTIONarm of bankAccountView — CFX's own accounts at each partner bank, with balances implied from thebank_transactionfeed.The only arm with no owner columns at all. That is not missing data: these accounts belong to CFX, so there is no customer or entity to resolve, and projecting the operating customer here would be a claim the schema does not make.
It is also the only arm where
keyableis genuinely computed rather than aTRUEliteral — see bankInstructionAccountView for the two shapes that lack half the key. Those rows still appear, with NULL across all nine balance columns; suppressing them would hide a real account, and rendering0would assert it is empty.dbmate owns the DDL: the body below is mirrored by
20261017164913_bank_account_view_search_text.sql.