Table webco_3.5.5.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
struck bool 1  √  null
type varchar 2147483647  √  null
subtype varchar 2147483647  √  null
invoice_oid int8 19
wco_invoice.obj_oid invoice_line_invoice_oid_fkey
resource_oid int8 19  √  null
resource.obj_oid fkinv_line_res
description varchar 2147483647  √  null
amount int8 19  √  null
creation_date timestamp 29,6  √  null
created_by int8 19  √  null
person.obj_oid fkinv_line_created_by
modified timestamp 29,6  √  null
modified_by int8 19  √  null
person.obj_oid fkinv_line_modified_by
tax int8 19  √  null
taxable bool 1  √  null
quantity int8 19  √  null

Table contained 0 rows at Mon Mar 15 14:58 EDT 2010

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

Close relationships  within of separation: