Table alter.public.mis_mr_lines 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
line_id int4 10
mis_contract_lines.line_id Implied Constraint
mis_fast_bid_lines.line_id Implied Constraint
mis_fast_mr_lines.line_id Implied Constraint
mis_fast_order_lines.line_id Implied Constraint
mis_fast_po_lines.line_id Implied Constraint
mis_po_lines.mr_line_id mis_po_lines_mr_line_id_fk
acs_objects.object_id mis_mr_lines_line_id_fk
mr_id int4 10
mis_mrs.mr_id mis_mr_lines_mr_id_fk
line_no int4 10
product_id int4 10
mis_products.product_id mis_mr_lines_product_id_fk
qty_requested numeric 11,2
line_date_requested date 13  √  null
line_state bpchar 1  √  null O=Open C=Closed
description text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
line_id Primary key Asc mis_mr_lines_pkey
mr_id + line_no Performance Asc/Asc mis_mr_lines_indx_mr_id
product_id Performance Asc mis_mr_lines_indx_product_id

Close relationships  within one two degrees of separation :