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

    Variable productActivationRuleTableConst

    productActivationRuleTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    createdAt: PgBuildColumn<
                        "product_activation_rule",
                        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_activation_rule";
                        },
                    >;
                    currentVersionId: PgBuildColumn<
                        "product_activation_rule",
                        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_activation_rule";
                        },
                    >;
                    customerExternalId: PgBuildColumn<
                        "product_activation_rule",
                        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_activation_rule";
                        },
                    >;
                    customerId: PgBuildColumn<
                        "product_activation_rule",
                        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: "product_activation_rule";
                        },
                    >;
                    deletedAt: PgBuildColumn<
                        "product_activation_rule",
                        PgCustomColumnBuilder<
                            { data: Instant; dataType: "custom"; driverParam: string },
                        >,
                        {
                            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";
                        },
                    >;
                    externalId: PgBuildColumn<
                        "product_activation_rule",
                        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: "product_activation_rule";
                        },
                    >;
                    id: PgBuildColumn<
                        "product_activation_rule",
                        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_activation_rule";
                        },
                    >;
                    matcherHash: PgBuildColumn<
                        "product_activation_rule",
                        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_activation_rule";
                        },
                    >;
                    productCategory: PgBuildColumn<
                        "product_activation_rule",
                        Set$Type<PgTextBuilder<[string, ...string[]]>, ProductCategory>,
                        {
                            data: ProductCategory;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "product_activation_rule";
                        },
                    >;
                    productExternalId: PgBuildColumn<
                        "product_activation_rule",
                        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_activation_rule";
                        },
                    >;
                    productId: PgBuildColumn<
                        "product_activation_rule",
                        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: "product_activation_rule";
                        },
                    >;
                    routeExternalId: PgBuildColumn<
                        "product_activation_rule",
                        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_activation_rule";
                        },
                    >;
                    routeId: PgBuildColumn<
                        "product_activation_rule",
                        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: "product_activation_rule";
                        },
                    >;
                    type: PgBuildColumn<
                        "product_activation_rule",
                        Set$Type<
                            SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                            "CUSTOMER" | "ADMIN",
                        >,
                        {
                            data: "CUSTOMER" | "ADMIN";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "product_activation_rule";
                        },
                    >;
                    updatedAt: PgBuildColumn<
                        "product_activation_rule",
                        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: "product_activation_rule";
                        },
                    >;
                    vendorExternalId: PgBuildColumn<
                        "product_activation_rule",
                        Set$Type<PgTextBuilder<[string, ...string[]]>, Vendor>,
                        {
                            data: Vendor;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "product_activation_rule";
                        },
                    >;
                    vendorId: PgBuildColumn<
                        "product_activation_rule",
                        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: "product_activation_rule";
                        },
                    >;
                };
                dialect: "pg";
                isAlias: false;
                name: "product_activation_rule";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...

    Activation rules — identity row. A route rule (route_id set) has 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

    A cross-route rule (route_id NULL) is scoped by product_category, vendor_id, product_id and customer_id, at least one set. ADMIN-only by CHECK; DENY-only by the admin service and the resolver view's value = 'DENY'.

    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.

    product_activation_rule_unique_tuple (scope columns + matcher_hash, NULLS NOT DISTINCT, live rows) refuses a duplicate matcher; matcherHash is denormalized here for it, and services surface it as DUPLICATE_MATCHER.

    Settings
    Member Visibility