Variable productLimitRuleVersionTable`Const`

productLimitRuleVersionTable: Omit<
    PgTableWithColumns<
        {
            columns: {
                createdAt: PgBuildColumn<
                    "product_limit_rule_version",
                    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: "product_limit_rule_version";
                    },
                >;
                description: PgBuildColumn<
                    "product_limit_rule_version",
                    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: "product_limit_rule_version";
                    },
                >;
                effectiveFrom: PgBuildColumn<
                    "product_limit_rule_version",
                    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: "product_limit_rule_version";
                    },
                >;
                id: PgBuildColumn<
                    "product_limit_rule_version",
                    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: "product_limit_rule_version";
                    },
                >;
                label: PgBuildColumn<
                    "product_limit_rule_version",
                    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: "product_limit_rule_version";
                    },
                >;
                limit24hMaxCount: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
                limit24hMaxUsd: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
                limit30dMaxCount: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
                limit30dMaxUsd: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
                limit7dMaxCount: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
                limit7dMaxUsd: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
                limitCalendarMonthMaxCount: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
                limitCalendarMonthMaxUsd: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
                matcher: PgBuildColumn<
                    "product_limit_rule_version",
                    SetNotNull<Set$Type<PgJsonbBuilder, Matcher>>,
                    {
                        data: Matcher;
                        dataType: "object json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "product_limit_rule_version";
                    },
                >;
                matcherHash: PgBuildColumn<
                    "product_limit_rule_version",
                    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: "product_limit_rule_version";
                    },
                >;
                priority: PgBuildColumn<
                    "product_limit_rule_version",
                    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: "product_limit_rule_version";
                    },
                >;
                ruleId: PgBuildColumn<
                    "product_limit_rule_version",
                    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: "product_limit_rule_version";
                    },
                >;
                status: PgBuildColumn<
                    "product_limit_rule_version",
                    Set$Type<
                        SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                        "ACTIVE" | "DISABLED",
                    >,
                    {
                        data: "ACTIVE" | "DISABLED";
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: true;
                        tableName: "product_limit_rule_version";
                    },
                >;
                transactionMaxUsd: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
                transactionMinUsd: PgBuildColumn<
                    "product_limit_rule_version",
                    PgCustomColumnBuilder<
                        { data: BigNumber; dataType: "custom"; driverParam: string },
                    >,
                    {
                        data: BigNumber;
                        dataType: "custom";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: string;
                        notNull: false;
                        tableName: "product_limit_rule_version";
                    },
                >;
            };
            dialect: "pg";
            name: "product_limit_rule_version";
            schema: "b2b";
        },
    >,
    "enableRLS",
> = ...

Append-only version table for product_limit_rule. Every change to matcher, status, priority, any limit column, or label/description inserts a new row and the identity table's currentVersionId is repointed in the same transaction. UPDATE and DELETE are blocked by the product_limit_rule_version_immutable trigger.

product_quote FKs to this table so the audit pin freezes the limit snapshot at quote time.

No externalId — only the identity row is externally addressable.

Variable productLimitRuleVersionTableConst

Settings

Variable productLimitRuleVersionTable`Const`