Table alter.public.mis_products 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
product_id int4 10
mis_active_products.product_id Implied Constraint
mis_bid_lines.product_id mis_bid_lines_product_id
mis_contract_lines.product_id Implied Constraint
mis_customers_products_map.product_id mis_customers_products_map_product_id_fkey
mis_delivery_note_lines.product_id mis_delivery_note_lines_product_id_fkey
mis_fast_bid_lines.product_id Implied Constraint
mis_fast_delivery_note_lines.product_id Implied Constraint
mis_fast_mr_lines.product_id Implied Constraint
mis_fast_order_lines.product_id Implied Constraint
mis_fast_po_lines.product_id Implied Constraint
mis_fast_products.product_id Implied Constraint
mis_fast_purc_invoice_lines.product_id Implied Constraint
mis_fast_rec_note_lines.product_id Implied Constraint
mis_fast_sale_invoice_lines.product_id Implied Constraint
mis_inventories.inv_product_id mis_inventories_inv_product_id_fkey
mis_mr_lines.product_id mis_mr_lines_product_id_fk
mis_order_lines.product_id mis_order_lines_product_id
mis_po_lines.product_id mis_po_lines_product_id_fk
mis_product_lots.product_id mis_product_lots_product_id_fkey
mis_product_wh.product_id mis_product_wh_product_id_fkey
mis_purc_invoice_lines.product_id mis_purc_invoice_lines_product_id_fkey
mis_purc_list_prices.product_id mis_purc_list_prices_product_id_fkey
mis_purc_prices.product_id Implied Constraint
mis_purc_products_with_prices.product_id Implied Constraint
mis_quotations.product_id mis_quotations_product_id_fkey
mis_quotations_view.product_id Implied Constraint
mis_rec_note_lines.product_id mis_rec_note_lines_product_id_fkey
mis_rec_note_lines_view.product_id Implied Constraint
mis_sale_invoice_lines.product_id mis_sale_invoice_lines_product_id_fkey
mis_vendors_products_map.product_id mis_vendors_products_map_product_id_fkey
mis_wh_mov.wh_mov_product_id mis_wh_mov_wh_mov_product_id_fkey
acs_objects.object_id mis_products_product_id_fkey
product_code varchar 40  √  null
upper_title varchar 1000  √  null
description text 2147483647  √  null
category_id int4 10  √  null
mis_product_categories.product_category_id mis_products_fk_category
um_id int4 10  √  null
mis_um.um_id mis_products_fk_um
sell_um_id int4 10  √  null
mis_um.um_id mis_products_fk_sell_um
conversion_factor float8 17,17  √  null
is_stocked_p bool 1  √  null
is_purchased_p bool 1  √  null
is_sold_p bool 1  √  null
iva_id int4 10  √  null
mis_iva.iva_id mis_product_iva_id_fk
is_bom_p bool 1  √  null
is_active_p bool 1  √  null
discontinued_by date 13  √  null
weight float8 17,17  √  null
width float8 17,17  √  null
height float8 17,17  √  null
depth float8 17,17  √  null
product_image oid 10  √  null
img_mime_type varchar 50  √  null
img_name varchar 200  √  null
drawing_ref varchar 50  √  null
brand_id int4 10  √  null
categories.category_id mis_product_brand_id_fk
ean_code varchar 13  √  null
unit_cost float8 17,17  √  0

Table contained 2,433 rows at Fri Feb 29 12:05 CET 2008

Indexes:
Column(s) Type Sort Constraint Name Anomalies
product_id Primary key Asc mis_products_pkey  
upper_title Performance Asc mis_products_indx_upper_title  
product_code Must be unique Asc mis_products_product_code This unique column is also nullable

Close relationships  within one two degrees of separation :