Table alter.public.mis_purc_list_prices Generated by
SchemaSpy
Implied relationships 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
price_id int4 10
mis_purc_prices.price_id Implied Constraint
mis_purc_products_with_prices.price_id Implied Constraint
price_list_id int4 10
mis_purc_price_lists.price_list_id mis_purc_list_prices_price_list_id_fkey
product_id int4 10
mis_products.product_id mis_purc_list_prices_product_id_fkey
purc_um_id int4 10
mis_um.um_id mis_purc_list_prices_purc_um_id_fkey
conversion_factor float8 17,17 1 Fattore di conversione fra um_id e purc_um_id
purc_base_price numeric 17,5
purc_net_price numeric 17,5  √  null Se digitato prescinde dagli sconti d'acquisto e prevale sul prezzo netto calcolato in base a questi.
discount numeric 5,2  √  0
discount_2 numeric 5,2  √  0
discount_3 numeric 5,2  √  0
sale_base_price numeric 17,5 Prezzo di vendita raccomandato.
sale_public_price numeric 17,5  √  null Prezzo di vendita imposto al pubblico.
sale_min_price numeric 17,5  √  0
sale_max_price numeric 17,5  √  0

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

Indexes:
Column(s) Type Sort Constraint Name
price_id Primary key Asc mis_purc_list_prices_pkey
product_id Performance Asc mis_purc_list_prices_indx_product_id
price_list_id + product_id Must be unique Asc/Asc mis_purc_list_prices_un_indx

Close relationships  within one two degrees of separation :