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

    Variable productRouteVersionTableConst

    productRouteVersionTable: 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_route_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    data: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgJsonb";
                            data: ProductRouteVersionData;
                            dataType: "json";
                            driverParam: unknown;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "data";
                            notNull: true;
                            tableName: "product_route_version";
                        },
                        {},
                        { $type: ProductRouteVersionData },
                    >;
                    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_route_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_route_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_route_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_route_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_route_version";
                        },
                        {},
                        {},
                    >;
                    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_route_version";
                        },
                        {},
                        {},
                    >;
                    vendorId: 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: "vendorId";
                            notNull: true;
                            tableName: "product_route_version";
                        },
                        {},
                        {},
                    >;
                };
                dialect: "pg";
                name: "product_route_version";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...

    Append-only version table for product_route. Carries the routing decision: which vendor handles the route, and the structured matcher that gates when this version applies. Per-vendor fees and limits live on product_vendor — they're shared across every route pinned to a vendor and not encoded here.

    Every change to vendor or matcher inserts a new row and the identity table's currentVersionId is repointed in the same transaction. UPDATE and DELETE are blocked by the product_route_version_immutable trigger.

    No externalId — only the identity row is externally addressable.

    Settings

    Member Visibility