app.ai_suggestions
TablaSeguridad a nivel de fila activa
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.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| 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.Hace referencia a app.organizations.id |
| request_id | uuid | No | Request that proposed the change.Hace referencia a 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 | Sí | 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 | Sí | 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 | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| deleted_at | timestamp with time zone | Sí | Soft delete time. A row with deleted_at set is ignored by every access helper. |