Table testdb.public.com_transport_unit_log 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
c_rev int8 19
com_srv_revision.c_pk fk7hgjsbhte1esjljdnkmxpkk78 R
c_rev_type int2 5  √  null
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_pid varchar 255  √  null
c_actual_location_date timestamp 29,6  √  null
c_barcode varchar 20  √  null
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  √  null
c_parent int8 19  √  null
c_target_location int8 19  √  null
c_transport_unit_type int8 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
c_rev + c_pk Primary key Asc/Asc com_transport_unit_log_pkey

Close relationships  within of separation: