Table testdb.public.act_ru_jobdef 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
act_ru_batch.batch_job_def_id_ act_fk_batch_job_def R
act_ru_batch.monitor_job_def_id_ act_fk_batch_monitor_job_def R
act_ru_batch.seed_job_def_id_ act_fk_batch_seed_job_def R
act_ru_incident.job_def_id_ act_fk_inc_job_def R
rev_ int4 10  √  null
proc_def_id_ varchar 64  √  null
proc_def_key_ varchar 255  √  null
act_id_ varchar 255  √  null
job_type_ varchar 255
job_configuration_ varchar 255  √  null
suspension_state_ int4 10  √  null
job_priority_ int8 19  √  null
tenant_id_ varchar 64  √  null
deployment_id_ varchar 64  √  null

Table contained 0 rows at Tue Nov 19 14:56 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_ru_jobdef_pkey
proc_def_id_ Performance Asc act_idx_jobdef_proc_def_id
tenant_id_ Performance Asc act_idx_jobdef_tenant_id

Close relationships  within of separation: