Table webco_4.2.0.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
dat_organization.org_oid dat_organization_org_oid_fkey
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_group.organization_oid fkcwco_group_organization_oid
wco_log.org_oid fkcwco_log_org_oid
name varchar 2147483647  √  null
rtype_oid int8 19  √  null
resource_type.obj_oid fkorg_rtype
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
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

Table contained 1 rows at Tue Mar 03 15:50 EST 2015

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

Close relationships  within of separation: