Table alter.public.mis_rec_notes 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
rec_id int4 10
mis_fast_rec_note_lines.rec_id Implied Constraint
mis_fast_rec_notes.rec_id Implied Constraint
mis_rec_note_lines.rec_id mis_rec_note_lines_rec_id_fkey
mis_rec_note_lines_view.rec_id Implied Constraint
acs_objects.object_id mis_rec_notes_rec_id_fkey
rec_code varchar 10  √  null
rec_date date 13
rec_type varchar 8  √  null generic = BEM generata da ricevimento ordine
vendor = BEM manuale
bill_type_id int4 10  √  null
mis_bill_types.bill_type_id mis_rec_notes_bill_type_id_fkey
po_id int4 10  √  null
mis_pos.po_id mis_rec_notes_po_id_fkey
delivery_code varchar 30  √  null
delivery_date date 13  √  null
bank_id int4 10  √  null
mis_banks.bank_id mis_rec_notes_bank_id_fkey
payment_id int4 10  √  null
mis_payments.payment_id mis_rec_notes_payment_id_fkey
port_id int4 10  √  null
categories.category_id mis_rec_notes_port_id_fkey
shipping_id int4 10  √  null
categories.category_id mis_rec_notes_shipping_id_fkey
packaging_id int4 10  √  null
categories.category_id mis_rec_notes_packaging_id_fkey
package_no int4 10  √  null
net_weight numeric 11,2  √  null
gross_weight numeric 11,2  √  null
rec_text text 2147483647  √  null
is_approved_p bool 1  √  false
store_id int4 10  √  null
mis_stores.store_id mis_rec_notes_store_id_fkey

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

Indexes:
Column(s) Type Sort Constraint Name
rec_id Primary key Asc mis_rec_notes_pkey
po_id Performance Asc mis_rec_notes_po_id_indx

Close relationships  within one two degrees of separation :