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

    Variable walletBalanceDivergenceViewConst

    walletBalanceDivergenceView: PgViewWithSelection<
        {
            existing: true;
            isAlias: false;
            name: "wallet_balance_divergence";
            schema: "b2b";
            selectedFields: {
                ambiguous: PgBuildColumn<
                    "wallet_balance_divergence",
                    SetNotNull<PgBooleanBuilder>,
                    {
                        data: boolean;
                        dataType: "boolean";
                        driverParam: boolean;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "wallet_balance_divergence";
                    },
                >;
                balance: PgBuildColumn<
                    "wallet_balance_divergence",
                    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_divergence";
                    },
                >;
                chainId: PgBuildColumn<
                    "wallet_balance_divergence",
                    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_divergence";
                    },
                >;
                gap: PgBuildColumn<
                    "wallet_balance_divergence",
                    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_divergence";
                    },
                >;
                gapSince: PgBuildColumn<
                    "wallet_balance_divergence",
                    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: "wallet_balance_divergence";
                    },
                >;
                mint: PgBuildColumn<
                    "wallet_balance_divergence",
                    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_divergence";
                    },
                >;
                observedAt: PgBuildColumn<
                    "wallet_balance_divergence",
                    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: "wallet_balance_divergence";
                    },
                >;
                previousGap: PgBuildColumn<
                    "wallet_balance_divergence",
                    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: false;
                        tableName: "wallet_balance_divergence";
                    },
                >;
                previousObservedAt: PgBuildColumn<
                    "wallet_balance_divergence",
                    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: false;
                        tableName: "wallet_balance_divergence";
                    },
                >;
                snapshotId: PgBuildColumn<
                    "wallet_balance_divergence",
                    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: "wallet_balance_divergence";
                    },
                >;
                stored: PgBuildColumn<
                    "wallet_balance_divergence",
                    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_divergence";
                    },
                >;
                walletAddressId: PgBuildColumn<
                    "wallet_balance_divergence",
                    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_divergence";
                    },
                >;
            };
        },
    > = ...

    Each snapshot beside sum(amount) of the pair's landed rows up to its observedAt, the gap, and the pair's previous unambiguous snapshot and gap. gapSince is the first snapshot of the current run of equal gaps. .existing(): the SQL is in 20261025184702_wallet_balance_divergence.sql.

    Settings
    Member Visibility