Table webco_4.7.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_delegation.org_oid fkcauthset_delegation_org_oid
checkout_center.org_oid checkout_center_org_oid_fkey
email_template.organization_oid email_template_organization_oid_fkey
email_template_set.organization_oid email_template_set_organization_oid_fkey
hold.organization_oid fkchold_organization_oid
inventory.organization_oid inventory_organization_oid_fkey
invoice.org_oid fkcinvoice_org_oid
person_role.organization_oid fkcapability_organization_oid
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
reply_to_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
email_template_set_oid int8 19  √  null
email_template_set.obj_oid organization_email_template_set_oid_fkey

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

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

Close relationships  within of separation: