Table alter.public.mis_wh_mov Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
wh_mov_id int4 10
wh_mov_type int4 10  √  null
mis_wh_mov_types.wh_mov_type_id mis_wh_mov_wh_mov_type_fkey
wh_mov_store_id int4 10  √  null
mis_stores.store_id mis_wh_mov_wh_mov_store_id_fkey
wh_mov_product_id int4 10  √  null
mis_products.product_id mis_wh_mov_wh_mov_product_id_fkey
wh_mov_location_id int4 10  √  null
mis_store_locations.location_id mis_wh_mov_wh_mov_location_id_fkey
wh_mov_account_id int4 10  √  null Imputazione del movimento. Se omessa si assume 'STOCK'.
wh_mov_party_id int4 10  √  null
mis_parties.party_id mis_wh_mov_wh_mov_party_id_fkey
wh_mov_lot_id int4 10  √  null
mis_product_lots.lot_id mis_wh_mov_wh_mov_lot_id_fkey
wh_mov_date date 13  √  null
wh_mov_ref varchar 20  √  null
wh_mov_qty numeric 11,2  √  0
wh_mov_amount numeric 17,5  √  0
wh_mov_notes text 2147483647  √  null
is_revert_p bool 1  √  false
wh_mov_user int4 10  √  null
users.user_id mis_wh_mov_wh_mov_user_fkey
wh_mov_ref_id int4 10  √  null

Table contained 18,690 rows at Fri Feb 29 12:05 CET 2008

Indexes:
Column(s) Type Sort Constraint Name
wh_mov_id Primary key Asc mis_wh_mov_pkey
wh_mov_date + wh_mov_product_id + wh_mov_id Performance Asc/Asc/Asc mis_wh_mov_indx1
wh_mov_product_id + wh_mov_date + wh_mov_store_id Performance Asc/Asc/Asc mis_wh_mov_indx2
wh_mov_ref + wh_mov_product_id Performance Asc/Asc mis_wh_mov_indx3
wh_mov_ref_id Performance Asc mis_wh_mov_indx4

Close relationships  within one two degrees of separation :