Table testdb.public.wms_rec_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_created timestamp 29,6  √  null
c_ol int8 19  √  null
c_pk int8 19
c_updated timestamp 29,6  √  null
c_actual_location varchar 255
c_barcode varchar 255
c_created_by varchar 255  √  null
c_foreign_pid varchar 255
c_pid varchar 255
c_updated_by varchar 255  √  null

Table contained 1 rows at Sat Aug 03 14:21 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc wms_rec_transport_unit_pkey
c_barcode Must be unique Asc uc_rec_tu_barcode
c_foreign_pid Must be unique Asc uc_rec_tu_foreign_pid
c_pid Must be unique Asc wms_rec_transport_unit_c_pid_key