cloud.tenant_history_log
Schema: cloud
English table: cloud.tenant_history_log
Italian original table: cloud._tenant_history
Description: Audit log of all lifecycle events and state changes for tenants.
Overview
- Columns: 5
- Primary key: thl_log_id
- Outgoing foreign keys: 0
- Incoming foreign keys: 0
- Indexes: 1
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
thl_tenant_uuid | th_tenant_id | uuid | NO | UUID of the tenant this event refers to (cloud.tenants.ten_uuid). | |
thl_event_timestamp | th_timestamp | timestamp without time zone | NO | The exact date and time when the event was recorded. | |
thl_event_type | th_event_type | character varying(50) | NO | The category of the event (e.g., "STATUS_CHANGE", "RENEWAL"). | |
thl_event_description | th_description | text | YES | Detailed notes or system messages associated with the event. | |
thl_log_id | th_id | integer | NO | Unique sequential identifier for the history record. |
Relationships
Outgoing foreign keys
No outgoing foreign keys found.
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_tenant_history_log→thl_log_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_thl_tenant_uuid | NO | btree | thl_tenant_uuid |
Navigation
- Back to main index
- [Back to
cloudindex]../)