Table webco_4.3.1.public.invoice_line Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19
invoice_line_tax_rate.invoice_line_oid invoice_line_tax_rate_invoice_line_oid_fkey
struck bool 1  √  null
type wcof_tag 2147483647  √  null
subtype wcof_tag 2147483647  √  null
invoice_oid int8 19  √  null
invoice.obj_oid invoice_line_invoice_oid_fkey
resource_oid int8 19  √  null
resource.obj_oid fkinv_line_res
description varchar 2147483647  √  null
amount odcl_money 2147483647  √  null
creation_date timestamptz 35,6  √  null
created_by int8 19  √  1
person.obj_oid fkinv_line_created_by
modified timestamptz 35,6  √  null
modified_by int8 19  √  1
person.obj_oid fkinv_line_modified_by
tax odcl_money 2147483647  √  null
quantity int8 19  √  null

Table contained 0 rows at Tue Jun 21 07:45 CDT 2016

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc invoice_line_pkey
invoice_oid Performance Asc invoice_line_invoice_idx
resource_oid Performance Asc invoice_line_resource_idx

Close relationships  within of separation: