app.trash_items

Vista

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.

Columnas de app.trash_items
Columna	Tipo	Admite nulos	Descripción
subject_urn	text	Sí	urn:xpms:{table}:{id} of the deleted row.
subject_table	text	Sí	Table of the deleted row.
subject_id	uuid	Sí	Id of the deleted row.
org_id	uuid	Sí	Org of the deleted row.
project_id	uuid	Sí	Project of the deleted row, when its table has one.
title	text	Sí	What the row is called, from its title column.
deleted_at	timestamp with time zone	Sí	When it was deleted.
deleted_by	uuid	Sí	Person who deleted it (the last writer).
purge_after	timestamp with time zone	Sí	When the retention purge removes it for good; it can be restored until then.