Table testdb.public.com_location_group 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
c_pk int8 19
com_location.c_location_group fk_loc_lg R
com_location_group.c_in_locker fk_lg_lg_inlocker R
com_location_group.c_out_locker fk_lg_lg_outlocker R
com_location_group.c_parent fk_lg_lg_parent R
c_created timestamp 29,6  √  null
c_created_by varchar 255  √  null
c_updated_by varchar 255  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_pid varchar 255
c_description varchar 255  √  null
c_group_state_in varchar 255
c_group_state_out varchar 255
c_group_type varchar 255  √  null
c_group_counting_active bool 1  √  null
c_max_fill_level float4 8,8  √  null
c_name varchar 255
c_op_mode varchar 255  √  null
c_system_code varchar 255  √  null
c_system_name varchar 255  √  null
c_account varchar 255  √  null
com_account.c_identifier fk_lg_acc R
c_parent int8 19  √  null
com_location_group.c_pk fk_lg_lg_parent R
c_in_locker int8 19  √  null
com_location_group.c_pk fk_lg_lg_inlocker R
c_out_locker int8 19  √  null
com_location_group.c_pk fk_lg_lg_outlocker R

Table contained 42 rows at Mon Sep 02 15:06 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc com_location_group_pkey
c_name Must be unique Asc uc_lg_name
c_pid Must be unique Asc uk_9a9we4uv0famk8k7878pqh710

Close relationships  within of separation: