Table testdb.public.com_transport_unit 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_transport_unit.c_parent com_tu_fk_tu_parent R
com_unit_error.c_tu_id fk_tu_error_pk R
c_created timestamp 29,6  √  null
c_updated timestamp 29,6  √  null
c_ol int8 19  √  null
c_pid varchar 255
c_actual_location_date timestamp 29,6  √  null
c_barcode varchar 20
c_empty bool 1  √  null
c_group_id varchar 255  √  null
c_inventory_date timestamp 29,6  √  null
c_inventory_user varchar 255  √  null
c_state varchar 255  √  null
c_weight numeric 19,2  √  null
c_weight_uom int4 10  √  null
c_actual_location int8 19
com_location.c_pk com_tu_fk_loc_actual R
c_parent int8 19  √  null
com_transport_unit.c_pk com_tu_fk_tu_parent R
c_target_location int8 19  √  null
com_location.c_pk com_tu_fk_loc_target R
c_transport_unit_type int8 19
com_transport_unit_type.c_pk com_tu_fk_tut R

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

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc com_transport_unit_pkey
c_barcode Must be unique Asc com_transport_unit_barcode

Close relationships  within of separation: