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

    Variable aipriseBusinessProfileTableConst

    aipriseBusinessProfileTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    aipriseId: PgBuildColumn<
                        "aiprise_business_profile",
                        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: "aiprise_business_profile";
                        },
                    >;
                    clientReferenceId: PgBuildColumn<
                        "aiprise_business_profile",
                        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: "aiprise_business_profile";
                        },
                    >;
                    createdAt: PgBuildColumn<
                        "aiprise_business_profile",
                        SetHasDefault<SetNotNull<PgTimestampBuilder>>,
                        {
                            data: Date;
                            dataType: "object date";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "aiprise_business_profile";
                        },
                    >;
                    data: PgBuildColumn<
                        "aiprise_business_profile",
                        Set$Type<SetNotNull<PgJsonbBuilder>, AiPriseBusinessProfileData>,
                        {
                            data: AiPriseBusinessProfileData;
                            dataType: "object json";
                            driverParam: unknown;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "aiprise_business_profile";
                        },
                    >;
                    deletedAt: PgBuildColumn<
                        "aiprise_business_profile",
                        PgTimestampBuilder,
                        {
                            data: Date;
                            dataType: "object date";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "aiprise_business_profile";
                        },
                    >;
                    externalId: PgBuildColumn<
                        "aiprise_business_profile",
                        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: "aiprise_business_profile";
                        },
                    >;
                    id: PgBuildColumn<
                        "aiprise_business_profile",
                        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: "aiprise_business_profile";
                        },
                    >;
                    lifecycleStatus: PgBuildColumn<
                        "aiprise_business_profile",
                        Set$Type<
                            PgTextBuilder<[string, ...string[]]>,

                                | "PROFILE_NOT_SUBMITTED"
                                | "ONBOARDING_SESSIONS_PENDING"
                                | "READY_FOR_REVIEW"
                                | "ADDITIONAL_INFO_REQUESTED"
                                | "MONITORING_UPDATES"
                                | "SESSIONS_EXPIRED",
                        >,
                        {
                            data: | "PROFILE_NOT_SUBMITTED"
                            | "ONBOARDING_SESSIONS_PENDING"
                            | "READY_FOR_REVIEW"
                            | "ADDITIONAL_INFO_REQUESTED"
                            | "MONITORING_UPDATES"
                            | "SESSIONS_EXPIRED";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "aiprise_business_profile";
                        },
                    >;
                    name: PgBuildColumn<
                        "aiprise_business_profile",
                        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: "aiprise_business_profile";
                        },
                    >;
                    profileUpdatedAt: PgBuildColumn<
                        "aiprise_business_profile",
                        PgTimestampBuilder,
                        {
                            data: Date;
                            dataType: "object date";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "aiprise_business_profile";
                        },
                    >;
                    result: PgBuildColumn<
                        "aiprise_business_profile",
                        Set$Type<
                            PgTextBuilder<[string, ...string[]]>,
                            "REVIEW" | "DECLINED" | "APPROVED" | "UNKNOWN" | "DEACTIVATED",
                        >,
                        {
                            data:
                                | "REVIEW"
                                | "DECLINED"
                                | "APPROVED"
                                | "UNKNOWN"
                                | "DEACTIVATED";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "aiprise_business_profile";
                        },
                    >;
                    syncedAt: PgBuildColumn<
                        "aiprise_business_profile",
                        SetNotNull<PgTimestampBuilder>,
                        {
                            data: Date;
                            dataType: "object date";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "aiprise_business_profile";
                        },
                    >;
                    updatedAt: PgBuildColumn<
                        "aiprise_business_profile",
                        SetHasDefault<SetHasDefault<SetNotNull<PgTimestampBuilder>>>,
                        {
                            data: Date;
                            dataType: "object date";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "aiprise_business_profile";
                        },
                    >;
                };
                dialect: "pg";
                name: "aiprise_business_profile";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...

    Shadow copy of an AiPrise (KYB vendor) business profile. Refreshed by the identity-api webhook consumer on every AiPrise event so services read locally instead of calling AiPrise.