Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| audit_event_id | uuid | 2147483647 | null |
|
|
||||||
| company_id | uuid | 2147483647 | null |
|
|
||||||
| actor_type | varchar | 30 | null |
|
|
||||||
| actor_id | uuid | 2147483647 | √ | null |
|
|
|||||
| user_role | varchar | 20 | √ | null |
|
|
|||||
| action | varchar | 60 | null |
|
|
||||||
| target_type | varchar | 40 | null |
|
|
||||||
| target_id | uuid | 2147483647 | null |
|
|
||||||
| request_id | varchar | 128 | null |
|
|
||||||
| trace_id | varchar | 64 | √ | null |
|
|
|||||
| event_version | varchar | 30 | null |
|
|
||||||
| change_summary | varchar | 500 | null |
|
|
||||||
| created_at | timestamptz | 35,6 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_audit_event | Primary key | Asc | audit_event_id |
| idx_audit_event_actor_time | Performance | Asc/Asc/Asc/Asc | company_id + actor_type + actor_id + created_at |
| idx_audit_event_company_time | Performance | Asc/Asc | company_id + created_at |
| idx_audit_event_target_time | Performance | Asc/Asc/Asc/Asc | company_id + target_type + target_id + created_at |
| idx_audit_event_trace | Performance | Asc/Asc | company_id + trace_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| ck_audit_event_request_not_blank | (char_length(TRIM(BOTH FROM request_id)) > 0) |
| ck_audit_event_target_type_not_blank | (char_length(TRIM(BOTH FROM target_type)) > 0) |
| ck_audit_event_user_role | ((user_role IS NULL) OR ((user_role)::text = ANY ((ARRAY['ADMIN'::character varying, 'HR'::character varying, 'VIEWER'::character varying])::text[]))) |
| ck_audit_event_version_not_blank | (char_length(TRIM(BOTH FROM event_version)) > 0) |
| ck_audit_event_actor_type | ((actor_type)::text = ANY ((ARRAY['HR_USER'::character varying, 'WORKER_LINK'::character varying, 'AI_AGENT'::character varying, 'SYSTEM_RULE'::character varying])::text[])) |
| ck_audit_event_action_not_blank | (char_length(TRIM(BOTH FROM action)) > 0) |
| ck_audit_event_summary_not_blank | (char_length(TRIM(BOTH FROM change_summary)) > 0) |
Relationships
Close relationships within degrees of separation
