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

    Variable productFeeRuleVersionTableConst

    productFeeRuleVersionTable: 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_fee_rule_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    description: 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: "description";
                            notNull: false;
                            tableName: "product_fee_rule_version";
                        },
                        {},
                        {},
                    >;
                    effectiveFrom: 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_fee_rule_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    fixedFeeAmount: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgCustomColumn";
                            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_fee_rule_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    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_fee_rule_version";
                        },
                        {},
                        {},
                    >;
                    label: 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: "label";
                            notNull: false;
                            tableName: "product_fee_rule_version";
                        },
                        {},
                        {},
                    >;
                    matcher: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgJsonb";
                            data: Matcher;
                            dataType: "json";
                            driverParam: unknown;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "matcher";
                            notNull: true;
                            tableName: "product_fee_rule_version";
                        },
                        {},
                        { $type: Matcher },
                    >;
                    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_fee_rule_version";
                        },
                        {},
                        {},
                    >;
                    priority: 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: "priority";
                            notNull: true;
                            tableName: "product_fee_rule_version";
                        },
                        {},
                        {},
                    >;
                    ruleId: 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: "ruleId";
                            notNull: true;
                            tableName: "product_fee_rule_version";
                        },
                        {},
                        {},
                    >;
                    status: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgText";
                            data: "ACTIVE"
                            | "DISABLED";
                            dataType: "string";
                            driverParam: string;
                            enumValues: [string, ...string[]];
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "status";
                            notNull: true;
                            tableName: "product_fee_rule_version";
                        },
                        {},
                        { $type: "ACTIVE"
                        | "DISABLED" },
                    >;
                    variableFeeBps: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgCustomColumn";
                            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_fee_rule_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                };
                dialect: "pg";
                name: "product_fee_rule_version";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...

    Append-only version table for product_fee_rule. Every change to matcher, status, priority, fee values, 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_fee_rule_version_immutable trigger.

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

    No externalId — only the identity row is externally addressable.

    Settings

    Member Visibility