Table webco_3.9.3.public.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
invoice_tax_rate.invoice_oid invoice_tax_rate_invoice_oid_fkey
invoices_pending_export.invoice_oid invoices_pending_export_invoice_oid_fkey
invoice_id varchar 2147483647  √  null
invoice_status varchar 2147483647  √  null
payment_rule varchar 2147483647  √  null
person_oid int8 19  √  null
person.obj_oid fkcinvoice_person_oid
org_oid int8 19  √  null
organization.obj_oid fkcinvoice_org_oid
cc_oid int8 19  √  null
location.obj_oid fkcinvoice_cc_oid
allocation_oid int8 19  √  null
allocation.obj_oid fkcinvoice_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  √  1
person.obj_oid fkcinvoice_created_by
class varchar 2147483647  √  null
modified timestamp 29,6  √  null
modified_by int8 19  √  null
person.obj_oid fkcinvoice_modified_by
paying_dept_oid int8 19  √  null
department.obj_oid fkcinvoice_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 fkcinvoice_real_payee
ready_to_bill bool 1  √  null
taxable bool 1  √  null
balance int8 19  √  null
po_number varchar 2147483647  √  null
credit_card_type varchar 2147483647  √  null
event_description varchar 2147483647  √  null
reference_id varchar 2147483647  √  null
project_code varchar 2147483647  √  null

Table contained 0 rows at Wed May 07 11:05 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc invoice_pkey
allocation_oid Performance Asc invoice_allocation_idx
invoice_id Performance Asc invoice_id_idx
cc_oid Performance Asc invoice_location_idx
org_oid Performance Asc invoice_organization_idx
paying_dept_oid Performance Asc invoice_paying_department_idx
person_oid Performance Asc invoice_person_idx

Close relationships  within of separation: