SchemaSpy Analysis of testdb.public Generated by
SchemaSpy
Generated by SchemaSpy on Tue May 12 23:37 CEST 2020
Database Type: PostgreSQL - 12.1

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Rows Comments
act_hi_actinst 21 112
act_hi_attachment 14 0
act_hi_batch 13 0
act_hi_caseactinst 16 0
act_hi_caseinst 12 0
act_hi_comment 12 0
act_hi_dec_in 14 0
act_hi_dec_out 17 0
act_hi_decinst 21 0
act_hi_detail 27 252
act_hi_ext_task_log 19 0
act_hi_identitylink 13 0
act_hi_incident 18 0
act_hi_job_log 22 0
act_hi_op_log 24 0
act_hi_procinst 19 28
act_hi_taskinst 26 0
act_hi_varinst 24 252
act_id_group 2 4 0
act_id_info 8 0
act_id_membership 2 2 0
act_id_tenant 1 3 0
act_id_tenant_member 3 4 0
act_id_user 2 10 0
act_re_case_def 2 11 0
act_re_decision_def 1 14 0
act_re_decision_req_def 1 10 0
act_re_deployment 5 1
act_re_procdef 4 15 1
act_ru_authorization 8 0
act_ru_batch 3 14 0
act_ru_case_execution 7 3 13 0
act_ru_case_sentry_part 2 13 0
act_ru_event_subscr 1 10 0
act_ru_execution 11 4 20 0
act_ru_ext_task 1 17 0
act_ru_filter 7 0
act_ru_identitylink 2 8 0
act_ru_incident 2 6 14 0
act_ru_job 24 0
act_ru_jobdef 4 10 0
act_ru_meter_log 6 19,280
act_ru_task 1 5 21 0
act_ru_variable 4 18 0
com_account 2 8 0
com_location 3 3 26 0
com_location_group 4 4 19 0
com_location_message 2 2 0
com_location_type 2 10 0
com_srv_revision 1 3 0
com_transport_unit 2 4 17 0
com_transport_unit_log 1 16 0
com_transport_unit_type 4 14 0
com_type_placing_rule 2 7 0
com_type_stacking_rule 2 7 0
com_unit_error 1 8 0
cor_message 1 6 0
rsrv_action 1 18 3
rsrv_location 2 7 32
rsrv_route 2 2 12 8
rsrv_route_details 1 8 0
wms_inv_load_unit 1 2 10 0
wms_inv_location 1 14 1
wms_inv_packaging_unit 2 13 0
wms_inv_product 2 11 0
wms_inv_transport_unit 1 1 14 0
wms_rec_order 1 15 1
wms_rec_order_position 3 15 0
wms_rec_order_position_details 1 8 0
wms_rec_product 1 8 2
wms_rec_transport_unit 7 0
wms_shp_order 1 16 1
wms_shp_order_position 1 2 23 1
wms_shp_order_position_split 2 18 0
wms_shp_product 2 7 3
           
75 Tables     988 19,978  
0 Views     0