Variable walletBalanceView`Const`

walletBalanceView: PgViewWithSelection<
    {
        existing: true;
        isAlias: false;
        name: "wallet_balance";
        schema: "b2b";
        selectedFields: {
            address: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
            amount: PgBuildColumn<
                "wallet_balance",
                SetNotNull<PgNumericBuilder>,
                {
                    data: string;
                    dataType: "string numeric";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: true;
                    tableName: "wallet_balance";
                },
            >;
            chain: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
            customerExternalId: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
            customerId: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
            ledgerAccountExternalId: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
            ledgerAccountId: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
            symbol: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
            tokenId: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
            uiAmount: PgBuildColumn<
                "wallet_balance",
                SetNotNull<PgNumericBuilder>,
                {
                    data: string;
                    dataType: "string numeric";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: true;
                    tableName: "wallet_balance";
                },
            >;
            walletAddressId: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
            walletId: PgBuildColumn<
                "wallet_balance",
                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: "wallet_balance";
                },
            >;
        };
    },
> = ...

A ledger account's balance per address and token, through its wallet: every address counts, legacy ones until swept, except a LEGACY_MINTFX secret naming another account (20261107191757_wallet_balance_own_mintfx_pda.sql). amount in base units, uiAmount scaled by the token's decimals. Off Solana, the chain's balance at the latest wallet_balance_snapshot plus the rows landed since. .existing(): the SQL is in 20261025193016_wallet_balance_snapshot_anchor.sql.

Variable walletBalanceViewConst

Settings

Variable walletBalanceView`Const`