Variable bankTable`Const`

bankTable: Omit<
    PgTableWithColumns<
        {
            columns: {
                achInstructions: PgBuildColumn<
                    "bank",
                    Set$Type<PgJsonbBuilder, AchInstructionData>,
                    {
                        data: AchInstructionData;
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "bank";
                    },
                >;
                createdAt: PgBuildColumn<
                    "bank",
                    SetHasDefault<
                        SetNotNull<
                            PgCustomColumnBuilder<
                                { data: Instant; dataType: "custom"; driverParam: string },
                            >,
                        >,
                    >,
                    {
                        data: Instant;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "bank";
                    },
                >;
                description: PgBuildColumn<
                    "bank",
                    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: false;
                        tableName: "bank";
                    },
                >;
                externalId: PgBuildColumn<
                    "bank",
                    Set$Type<SetNotNull<PgTextBuilder<[string, ...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: "bank";
                    },
                >;
                fdicCert: PgBuildColumn<
                    "bank",
                    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: false;
                        tableName: "bank";
                    },
                >;
                id: PgBuildColumn<
                    "bank",
                    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: "bank";
                    },
                >;
                name: PgBuildColumn<
                    "bank",
                    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: "bank";
                    },
                >;
                routingNumber: PgBuildColumn<
                    "bank",
                    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: false;
                        tableName: "bank";
                    },
                >;
                rtpInstructions: PgBuildColumn<
                    "bank",
                    Set$Type<PgJsonbBuilder, AchInstructionData>,
                    {
                        data: AchInstructionData;
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "bank";
                    },
                >;
                searchDocument: PgBuildColumn<
                    "bank",
                    SetHasGenerated<SetNotNull<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: true;
                        tableName: "bank";
                    },
                >;
                swiftWireInstructions: PgBuildColumn<
                    "bank",
                    Set$Type<PgJsonbBuilder, Record<string, SwiftWireInstructionData[]>>,
                    {
                        data: TData;
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "bank";
                    },
                >;
                timezone: PgBuildColumn<
                    "bank",
                    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: false;
                        tableName: "bank";
                    },
                >;
                updatedAt: PgBuildColumn<
                    "bank",
                    SetHasDefault<
                        SetHasDefault<
                            SetNotNull<
                                PgCustomColumnBuilder<
                                    { data: Instant; dataType: "custom"; driverParam: string },
                                >,
                            >,
                        >,
                    >,
                    {
                        data: Instant;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "bank";
                    },
                >;
                usWireInstructions: PgBuildColumn<
                    "bank",
                    Set$Type<PgJsonbBuilder, UsWireInstructionData>,
                    {
                        data: UsWireInstructionData;
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "bank";
                    },
                >;
                wireEmailFromDomains: PgBuildColumn<
                    "bank",
                    SetHasDefault<SetNotNull<Set$Type<PgJsonbBuilder, string[]>>>,
                    {
                        data: string[];
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "bank";
                    },
                >;
                wireEmailLocalPart: PgBuildColumn<
                    "bank",
                    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: false;
                        tableName: "bank";
                    },
                >;
                workspaceExternalId: PgBuildColumn<
                    "bank",
                    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: "bank";
                    },
                >;
                workspaceId: PgBuildColumn<
                    "bank",
                    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: "bank";
                    },
                >;
            };
            dialect: "pg";
            isAlias: false;
            name: "bank";
            schema: "b2b";
        },
    >,
    "enableRLS",
> = ...

Reference table for bank metadata. externalId is the public bank slug — productRouteVersionTable.bankId and friends FK to bank.id (integer); legacy $type<string>() text columns store the literal slug with no FK.

routingNumber and fdicCert are operator-captured at create time; nullable so seeded rows that pre-date the columns can stay valid.

The four *Instructions jsonb columns hold the per-rail deposit instructions for the bank. Each is nullable; a non-null column means the bank supports that rail (see bankSupportsRail).

The bank dashboard's own configuration (its host, theme, role set and whether it is enabled) lives on the bank's workspace row, workspaceId.

wireEmailLocalPart (nullable) and wireEmailFromDomains (jsonb string[], default []) configure the bank's inbound wire-email inbox. The effective inbox local part is coalesce(wire_email_local_part, external_id), kept unique across banks by the bank_wire_email_local_part_effective_unique functional index; wireEmailFromDomains is the authenticated-sender domain allowlist (empty = fail-closed).

Variable bankTableConst

Settings

Variable bankTable`Const`