Table webco_4.7.public.department 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
account_code.department_oid fkcdepartment_oid
allocation.paying_department_oid fkcalloc_paying_department_oid
department_code.department_oid fkcdepartment_code_department_oid
inventory_item.inventoried_assigned_department_oid inventory_item_inventoried_assigned_department_oid_fkey
invoice.paying_dept_oid fkcinvoice_paying_dept_oid
resource.assigned_department_oid fkcres_department
name varchar 2147483647
billing_contact_oid int8 19  √  null
person.obj_oid fkcdepartment_billing_contact_oid
street varchar 2147483647  √  null
street2 varchar 2147483647  √  null
city varchar 2147483647  √  null
state varchar 2147483647  √  null
postal_code varchar 2147483647  √  null
country varchar 2147483647  √  null
email varchar 2147483647  √  null
telephone varchar 2147483647  √  null
fax varchar 2147483647  √  null
tax_exempt_number varchar 2147483647  √  null
origin varchar 2147483647
deleted bool 1  √  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 department_pkey

Close relationships  within of separation: