Table webco_4.3.1.public.wco_group 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
group_authorization.group_oid group_authorization_group_oid_fkey
group_member.group_oid fkcgroup_member_group_oid
group_resource_type.group_oid group_resource_type_group_oid_fkey
group_set_member.group_oid group_set_member_group_oid_fkey
resource_type.open_group_oid fkcresource_type_open_group_oid
modified timestamptz 35,6  √  null
deleted bool 1  √  null
origin varchar 2147483647
foreignid varchar 2147483647  √  null
name varchar 2147483647  √  null
description varchar 2147483647  √  null
type wcof_tag 2147483647  √  null
start_date timestamptz 35,6  √  null
end_date timestamptz 35,6  √  null
organization_oid int8 19  √  null
organization.obj_oid fkcwco_group_organization_oid
class_number varchar 2147483647  √  null
period varchar 2147483647  √  null
instructor_oid int8 19  √  null
person.obj_oid fkcwco_group_instructor_oid
teaching_assistant_oid int8 19  √  null
person.obj_oid fkcwco_group_teaching_assistant_oid
auto_authorize bool 1  √  null
facility_oid int8 19  √  null
resource.obj_oid fkcwco_group_facility_oid
address_1 varchar 2147483647  √  null
address_2 varchar 2147483647  √  null
city varchar 2147483647  √  null
state varchar 2147483647  √  null
country varchar 2147483647  √  null
postal_code varchar 2147483647  √  null
phone varchar 2147483647  √  null
email varchar 2147483647  √  null
fax varchar 2147483647  √  null
url varchar 2147483647  √  null
note varchar 2147483647  √  null
account_number varchar 2147483647  √  null
maintenance_contract_number varchar 2147483647  √  null
maintenance_contract_notes varchar 2147483647  √  null
job_numbers varchar 2147483647  √  null
agency_number varchar 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
obj_oid Primary key Asc wco_group_pkey  
origin Performance Asc group_origin_idx  
foreignid Performance Asc wco_group_foreignid_idx  
foreignid Must be unique Asc wco_group_foreignid_key This unique column is also nullable
name Performance Asc wco_group_name_idx  

Close relationships  within of separation: