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

    Variable productActivationRuleTableConst

    productActivationRuleTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    createdAt: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgCustomColumn";
                            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_activation_rule";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    currentVersionId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgInteger";
                            data: number;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "currentVersionId";
                            notNull: true;
                            tableName: "product_activation_rule";
                        },
                        {},
                        {},
                    >;
                    customerId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgInteger";
                            data: number;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "customerId";
                            notNull: false;
                            tableName: "product_activation_rule";
                        },
                        {},
                        {},
                    >;
                    deletedAt: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgCustomColumn";
                            data: Instant;
                            dataType: "custom";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "product_activation_rule";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    externalId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgText";
                            data: string;
                            dataType: "string";
                            driverParam: string;
                            enumValues: [string, ...string[]];
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: true;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "externalId";
                            notNull: true;
                            tableName: "product_activation_rule";
                        },
                        {},
                        {},
                    >;
                    id: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgInteger";
                            data: number;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: "byDefault";
                            isAutoincrement: false;
                            isPrimaryKey: true;
                            name: "id";
                            notNull: true;
                            tableName: "product_activation_rule";
                        },
                        {},
                        {},
                    >;
                    matcherHash: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgText";
                            data: string;
                            dataType: "string";
                            driverParam: string;
                            enumValues: [string, ...string[]];
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "matcherHash";
                            notNull: true;
                            tableName: "product_activation_rule";
                        },
                        {},
                        {},
                    >;
                    routeId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgInteger";
                            data: number;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "routeId";
                            notNull: true;
                            tableName: "product_activation_rule";
                        },
                        {},
                        {},
                    >;
                    type: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgText";
                            data: "CUSTOMER"
                            | "ADMIN";
                            dataType: "string";
                            driverParam: string;
                            enumValues: [string, ...string[]];
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "type";
                            notNull: true;
                            tableName: "product_activation_rule";
                        },
                        {},
                        { $type: "CUSTOMER"
                        | "ADMIN" },
                    >;
                    updatedAt: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgCustomColumn";
                            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_activation_rule";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                };
                dialect: "pg";
                name: "product_activation_rule";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...

    Per-route activation rules — identity row. Three valid tier shapes (CHECK-enforced):

    • (type=ADMIN, customer_id=NULL) — global admin baseline
    • (type=ADMIN, customer_id=X) — admin-for-customer adjustment
    • (type=CUSTOMER, customer_id=X) — customer's own overlay

    Mutable on currentVersionId, matcherHash, and deletedAt only. Every change to the matcher, status, priority, value, or label/description inserts a new product_activation_rule_version row and re-points currentVersionId (and re-stamps matcherHash from the new version) in the same transaction.

    Duplicate-matcher detection — no two non-deleted rules in the same (route_id, customer_id, type) scope sharing the same matcher hash — is enforced by product_activation_rule_unique_tuple, a partial unique index keyed on (route_id, customer_id, type, matcher_hash) NULLS NOT DISTINCT WHERE deleted_at IS NULL. matcherHash is denormalized onto this row from the current version so the constraint can live here; services must catch unique-violation errors on insert/update and surface them as DUPLICATE_MATCHER.

    Settings

    Member Visibility