Table alter.public.mis_accounts 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
account_id int4 10
mis_accounts_view.account_id Implied Constraint
mis_acct_plan.child_id mis_acct_plan_child_id_fkey
mis_acct_plan.parent_id mis_acct_plan_parent_id_fkey
mis_bank_accounts.account_id mis_bank_accounts_account_id_fkey
mis_bank_accounts.factoring_account_id mis_bank_accounts_factoring_account_id_fkey
mis_bank_accounts.pres_account_id mis_bank_accounts_pres_account_id_fkey
mis_bank_accounts.unsolved_account_id mis_bank_accounts_unsolved_account_id_fkey
mis_banks_view.account_id Implied Constraint
mis_canonical_accounts.account_id Implied Constraint
mis_centers.center_id mis_centers_center_id_fkey
mis_delivery_note_lines.account_id mis_delivery_note_lines_account_id_fkey
mis_fast_delivery_note_lines.account_id Implied Constraint
mis_fast_mrs.account_id Implied Constraint
mis_fast_po_lines.account_id Implied Constraint
mis_fast_pos.account_id Implied Constraint
mis_fast_purc_invoice_lines.account_id Implied Constraint
mis_fast_sale_invoice_lines.account_id Implied Constraint
mis_mov_accounts.account_id mis_mov_accounts_account_id_fkey
mis_mov_accounts_view.account_id Implied Constraint
mis_mrs.account_id mis_mrs_account_id_fk
mis_party_accounts.fin_account_id mis_party_accounts_fin_account_id_fkey
mis_party_accounts.mgm_account_id mis_party_accounts_mgm_account_id_fkey
mis_po_lines.account_id mis_po_lines_account_id_fk
mis_pos.account_id mis_mrs_account_id_fk
mis_product_categories.account_id mis_product_categories_account_id_fkey
mis_projects.project_id mis_projects_project_id_fkey
mis_purc_invoice_lines.account_id mis_purc_invoice_lines_account_id_fkey
mis_sale_invoice_lines.account_id mis_sale_invoice_lines_account_id_fkey
acs_objects.object_id mis_accounts_account_id_fkey
account_code varchar 30  √  null
account_description varchar 50  √  null
account_class bpchar 1  √  null E=Economico P=Patrimoniale
canonical_p bool 1  √  null I codici dei conti <em>canonici</em> devono avere una lunghezza coerente rispetto a quanto
stabilito nei parametri master_length, submaster_length e subcode_length.
Inoltre per i conti canonici viene mantenuta automaticamente la struttura gerarchica del
piano dei conti canonico.
I conti identificati come NON <em>canonici</em> possono invece avere qualsiasi lunghezza
e NON fanno parte del piano dei conti canonico, ma possono essere usati nei piani dei conti
riclassificati ovvero per rappresentare delle imputazioni di contabilità industriale (ad.es.
progetti e CDC).

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
account_id Primary key Asc mis_accounts_pkey  
account_code Must be unique Asc mis_accounts_indx_account_code This unique column is also nullable

Close relationships  within one two degrees of separation :