Circle V2 API Docs
    Preparing search index...

    Variable integrationsTableConst

    integrationsTable: PgTableWithColumns<
        {
            columns: {
                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: "integrations";
                    },
                    {},
                    { $type: Generated },
                >;
                createdBy: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgUUID";
                        data: string;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "created_by";
                        notNull: false;
                        tableName: "integrations";
                    },
                    {},
                    {},
                >;
                credentials: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgJsonb";
                        data: | {
                            access_id: string;
                            app_id: string;
                            location_id: number;
                            location_name?: string;
                            secret_key: string;
                        }
                        | {
                            bearer_token: string;
                            location_ids: number[];
                            location_name?: string;
                        }
                        | {
                            api_id: string;
                            api_secret: string;
                            location_name?: string;
                            realm_id: string;
                            service_facility_id: number;
                            sunwave_email: string;
                        };
                        dataType: "json";
                        driverParam: unknown;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "credentials";
                        notNull: true;
                        tableName: "integrations";
                    },
                    {},
                    {
                        $type: | {
                            access_id: string;
                            app_id: string;
                            location_id: number;
                            location_name?: string;
                            secret_key: string;
                        }
                        | {
                            bearer_token: string;
                            location_ids: number[];
                            location_name?: string;
                        }
                        | {
                            api_id: string;
                            api_secret: string;
                            location_name?: string;
                            realm_id: string;
                            service_facility_id: number;
                            sunwave_email: string;
                        };
                    },
                >;
                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: true;
                        tableName: "integrations";
                    },
                    {},
                    { $type: EntityId },
                >;
                facilityId: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgUUID";
                        data: Generated;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: false;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "facility_id";
                        notNull: false;
                        tableName: "integrations";
                    },
                    {},
                    { $type: Generated },
                >;
                id: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgUUID";
                        data: Generated;
                        dataType: "string";
                        driverParam: string;
                        enumValues: undefined;
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: true;
                        name: "id";
                        notNull: true;
                        tableName: "integrations";
                    },
                    {},
                    { $type: Generated },
                >;
                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: "integrations";
                    },
                    {},
                    {},
                >;
                lastSync: 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_sync";
                        notNull: false;
                        tableName: "integrations";
                    },
                    {},
                    {},
                >;
                status: PgColumn<
                    {
                        baseColumn: never;
                        columnType: "PgEnumColumn";
                        data: "error"
                        | "active"
                        | "inactive";
                        dataType: "string";
                        driverParam: string;
                        enumValues: ["active", "inactive", "error"];
                        generated: undefined;
                        hasDefault: true;
                        hasRuntimeDefault: false;
                        identity: undefined;
                        isAutoincrement: false;
                        isPrimaryKey: false;
                        name: "status";
                        notNull: true;
                        tableName: "integrations";
                    },
                    {},
                    {},
                >;
                type: 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: "type";
                        notNull: true;
                        tableName: "integrations";
                    },
                    {},
                    {},
                >;
                updatedAt: 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: "updated_at";
                        notNull: true;
                        tableName: "integrations";
                    },
                    {},
                    { $type: Generated },
                >;
            };
            dialect: "pg";
            name: "integrations";
            schema: undefined;
        },
    > = ...