app.trash_items
View
Trash (Section 4.10): soft-deleted rows of the tables in private.trash_tables, read with the reader's own row level security. A view over the rows, never a copy. Restore through app.restore_trash_item until purge_after.
| Column | Type | Nullable | Description |
|---|---|---|---|
| subject_urn | text | Yes | urn:xpms:{table}:{id} of the deleted row. |
| subject_table | text | Yes | Table of the deleted row. |
| subject_id | uuid | Yes | Id of the deleted row. |
| org_id | uuid | Yes | Org of the deleted row. |
| project_id | uuid | Yes | Project of the deleted row, when its table has one. |
| title | text | Yes | What the row is called, from its title column. |
| deleted_at | timestamp with time zone | Yes | When it was deleted. |
| deleted_by | uuid | Yes | Person who deleted it (the last writer). |
| purge_after | timestamp with time zone | Yes | When the retention purge removes it for good; it can be restored until then. |