Table webco_3.9.3.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
dat_organization.org_oid fkcdat_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_authorization.organization fkauth_org
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 timestamp 29,6  √  null
semester_end timestamp 29,6  √  null
due_days varchar 2147483647  √  null
hold_days varchar 2147483647  √  null
honor_external_holds varchar 2147483647  √  null
honor_external_fines varchar 2147483647  √  null
messaging_from_address varchar 2147483647  √  null
fine_account varchar 2147483647  √  null
default_billing_type varchar 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 Wed May 07 11:05 EDT 2014

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

Close relationships  within of separation: