Circle V2 API Docs
    Preparing search index...

    Variable patientsTableConst

    patientsTable: PgTableWithColumns<
        {
            columns: {
                addressCity: 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: "address_city";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                addressState: 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: "address_state";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                addressStreet1: 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: "address_street1";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                addressStreet2: 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: "address_street2";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                addressZipcode: 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: "address_zipcode";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                createdAt: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgTimestampString";
                        data: Generated;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "created_at";
                        notNull: true;
                        tableName: "patient";
                    },
                    {},
                    { $type: Generated },
                >;
                createdBy: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgUUID";
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "created_by";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                dob: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgDateString";
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "dob";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                email: 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: "email";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                entityId: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgInteger";
                        data: EntityId;
                        dataType: "number";
                        driverParam: string
                        | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "entity_id";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    { $type: EntityId },
                >;
                externalPatientId: 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: "external_patient_id";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                externalSource: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgEnumColumn";
                        data: "kipu"
                        | "lightningstep"
                        | "sunwave";
                        dataType: "string";
                        driverParam: string;
                        enumValues: ["kipu", "lightningstep", "sunwave"];
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "external_source";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                facilityId: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgUUID";
                        data: FacilityId;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "facility_id";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    { $type: FacilityId },
                >;
                firstName: 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: "first_name";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                gender: 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: "gender";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                intakeNotes: 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: "intake_notes";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                lastName: 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: "last_name";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                lastUpdatedSummary: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgTimestampString";
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "last_updated_summary";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                patientId: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgBigInt64";
                        data: Generated;
                        dataType: "bigint";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: "byDefault";
                        isAutoincrement: false;
                        isPrimaryKey: true;
                        name: "patient_id";
                        notNull: true;
                        tableName: "patient";
                    },
                    {},
                    { $type: Generated },
                >;
                phoneMobile: 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: "phone_mobile";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                primaryProviderId: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgInteger";
                        data: ProfileId;
                        dataType: "number";
                        driverParam: string
                        | number;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "primary_provider_id";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    { $type: ProfileId },
                >;
                status: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgNumeric";
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "status";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    {},
                >;
                summary: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgJsonb";
                        data: LegacyPatientSummary;
                        dataType: "json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "summary";
                        notNull: false;
                        tableName: "patient";
                    },
                    {},
                    { $type: LegacyPatientSummary },
                >;
            };
            dialect: "pg";
            name: "patient";
            schema: undefined;
        },
    > = ...