Table alter.public.mis_bid_lines 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
line_id int4 10
acs_objects.object_id mis_bid_lines_line_id_fkey
bid_id int4 10
mis_bids.bid_id mis_bid_lines_bid_id
line_no int4 10
option_code varchar 20  √  null
line_days_from_order int4 10  √  0
product_id int4 10
mis_products.product_id mis_bid_lines_product_id
description text 2147483647  √  null
sell_um_id int4 10
mis_um.um_id mis_bid_lines_sell_um_id
conversion_factor numeric 11,4 1
qty_ordered numeric 11,2
product_price numeric 17,5
discount numeric 5,2  √  0
discount_2 numeric 5,2  √  0
discount_3 numeric 5,2  √  0
notes text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
line_id Primary key Asc mis_bid_lines_pkey
bid_id Performance Asc mis_bid_lines_indx_bid_id
product_id Performance Asc mis_bid_lines_indx_product_id

Close relationships  within one two degrees of separation :