Table alter.public.mis_banks
Se il modulo mis-acct è licenziato i campi seguenti
vengono gestiti nella tabella mis_bank_accounts di mapping con i conti:

,account_id integer references mis_accounts(account_id)
,factoring_account_id integer references mis_accounts(account_id)
,unsolved_account_id integer references mis_accounts(account_id)
,unsolved_exp numeric(13, 2) -- costo dell'insoluto

 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
bank_id int4 10
mis_addresses.bank_id mis_addresses_bank_id_fkey
mis_all_orders.bank_id Implied Constraint
mis_bank_accounts.bank_id mis_bank_accounts_bank_id_fkey
mis_banks.effect_bank_id mis_banks_effect_bank_id_fkey
mis_banks_view.bank_id Implied Constraint
mis_bids.bank_id mis_bids_fk_bank_id
mis_customer_dates.effect_bank_id mis_customer_dates_effect_bank_id_fkey
mis_customer_payments.presentation_bank_id mis_customer_payments_presentation_bank_id_fkey
mis_customers.bank_id Implied Constraint
mis_delivery_notes.bank_id mis_delivery_notes_bank_id_fkey
mis_effects.effect_bank_id mis_effects_effect_bank_id_fkey
mis_fast_bids.bank_id Implied Constraint
mis_fast_customers.bank_id Implied Constraint
mis_fast_delivery_notes.bank_id Implied Constraint
mis_fast_orders.bank_id Implied Constraint
mis_fast_parties.bank_id Implied Constraint
mis_fast_pos.bank_id Implied Constraint
mis_fast_purc_invoices.bank_id Implied Constraint
mis_fast_rec_notes.bank_id Implied Constraint
mis_fast_sale_invoices.bank_id Implied Constraint
mis_fast_vendors.bank_id Implied Constraint
mis_orders.bank_id mis_orders_fk_bank_id
mis_parties.company_bank_id mis_parties_fk_bank_id
mis_pos.bank_id mis_pos_fk_bank_id
mis_purc_invoices.bank_id mis_purc_invoices_bank_id_fkey
mis_purc_paydates.effect_bank_id mis_purc_paydates_effect_bank_id_fkey
mis_purc_paydates_view.bank_id Implied Constraint
mis_rec_notes.bank_id mis_rec_notes_bank_id_fkey
mis_sale_invoices.bank_id mis_sale_invoices_bank_id_fkey
mis_sale_invoices.factoring_bank_id mis_sale_invoices_factoring_bank_id_fkey
mis_sale_invoices_view.bank_id Implied Constraint
mis_sale_paydates.bank_id mis_sale_paydates_bank_id_fkey
mis_sale_paydates.effect_bank_id mis_sale_paydates_effect_bank_id_fkey
mis_sale_paydates_view.bank_id Implied Constraint
mis_vendors.bank_id Implied Constraint
bank_code varchar 10  √  null
bank_description varchar 50  √  null
abi bpchar 5  √  null
cab bpchar 5  √  null
effect_bank_id int4 10  √  null
mis_banks.bank_id mis_banks_effect_bank_id_fkey
is_effect_bank bool 1  √  null
iso bpchar 2  √  null
countries.iso Implied Constraint
cc bpchar 2  √  null
cin bpchar 1  √  null
ccn bpchar 12  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bank_id Primary key Asc mis_banks_pkey

Close relationships  within one two degrees of separation :