Variable solanaProgramEventTable`Const`

solanaProgramEventTable: Omit<
    PgTableWithColumns<
        {
            columns: {
                blockTime: PgBuildColumn<
                    "solana_program_event",
                    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: "solana_program_event";
                    },
                >;
                createdAt: PgBuildColumn<
                    "solana_program_event",
                    SetHasDefault<SetNotNull<PgTimestampBuilder>>,
                    {
                        data: Date;
                        dataType: "object date";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "solana_program_event";
                    },
                >;
                data: PgBuildColumn<
                    "solana_program_event",
                    Set$Type<SetNotNull<PgJsonbBuilder>, Record<string, JsonValue>>,
                    {
                        data: TData;
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "solana_program_event";
                    },
                >;
                eventIndex: PgBuildColumn<
                    "solana_program_event",
                    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: "solana_program_event";
                    },
                >;
                id: PgBuildColumn<
                    "solana_program_event",
                    HasIdentity<SetIsPrimaryKey<PgIntegerBuilder>, "byDefault">,
                    {
                        data: number;
                        dataType: "number int32";
                        driverParam: string | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: "byDefault";
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "solana_program_event";
                    },
                >;
                ik: PgBuildColumn<
                    "solana_program_event",
                    SetHasGenerated<PgTextBuilder<[string, ...string[]]>>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: true;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "solana_program_event";
                    },
                >;
                indexWithinBlock: PgBuildColumn<
                    "solana_program_event",
                    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: "solana_program_event";
                    },
                >;
                name: PgBuildColumn<
                    "solana_program_event",
                    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: "solana_program_event";
                    },
                >;
                signature: PgBuildColumn<
                    "solana_program_event",
                    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: "solana_program_event";
                    },
                >;
                slot: PgBuildColumn<
                    "solana_program_event",
                    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: "solana_program_event";
                    },
                >;
                solanaTransactionId: PgBuildColumn<
                    "solana_program_event",
                    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: "solana_program_event";
                    },
                >;
                tokenId: PgBuildColumn<
                    "solana_program_event",
                    SetHasGenerated<PgTextBuilder<[string, ...string[]]>>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: true;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "solana_program_event";
                    },
                >;
                walletIds: PgBuildColumn<
                    "solana_program_event",
                    SetHasGenerated<SetNotNull<SetDimensions<PgUUIDBuilder, 1>>>,
                    {
                        data: string[];
                        dataType: "string uuid";
                        driverParam: string | string[];
                        enumValues: undefined;
                        generated: true;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "solana_program_event";
                    },
                >;
            };
            dialect: "pg";
            name: "solana_program_event";
            schema: "b2b";
        },
    >,
    "enableRLS",
> = ...

One decoded mintfx emit_cpi! event, projected out of solana_transaction.parsed_events.

The array on solana_transaction remains the source of truth; this is that array expanded once, with the fields a read actually filters on as columns. Reading the events out of the jsonb meant a CROSS JOIN LATERAL … WITH ORDINALITY and a destructure per event per query, none of which an index can serve — an index covers rows of a table, and an array element is not one.

Rebuildable: drop every row and re-expand parsed_events and you have it back. Nothing here is knowledge the column does not already hold.

Variable solanaProgramEventTableConst

Settings

Variable solanaProgramEventTable`Const`