Table testdb.public.act_hi_dec_in 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
dec_inst_id_ varchar 64
clause_id_ varchar 64  √  null
clause_name_ varchar 255  √  null
var_type_ varchar 100  √  null
bytearray_id_ varchar 64  √  null
double_ float8 17,17  √  null
long_ int8 19  √  null
text_ varchar 4000  √  null
text2_ varchar 4000  √  null
tenant_id_ varchar 64  √  null
create_time_ timestamp 29,6  √  null
root_proc_inst_id_ varchar 64  √  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_dec_in_pkey
dec_inst_id_ + clause_id_ Performance Asc/Asc act_idx_hi_dec_in_clause
dec_inst_id_ Performance Asc act_idx_hi_dec_in_inst
removal_time_ Performance Asc act_idx_hi_dec_in_rm_time
root_proc_inst_id_ Performance Asc act_idx_hi_dec_in_root_pi