Table testdb.public.wms_inv_revision 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
wms_inv_load_unit_log.c_rev fkm2po2n1yu8fsjcvl6nogv77u1 C
wms_inv_location_log.c_rev fk3l03d64363600clx5swd3nj4q C
wms_inv_packaging_unit_detail_log.c_rev fk6llyhpk51fjpnktmb99via5g2 C
wms_inv_packaging_unit_log.c_rev fkorslxj6jole226itq5c7cy8ax C
wms_inv_product_log.c_rev fkohnu07jp5ap56k4v5miwck3gp C
wms_inv_product_unit_detail_log.c_rev fk3r0c5pcatxo7hsicd6ekferl2 C
wms_inv_product_unit_log.c_rev fk8r2s3dnwvi0mxhuj7cvae90u9 C
wms_inv_reservation_log.c_rev fk33u5lgnhso12itvwasgvrvkno C
c_timestamp int8 19  √  null
c_trace_id varchar 255  √  null
c_user varchar 255  √  null

Table contained 3 rows at Mon Aug 21 16:18 UTC 2023

Indexes:
Column(s) Type Sort Constraint Name
c_pk Primary key Asc wms_inv_revision_pkey

Close relationships: