Table testdb.public.wms_rec_order 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_locked bool 1  √  null
c_priority int4 10  √  null
c_problem_message_no int4 10  √  null
c_created timestamp 29,6  √  null
c_ended_at timestamp 22  √  null
c_expected_receipt timestamp 22  √  null
c_latest_due_at timestamp 22  √  null
c_next_alloc_at timestamp 22  √  null
c_ol int8 19  √  null
c_pk int8 19
wms_rec_order_detail.c_order_pk fk_details_ro R
c_problem_occurred timestamp 29,6  √  null
c_start_earliest_at timestamp 22  √  null
c_started_at timestamp 22  √  null
c_updated timestamp 29,6  √  null
c_created_by varchar 255  √  null
c_order_id varchar 255
wms_rec_order_pos_product.c_order_id fk_im2bv9ryrvfg7eymfblkxwhre R
wms_rec_order_pos_tu.c_order_id fk_kiut0n2iu98su280ewqhtvvpi R
c_order_state varchar 255  √  null
c_pid varchar 255
c_problem_message varchar 255  √  null
c_updated_by varchar 255  √  null

Table contained 2 rows at Tue Dec 24 19:15 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc wms_rec_order_pkey
c_order_id Must be unique Asc uc_rec_order_id
c_pid Must be unique Asc wms_rec_order_c_pid_key

Close relationships  within of separation: