Table webco_3.5.5.public.wco_invoice 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
hold.invoice_oid fkchold_invoice_oid
invoice_line.invoice_oid invoice_line_invoice_oid_fkey
waived bool 1  √  null
editable bool 1  √  null
processor_state varchar 2147483647  √  null
payment_rule varchar 2147483647  √  null
person_oid int8 19  √  null
person.obj_oid fkcwco_invoice_person_oid
org_oid int8 19  √  null
organization.obj_oid fkcwco_invoice_org_oid
cc_oid int8 19  √  null
location.obj_oid fkcwco_invoice_cc_oid
allocation_oid int8 19  √  null
allocation.obj_oid fkcwco_invoice_alloc_oid
description varchar 2147483647  √  null
creation_date timestamp 29,6  √  null
due_date timestamp 29,6  √  null
hold_date timestamp 29,6  √  null
created_by int8 19  √  null
person.obj_oid fkcwco_invoice_created_by
class varchar 2147483647  √  null
modified timestamp 29,6  √  null
modified_by int8 19  √  null
person.obj_oid fkcwco_invoice_modified_by
paying_dept_oid int8 19  √  null
department.obj_oid fkcwco_invoice_paying_dept_oid
paying_account varchar 2147483647  √  null
date_paid timestamp 29,6  √  null
type_of_payment varchar 2147483647  √  null
real_payee int8 19  √  null
person.obj_oid fkcwco_invoice_real_payee
ready_to_bill bool 1  √  null
taxable bool 1  √  null
po_number varchar 2147483647  √  null
event_description varchar 2147483647  √  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 wco_invoice_pkey
allocation_oid Performance Asc invoice_allocation_idx

Close relationships  within of separation: