Table webco_4.3.1.public.organization 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
authset.organization_oid fkauthset_organization_oid
hold.organization_oid fkchold_organization_oid
invoice.org_oid fkcinvoice_org_oid
location.org_oid location_org_oid_fkey
resource_type.org_oid fkcresource_type_org_oid
sched_staffed_location.org_oid sched_staffed_location_org_oid_fkey
tax_rate.organization_oid fk_taxrates_organization_oid
wco_application.default_org_oid fkapp_default_org_oid
wco_group.organization_oid fkcwco_group_organization_oid
wco_log.org_oid fkcwco_log_org_oid
name varchar 2147483647  √  null
admin_id int8 19  √  null
person.obj_oid fkcorg_admin_id
restricted bool 1  √  null
suppress_autopayment bool 1  √  null
semester_start timestamptz 35,6  √  null
semester_end timestamptz 35,6  √  null
due_days interval 49,6  √  null
hold_days interval 49,6  √  null
honor_external_holds _int4 10 ARRAY[]::integer[]
honor_external_fines _int4 10 ARRAY[]::integer[]
messaging_from_address varchar 2147483647  √  null
fine_account varchar 2147483647  √  null
default_billing_type wcof_tag 2147483647  √  null
taxable_invoices wcof_tag 2147483647  √  null
constrain_account_codes bool 1  √  null
street varchar 2147483647  √  null
street2 varchar 2147483647  √  null
city varchar 2147483647  √  null
state varchar 2147483647  √  null
country varchar 2147483647  √  null
postal_code varchar 2147483647  √  null
timezone varchar 2147483647  √  null
locale varchar 2147483647  √  null
default_allocation_times wcof_default_allocation_times 2147483647  √  null

Table contained 1 rows at Tue Jun 21 07:45 CDT 2016

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc organization_pkey

Close relationships  within of separation: