Table testdb.public.com_location 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_message.c_location_id fkcy1pukrprpi3lh48xhf44lk2a R
com_transport_unit.c_actual_location com_tu_fk_loc_actual R
com_transport_unit.c_target_location com_tu_fk_loc_target R
c_created timestamp 29,6  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_pid varchar 255
c_check_state varchar 255  √  null
c_classification varchar 255  √  null
c_considered_in_allocation bool 1  √  null
c_counting_active bool 1  √  null
c_description varchar 255  √  null
c_direct_booking_allowed bool 1  √  null
c_erp_code varchar 255  √  null
c_group varchar 255  √  null
c_incoming_active bool 1  √  null
c_labels varchar 1024  √  null
c_last_movement timestamp 29,6  √  null
c_lg_counting_active bool 1  √  null
c_aisle varchar 255  √  null
c_area varchar 255  √  null
c_x varchar 255  √  null
c_y varchar 255  √  null
c_z varchar 255  √  null
c_maximum_weight numeric 19,2  √  null
c_no_max_transport_units int4 10  √  null
c_outgoing_active bool 1  √  null
c_plc_code varchar 255  √  null
c_plc_state int4 10  √  null
c_stock_zone varchar 255  √  null
c_account varchar 255  √  null
com_account.c_identifier fk_loc_acc R
c_location_group int8 19  √  null
com_location_group.c_pk fk_loc_lg R
c_location_type int8 19  √  null
com_location_type.c_pk fk_loc_lt R

Table contained 32 rows at Sun Oct 03 21:46 UTC 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
c_pk Primary key Asc com_location_pkey  
c_area + c_aisle + c_x + c_y + c_z Must be unique Asc/Asc/Asc/Asc/Asc uc_loc_id These unique columns are also nullable
c_plc_code Must be unique Asc uk_6j2cwfpxn549vlfupsaxh95i4 This unique column is also nullable
c_erp_code Must be unique Asc uk_84fpvvehdtcv8g56lhd5lng38 This unique column is also nullable

Close relationships  within of separation: