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
wms_inv_tu_reservation_log.c_rev fk8j2r9hdh93nvyljxgyl0oqoet C
c_timestamp int8 19  √  null
c_trace_id varchar 255  √  null
c_user varchar 255  √  null

Table contained 0 rows at Sun Mar 09 14:41 UTC 2025

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

Close relationships: