Table alter.public.mis_purc_paydates
Scadenziario fornitori

 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
purc_paydate_id int4 10
mis_fast_purc_payments.purc_paydate_id Implied Constraint
mis_purc_paydates_view.purc_paydate_id Implied Constraint
mis_purc_payments.purc_paydate_id mis_purc_payments_purc_paydate_id_fkey
purc_invoice_id int4 10
mis_purc_invoices.purc_invoice_id mis_purc_paydates_purc_invoice_id_fkey
pay_date date 13
amount numeric 13,2  √  null
is_effect_p bool 1  √  null
is_closed_p bool 1  √  null
effect_bank_id int4 10  √  null
mis_banks.bank_id mis_purc_paydates_effect_bank_id_fkey

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

Indexes:
Column(s) Type Sort Constraint Name
purc_paydate_id Primary key Asc mis_purc_paydates_pkey
purc_invoice_id Performance Asc mis_purc_paydates_invoice_id

Close relationships  within one two degrees of separation :