Circle V2 API Docs
    Preparing search index...

    Variable patientActionItemsTableConst

    patientActionItemsTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    assignedContactId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgUUID";
                            data: ContactId
                            | null;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "assigned_contact_id";
                            notNull: false;
                            tableName: "patient_action_items";
                        },
                        {},
                        { $type: ContactId
                        | null },
                    >;
                    assignedTo: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBigInt53";
                            data: ProfileId
                            | null;
                            dataType: "number";
                            driverParam: string | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "assigned_to";
                            notNull: false;
                            tableName: "patient_action_items";
                        },
                        {},
                        { $type: ProfileId
                        | null },
                    >;
                    auditQuestionId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBigInt53";
                            data: AuditQuestionId;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "audit_question_id";
                            notNull: true;
                            tableName: "patient_action_items";
                        },
                        {},
                        { $type: AuditQuestionId },
                    >;
                    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_action_items";
                        },
                        {},
                        { $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: "patient_action_items";
                        },
                        {},
                        { $type: Generated },
                    >;
                    nextSteps: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgEnumColumn";
                            data: Generated;
                            dataType: "string";
                            driverParam: string;
                            enumValues: [
                                "to_do",
                                "sent_to_clinician",
                                "resolved",
                                "no_action_needed",
                                "needs_clarification",
                            ];
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "next_steps";
                            notNull: true;
                            tableName: "patient_action_items";
                        },
                        {},
                        { $type: Generated },
                    >;
                    patientId: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBigInt53";
                            data: PatientId;
                            dataType: "number";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "patient_id";
                            notNull: true;
                            tableName: "patient_action_items";
                        },
                        {},
                        { $type: PatientId },
                    >;
                    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: "patient_action_items";
                        },
                        {},
                        { $type: Generated },
                    >;
                    updatedBy: PgColumn<
                        {
                            baseColumn: never;
                            columnType: "PgBigInt53";
                            data: ProfileId
                            | null;
                            dataType: "number";
                            driverParam: string | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: "updated_by";
                            notNull: false;
                            tableName: "patient_action_items";
                        },
                        {},
                        { $type: ProfileId
                        | null },
                    >;
                };
                dialect: "pg";
                name: "patient_action_items";
                schema: undefined;
            },
        >,
        "enableRLS",
    > = ...

    Per-question workflow state for the Action Items table: who owns the follow-up and where it stands. One row per (patient, question) — tied to the question, not to any run or response, so re-runs never invalidate it. Created lazily on first edit; a hard-deleted question cascades the record away (survivable is future work).

    Settings

    Member Visibility