Table alter.public.mis_bids 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
bid_id int4 10
mis_all_orders.bid_id Implied Constraint
mis_bid_lines.bid_id mis_bid_lines_bid_id
mis_fast_bid_lines.bid_id Implied Constraint
mis_fast_bids.bid_id Implied Constraint
mis_fast_orders.bid_id Implied Constraint
mis_orders.bid_id mis_orders_bid_id_fk
mis_projects.bid_id mis_projects_bid_id_fkey
mis_projects_view.bid_id Implied Constraint
acs_objects.object_id mis_bids_bid_id_fkey
bid_code varchar 20  √  null
bid_date date 13  √  null
days_valid int4 10  √  null
customer_id int4 10  √  null
mis_parties.party_id mis_bids_customer_id_fk
description text 2147483647  √  null
language_id bpchar 2  √  null
language_codes.language_id mis_bids_fk_language_id
bank_id int4 10  √  null
mis_banks.bank_id mis_bids_fk_bank_id
port_id int4 10  √  null
categories.category_id mis_bids_fk_port_id
payment_id int4 10  √  null
mis_payments.payment_id mis_bids_fk_payment_id
shipping_id int4 10  √  null
categories.category_id mis_bids_fk_shipping_id
guarantee_id int4 10  √  null
categories.category_id mis_bids_fk_guarantee_id
days_from_order int4 10  √  null
sale_rep_id int4 10  √  null
categories.category_id mis_bids_sale_rep_id_fk
currency bpchar 3  √  null
currencies.codea mis_bids_currency_fk
carrier_id int4 10  √  null
categories.category_id mis_bids_fk_carrier_id
project_id int4 10  √  null
mis_projects.project_id Implied Constraint
is_approved_p bool 1  √  null
is_printed_p bool 1  √  null
result bpchar 1  √  null
accepted_on date 13  √  null
zone_id int4 10  √  null
categories.category_id mis_bids_zone_id_fk
address_id int4 10  √  null
mis_addresses.address_id mis_bids_fk_address_id
shipping_address text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bid_id Primary key Asc mis_bids_pkey
bid_code Performance Asc mis_bids_indx_bid_code
customer_id Performance Asc mis_bids_indx_customer_id

Close relationships  within one two degrees of separation :