Table alter.public.mis_addresses
La sequenza country_iso, cc_iban, cin, abi, cab, cc (dove abi e cab
sono dedotte dall'anagrafica della banca) costituisce il cosiddetto
codice IBAN (International Bank Account Number)

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
address_id int4 10
mis_all_orders.address_id Implied Constraint
mis_bids.address_id mis_bids_fk_address_id
mis_customers.address_id Implied Constraint
mis_delivery_notes.address_id mis_delivery_notes_address_id_fkey
mis_fast_bids.address_id Implied Constraint
mis_fast_customers.address_id Implied Constraint
mis_fast_delivery_notes.address_id Implied Constraint
mis_fast_orders.address_id Implied Constraint
mis_fast_parties.address_id Implied Constraint
mis_fast_vendors.address_id Implied Constraint
mis_orders.address_id mis_orders_address_id_fk
mis_parties.default_address_id mis_parties_fk_default_address_id
mis_vendors.address_id Implied Constraint
party_id int4 10
mis_parties.party_id mis_addresses_party_id_fkey
address_code varchar 10 Codice identificativo univoco dell'indirizzo. Il codice 001 è magico ed individua
l'indirizzo della Sede Legale
address_name varchar 32  √  null
address1 varchar 32
address2 varchar 32  √  null
subaddr varchar 100  √  null
city varchar 32  √  null
province varchar 4  √  null
state varchar 32  √  null
zipcode varchar 10  √  null
country_iso bpchar 2  √  null
countries.iso mis_addresses_country_iso_fkey
contact text 2147483647  √  null
phone varchar 35  √  null
fax varchar 35  √  null
email text 2147483647  √  null
url varchar 100  √  null
cc bpchar 12  √  null
bank_id int4 10  √  null
mis_banks.bank_id mis_addresses_bank_id_fkey
Questa è la banca del soggetto in questa specifica ubicazione.
cc_iban bpchar 2  √  null
cin bpchar 1  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
address_id Primary key Asc mis_addresses_pkey
party_id + address_code Must be unique Asc/Asc mis_addresses_indx

Close relationships  within one two degrees of separation :