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

    Variable productVendorVersionTableConst

    productVendorVersionTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    bankId: 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: "bankId";
                            notNull: false;
                            tableName: "product_vendor_version";
                        },
                        {},
                        {},
                    >;
                    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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    feeVisible: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBoolean";
                            data: boolean;
                            dataType: "boolean";
                            driverParam: boolean;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "feeVisible";
                            notNull: false;
                            tableName: "product_vendor_version";
                        },
                        {},
                        {},
                    >;
                    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_vendor_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_vendor_version";
                        },
                        {},
                        {},
                    >;
                    limit24hMaxCount: 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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    limit24hMaxUsd: 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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    limit30dMaxCount: 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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    limit30dMaxUsd: 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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    limit7dMaxCount: 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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    limit7dMaxUsd: 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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    limitTransactionMaxUsd: 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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    limitTransactionMinUsd: 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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    name: 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: "name";
                            notNull: true;
                            tableName: "product_vendor_version";
                        },
                        {},
                        {},
                    >;
                    note: 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: "note";
                            notNull: false;
                            tableName: "product_vendor_version";
                        },
                        {},
                        {},
                    >;
                    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_vendor_version";
                        },
                        {},
                        { pgColumnBuilderBrand: "PgCustomColumnBuilderBrand" },
                    >;
                    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_vendor_version";
                        },
                        {},
                        {},
                    >;
                };
                dialect: "pg";
                name: "product_vendor_version";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...

    Append-only version log for vendor changes. Each row is a snapshot of (name, bankId) plus the full fee/limit term set, plus an optional note describing the change. This is a simple version log — no current_version_id pointer on the parent, no immutability trigger; population is wired up by the service layer. product_quote.vendor_version_id FKs into this table to freeze the vendor terms snapshot at quote time.

    Settings

    Member Visibility