public.audit_log¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | false | ||||
| occurred_at | timestamp(0) without time zone | CURRENT_TIMESTAMP | false | (DC2Type:datetime_immutable) | ||
| action | varchar(16) | false | ||||
| target_class | varchar(191) | false | ||||
| target_id | uuid | true | (DC2Type:uuid) | |||
| actor_user_id | uuid | true | (DC2Type:uuid) | |||
| actor_email | varchar(191) | NULL::character varying | true | |||
| request_id | uuid | true | (DC2Type:uuid) | |||
| ip | varchar(255) | NULL::character varying | true | |||
| user_agent | text | true | ||||
| source | varchar(64) | NULL::character varying | true | |||
| changes | json | true | ||||
| before_snapshot | json | true | ||||
| after_snapshot | json | true | ||||
| type | varchar(64) | NULL::character varying | true | |||
| type_id | uuid | true | (DC2Type:uuid) | |||
| actor_role | varchar(64) | NULL::character varying | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| audit_log_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| audit_log_pkey | CREATE UNIQUE INDEX audit_log_pkey ON public.audit_log USING btree (id) |
Relations¶
Generated by tbls