Variable ledgerAccountBalanceChangeView`Const`

ledgerAccountBalanceChangeView: PgViewWithSelection<
    {
        existing: true;
        isAlias: false;
        name: "ledger_account_balance_change";
        schema: "b2b";
        selectedFields: {
            address: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
            blockTime: PgBuildColumn<
                "ledger_account_balance_change",
                SetNotNull<PgTimestampBuilder>,
                {
                    data: Date;
                    dataType: "object date";
                    driverParam: string;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: true;
                    tableName: "ledger_account_balance_change";
                },
            >;
            chain: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
            indexWithinBlock: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
            ledgerAccountExternalId: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
            ledgerAccountId: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
            postBalance: PgBuildColumn<
                "ledger_account_balance_change",
                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: "ledger_account_balance_change";
                },
            >;
            slot: PgBuildColumn<
                "ledger_account_balance_change",
                SetNotNull<PgBigInt53Builder>,
                {
                    data: number;
                    dataType: "number int53";
                    driverParam: string | number;
                    enumValues: undefined;
                    generated: undefined;
                    hasDefault: false;
                    hasRuntimeDefault: false;
                    identity: undefined;
                    isAutoincrement: false;
                    isPrimaryKey: false;
                    name: string;
                    notNull: true;
                    tableName: "ledger_account_balance_change";
                },
            >;
            symbol: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
            tokenExternalId: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
            tokenId: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
            walletAddressId: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
            walletTransactionId: PgBuildColumn<
                "ledger_account_balance_change",
                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_balance_change";
                },
            >;
        };
    },
> = ...

Each balance change on an address a ledger account holds, in token units: a wallet_account_transaction row with token_id set whose transaction has block_time, matched by wallet_address_id, or by account_key on a Solana row whose wallet_address_id is NULL. postBalance is the stored one where the chain reports it (Solana), else a running sum of amount. A balance is the latest postBalance per (address, token) by blockTime, slot, indexWithinBlock. .existing(): the SQL is in 20261023193347_wallet_transaction_network.sql.

Variable ledgerAccountBalanceChangeViewConst

Settings

Variable ledgerAccountBalanceChangeView`Const`