rbac_audit_events


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
practice_id text 2147483647 null
schema_migrations.id Implied Constraint R
actor_user_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
actor_user_name text 2147483647 √ null
action text 2147483647 null
target_type text 2147483647 null
target_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
metadata jsonb 2147483647 '{}'::jsonb
created_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
rbac_audit_events_pkey Primary key Asc id
rbac_audit_events_practice_created_idx Performance Asc/Desc practice_id + created_at
rbac_audit_events_target_idx Performance Asc/Asc target_type + target_id

Check Constraints

Constraint Name Constraint
rbac_audit_events_target_type_check ((target_type <> ''::text))
rbac_audit_events_action_check ((action <> ''::text))

Relationships

Close relationships within degrees of separation