Table alter.public.mis_purc_invoice_lines
Righe di fatture di acquisto

 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_invoice_line_id int4 10
mis_fast_purc_invoice_lines.purc_invoice_line_id Implied Constraint
acs_objects.object_id mis_purc_invoice_lines_purc_invoice_line_id_fkey
purc_invoice_id int4 10
mis_purc_invoices.purc_invoice_id mis_purc_invoice_lines_purc_invoice_id_fkey
purc_invoice_seq int4 10  √  null
rec_line_id int4 10  √  null
mis_rec_note_lines.rec_line_id mis_purc_invoice_lines_rec_line_id_fkey
product_id int4 10  √  null
mis_products.product_id mis_purc_invoice_lines_product_id_fkey
item_description text 2147483647  √  null
iva_id int4 10
mis_iva.iva_id mis_purc_invoice_lines_iva_id_fkey
account_id int4 10  √  null
mis_accounts.account_id mis_purc_invoice_lines_account_id_fkey
purc_um_id int4 10
mis_um.um_id mis_purc_invoice_lines_purc_um_id_fkey
conversion_factor numeric 11,4  √  null
inv_qty numeric 11,2  √  null
product_price numeric 17,5  √  null
discount numeric 5,2  √  null
discount_2 numeric 5,2  √  null
discount_3 numeric 5,2  √  null
line_notes text 2147483647  √  null
iva_amount numeric 11,2  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
purc_invoice_line_id Primary key Asc mis_purc_invoice_lines_pkey
purc_invoice_id Performance Asc mis_purc_invoice_lines_indx_invoice_id
product_id Performance Asc mis_purc_invoice_lines_indx_product_id
rec_line_id Performance Asc mis_purc_invoice_lines_indx_rec_line_id

Close relationships  within one two degrees of separation :