app.ai_suggestions
TableRow level security on
A change an Aurora feature proposes (Section 4.7). Nothing is written until the person who asked confirms; the confirmed write then goes through the public API operation named here with their own token, so it can never do more than they can. The summary says exactly what will change.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.ai_requests on insert; never accepted from the caller and never changed.References app.organizations.id |
| request_id | uuid | No | Request that proposed the change.References app.ai_requests.id |
| operation_id | text | No | Public API operation that performs the change, for example records.create or savedViews.create. |
| target_id | uuid | Yes | Record the change updates, or null when it creates one. |
| summary | text | No | What will change, in one or two sentences, shown on the confirmation step. |
| suggestion_state | app.ai_suggestion_state | No | Proposed, Confirmed, Applied, Rejected or Expired. Changes only through app.transition_ai_suggestion. |
| expires_at | timestamp with time zone | No | After this time the suggestion can no longer be confirmed. |
| applied_id | uuid | Yes | Record the public API wrote or updated, set when the suggestion is Applied. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |