Table testdb.public.wms_inv_reservation_log 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
c_rev int8 19
wms_inv_revision.c_pk fk33u5lgnhso12itvwasgvrvkno C
c_rev_type int2 5  √  null
c_created timestamp 29,6  √  null
c_created_by varchar 255  √  null
c_updated_by varchar 255  √  null
c_updated timestamp 29,6  √  null
c_pid varchar 255  √  null
c_qty_type_reserved varchar 255  √  null
c_qty_reserved varchar 16  √  null
c_reserved_at timestamp 22  √  null
c_reserved_by varchar 255  √  null
c_packaging_unit_pk int8 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
c_pk + c_rev Primary key Asc/Asc wms_inv_reservation_log_pkey

Close relationships  within of separation: