Table alter.public.mis_wh_mov_types 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_type_id int4 10
mis_wh_mov.wh_mov_type mis_wh_mov_wh_mov_type_fkey
wh_mov_type_code varchar 3  √  null
mis_bill_types.from_mov_type mis_bill_types_from_mov_type_fkey
mis_bill_types.to_mov_type mis_bill_types_to_mov_type_fkey
wh_mov_type_description varchar 50  √  null
wh_mov_type_sign bpchar 1  √  null
wh_mov_type_qty_type varchar 15 'qty'::character varying Definisce la grandezza gestita dal movimento (qty, on_order, qty_reserved)
is_manual_p bool 1  √  null

Table contained 9 rows at Fri Feb 29 12:05 CET 2008

Indexes:
Column(s) Type Sort Constraint Name Anomalies
wh_mov_type_id Primary key Asc mis_wh_mov_types_pkey  
wh_mov_type_code Must be unique Asc mis_wh_mov_types_wh_mov_type_code_key This unique column is also nullable

Close relationships  within one two degrees of separation :