Variable rewardAccountTable`Const`

rewardAccountTable: Omit<
    PgTableWithColumns<
        {
            columns: {
                createdAt: PgBuildColumn<
                    "reward_account",
                    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: "reward_account";
                    },
                >;
                customerExternalId: PgBuildColumn<
                    "reward_account",
                    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: "reward_account";
                    },
                >;
                customerId: PgBuildColumn<
                    "reward_account",
                    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: "reward_account";
                    },
                >;
                externalId: PgBuildColumn<
                    "reward_account",
                    SetHasRuntimeDefault<SetNotNull<PgTextBuilder<[string, ...string[]]>>>,
                    {
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "reward_account";
                    },
                >;
                id: PgBuildColumn<
                    "reward_account",
                    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: "reward_account";
                    },
                >;
                identityExternalId: PgBuildColumn<
                    "reward_account",
                    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: "reward_account";
                    },
                >;
                identityId: PgBuildColumn<
                    "reward_account",
                    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: false;
                        tableName: "reward_account";
                    },
                >;
                organizationExternalId: PgBuildColumn<
                    "reward_account",
                    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: "reward_account";
                    },
                >;
                organizationId: PgBuildColumn<
                    "reward_account",
                    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: false;
                        tableName: "reward_account";
                    },
                >;
                promotedAt: PgBuildColumn<
                    "reward_account",
                    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: "reward_account";
                    },
                >;
                promotedToId: PgBuildColumn<
                    "reward_account",
                    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: false;
                        tableName: "reward_account";
                    },
                >;
                recipient: PgBuildColumn<
                    "reward_account",
                    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: "reward_account";
                    },
                >;
                recipientType: PgBuildColumn<
                    "reward_account",
                    Set$Type<PgTextBuilder<[string, ...string[]]>, "PHONE" | "EMAIL">,
                    {
                        data: "PHONE" | "EMAIL";
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "reward_account";
                    },
                >;
                updatedAt: PgBuildColumn<
                    "reward_account",
                    SetHasDefault<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: "reward_account";
                    },
                >;
            };
            dialect: "pg";
            isAlias: false;
            name: "reward_account";
            schema: "b2b";
        },
    >,
    "enableRLS",
> = ...

Who a reward balance belongs to: one identity, one organization, or a pending recipient (an email or phone a promo was issued to before anyone signed up with it). A pending account is promoted onto the entity's own account when that entity appears, and keeps its row with promoted_to_id set so the history stays readable.

Variable rewardAccountTableConst

Settings

Variable rewardAccountTable`Const`