Table alter.public.mis_projects
Questa tabella costituisce una estensione di <code>mis_accounts</code>, di cui condivide
la chiave primaria e i campi descrittivi account_code e account_description usati per memorizzare
codice e descrizione del progetto.

La tabella, assieme alla compagna <code>mis_centers</code>, serve per creare un piano dei conti
di contabilità industriale, sfruttando a questo scopo la capacità di definire le gerarchie tipiche
della contabilità.

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
project_id int4 10
mis_all_orders.project_id Implied Constraint
mis_bids.project_id Implied Constraint
mis_fast_bids.project_id Implied Constraint
mis_fast_orders.project_id Implied Constraint
mis_orders.project_id mis_orders_project_id_fk
mis_projects_view.project_id Implied Constraint
mis_accounts.account_id mis_projects_project_id_fkey
customer_id int4 10
mis_parties.party_id mis_projects_customer_id_fkey
payment_days int4 10  √  null
project_type bpchar 1 T=Tariffa C=Corpo
um_id int4 10
mis_um.um_id mis_projects_um_id_fkey
is_active_p bool 1
start_date date 13  √  null
end_date date 13  √  null
amount numeric 13,2  √  null
bid_id int4 10  √  null
mis_bids.bid_id mis_projects_bid_id_fkey
comments text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
project_id Primary key Asc mis_projects_pkey

Close relationships  within one two degrees of separation :