Table testdb.public.act_hi_incident Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id_ varchar 64
proc_def_key_ varchar 255  √  null
proc_def_id_ varchar 64  √  null
root_proc_inst_id_ varchar 64  √  null
proc_inst_id_ varchar 64  √  null
execution_id_ varchar 64  √  null
create_time_ timestamp 29,6
end_time_ timestamp 29,6  √  null
incident_msg_ varchar 4000  √  null
incident_type_ varchar 255
activity_id_ varchar 255  √  null
failed_activity_id_ varchar 255  √  null
cause_incident_id_ varchar 64  √  null
root_cause_incident_id_ varchar 64  √  null
configuration_ varchar 255  √  null
history_configuration_ varchar 255  √  null
incident_state_ int4 10  √  null
tenant_id_ varchar 64  √  null
job_def_id_ varchar 64  √  null
annotation_ varchar 4000  √  null
removal_time_ timestamp 29,6  √  null

Table contained 0 rows at Tue Apr 16 13:44 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_hi_incident_pkey
create_time_ Performance Asc act_idx_hi_incident_create_time
end_time_ Performance Asc act_idx_hi_incident_end_time
proc_def_key_ Performance Asc act_idx_hi_incident_proc_def_key
proc_inst_id_ Performance Asc act_idx_hi_incident_procinst
removal_time_ Performance Asc act_idx_hi_incident_rm_time
root_proc_inst_id_ Performance Asc act_idx_hi_incident_root_pi
tenant_id_ Performance Asc act_idx_hi_incident_tenant_id