Table testdb.public.wms_rec_order_pos_product 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_pos_no int4 10
c_created timestamp 29,6  √  null
c_latest_due timestamptz 35,6  √  null
c_ol int8 19  √  null
c_pk int8 19
c_updated timestamp 29,6  √  null
c_qty_expected varchar 16
c_qty_received varchar 16  √  null
c_created_by varchar 255  √  null
c_order_id varchar 255
wms_rec_order.c_order_id fk_im2bv9ryrvfg7eymfblkxwhre R
c_qty_expected_type varchar 255
c_qty_received_type varchar 255  √  null
c_sku varchar 255
wms_rec_product.c_sku fk_rec_pos_product R
c_state varchar 255
c_updated_by varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc wms_rec_order_pos_product_pkey
c_order_id + c_pos_no Must be unique Asc/Asc uc_order_id_pos

Close relationships  within of separation: