Table alter.public.mis_purc_price_lists 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_list_id int4 10
mis_cust_price_map.price_list_id mis_cust_price_map_price_list_id_fkey
mis_purc_list_prices.price_list_id mis_purc_list_prices_price_list_id_fkey
mis_purc_prices.price_list_id Implied Constraint
mis_purc_products_with_prices.price_list_id Implied Constraint
vendor_id int4 10
mis_parties.party_id mis_purc_price_lists_vendor_id_fkey
price_list_name varchar 60
valid_from date 13
valid_to date 13  √  null
is_tax_included_p bool 1 false
currency bpchar 3 'EUR'::bpchar
currencies.codea mis_purc_price_lists_currency_fkey
default_discount numeric 5,2  √  0
default_discount_2 numeric 5,2  √  0
default_discount_3 numeric 5,2  √  0
default_sale_discount numeric 5,2  √  0 Applicabile solo in assenza di uno sconto specifico del cliente su questo listino
default_sale_discount_2 numeric 5,2  √  0
default_sale_discount_3 numeric 5,2  √  0

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

Indexes:
Column(s) Type Sort Constraint Name
price_list_id Primary key Asc mis_purc_price_lists_pkey

Close relationships  within one two degrees of separation :