Table webco_4.7.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 wcof_tag 2147483647  √  null
payment_rule wcof_tag 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
checkout_center.obj_oid fkcinvoice_cc_oid
allocation_oid int8 19  √  null
allocation.obj_oid fkcinvoice_alloc_oid
description varchar 2147483647  √  null
creation_date timestamptz 35,6  √  null
due_date timestamptz 35,6  √  null
hold_date timestamptz 35,6  √  null
created_by int8 19  √  1
person.obj_oid fkcinvoice_created_by
class wcof_tag 2147483647  √  null
modified timestamptz 35,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 timestamptz 35,6  √  null
type_of_payment wcof_tag 2147483647  √  null
real_payee int8 19  √  null
person.obj_oid fkcinvoice_real_payee
ready_to_bill bool 1  √  null
taxable bool 1  √  null
balance odcl_money 2147483647  √  null
po_number varchar 2147483647  √  null
reference_id varchar 2147483647  √  null
project_code varchar 2147483647  √  null
credit_card_type varchar 2147483647  √  null
event_description varchar 2147483647  √  null

Table contained 0 rows at Thu Feb 14 09:20 CST 2019

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

Close relationships  within of separation: