@cfxlabsinc/b2b-services
    Preparing search index...

    Variable ledgerAccountAddressViewConst

    ledgerAccountAddressView: PgViewWithSelection<
        {
            existing: true;
            isAlias: false;
            name: "ledger_account_address";
            schema: "b2b";
            selectedFields: {
                address: PgBuildColumn<
                    "ledger_account_address",
                    SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "ledger_account_address";
                    },
                >;
                chain: PgBuildColumn<
                    "ledger_account_address",
                    Set$Type<SetNotNull<PgTextBuilder<[string, ...string[]]>>, WalletChain>,
                    {
                        data: WalletChain;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "ledger_account_address";
                    },
                >;
                customerExternalId: PgBuildColumn<
                    "ledger_account_address",
                    SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "ledger_account_address";
                    },
                >;
                customerId: PgBuildColumn<
                    "ledger_account_address",
                    SetNotNull<PgIntegerBuilder>,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "ledger_account_address";
                    },
                >;
                ledgerAccountExternalId: PgBuildColumn<
                    "ledger_account_address",
                    SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "ledger_account_address";
                    },
                >;
                ledgerAccountId: PgBuildColumn<
                    "ledger_account_address",
                    SetNotNull<PgIntegerBuilder>,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "ledger_account_address";
                    },
                >;
                walletAddressId: PgBuildColumn<
                    "ledger_account_address",
                    SetNotNull<PgIntegerBuilder>,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "ledger_account_address";
                    },
                >;
            };
        },
    > = ...

    Every address a ledger account holds, on every chain: its primary secret's wallet_address rows, plus its mintfx PDA (the LEGACY_MINTFX secret on the same wallet) when the primary is another secret, as for an imported key. A wallet several customers' ledger accounts share appears once under each, so a reader that reaches ledger accounts through it sees a shared address's transfers once per account and never under another customer. The views over on-chain history join it by name, which keeps their statement text short. .existing(): the SQL is in 20261023130833_ledger_account_address_legacy_mintfx.sql.