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

    Variable relatedPersonTableConst

    relatedPersonTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    countryOfResidence: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                    createdAt: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                    customerId: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                    data: PgBuildColumn<
                        "related_person",
                        Set$Type<
                            SetNotNull<PgJsonbBuilder>,
                            {
                                address?: {
                                    city: string;
                                    countryCode: string;
                                    line1: string;
                                    line2?: string;
                                    postalCode: string;
                                    regionCode?: string;
                                };
                                dateOfBirth?: string;
                                ownershipPercent?: number;
                                personReferenceId?: string;
                                sharesAllocated?: number;
                                title?: string;
                                verificationProfileId?: string;
                            },
                        >,
                        {
                            data: {
                                address?: {
                                    city: string;
                                    countryCode: string;
                                    line1: string;
                                    line2?: string;
                                    postalCode: string;
                                    regionCode?: string;
                                };
                                dateOfBirth?: string;
                                ownershipPercent?: number;
                                personReferenceId?: string;
                                sharesAllocated?: number;
                                title?: string;
                                verificationProfileId?: string;
                            };
                            dataType: "object json";
                            driverParam: unknown;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "related_person";
                        },
                    >;
                    deletedAt: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                    email: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                    externalId: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                    id: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                    name: PgBuildColumn<
                        "related_person",
                        Set$Type<
                            PgJsonbBuilder,
                            { firstName: string; lastName: string; middleName?: string },
                        >,
                        {
                            data: { firstName: string; lastName: string; middleName?: string };
                            dataType: "object json";
                            driverParam: unknown;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "related_person";
                        },
                    >;
                    organizationId: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                    phone: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                    status: PgBuildColumn<
                        "related_person",
                        Set$Type<
                            SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                            "ACTIVE" | "DELETED",
                        >,
                        {
                            data: "ACTIVE" | "DELETED";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "related_person";
                        },
                    >;
                    type: PgBuildColumn<
                        "related_person",
                        Set$Type<
                            SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                            "CONTROL" | "BENEFICIAL_OWNER",
                        >,
                        {
                            data: "CONTROL" | "BENEFICIAL_OWNER";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "related_person";
                        },
                    >;
                    updatedAt: PgBuildColumn<
                        "related_person",
                        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: "related_person";
                        },
                    >;
                };
                dialect: "pg";
                name: "related_person";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...