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_tu_reservation.c_transport_unit_pk fk_tureservation_pk R
com_unit_error.c_tu_id fk_tu_error_pk 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_actual_location_date timestamp 29,6  √  null
c_barcode varchar 20
c_empty bool 1  √  null
c_group_name varchar 255  √  null
c_inventory_date timestamp 29,6  √  null
c_inventory_user varchar 255  √  null
c_state varchar 255  √  null
c_weight numeric 38,2  √  null
c_weight_uom int2 5  √  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 Mon Sep 02 15:06 UTC 2024

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
c_pid Must be unique Asc uk_kc2o74wfovxldm50nv2vtt3jy

Close relationships  within of separation: