app.retention_policies
View
Retention period of every app table, for the Data Retention and Deletion Policy page and the data and privacy settings.
| Column | Type | Nullable | Description |
|---|---|---|---|
| table_name | text | Yes | Table the policy governs. |
| basis | app.retention_basis | Yes | What starts the retention clock. |
| time_column | text | Yes | Column that starts the clock. |
| retention | interval | Yes | How long rows are kept. |
| purge_method | app.purge_method | Yes | How expired rows leave. |
| redact_personal_data_after | interval | Yes | When personal data in the table is redacted, if ever. |
| rationale | text | Yes | Why the period was chosen. |