Table webco_4.7.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
modified timestamptz 35,6  √  null
status wcof_tag 2147483647
origin varchar 2147483647
unique_identifier varchar 2147483647
organization_oid int8 19
organization.obj_oid fkcwco_group_organization_oid
name varchar 2147483647  √  null
description varchar 2147483647  √  null
start_date timestamptz 35,6  √  null
end_date timestamptz 35,6  √  null
contact_oid int8 19  √  null
person.obj_oid fkcwco_group_contact_oid
telephone varchar 2147483647  √  null
email varchar 2147483647  √  null
url varchar 2147483647  √  null
role varchar 2147483647  √  null
note varchar 2147483647  √  null
contact_note varchar 2147483647  √  null
created timestamptz 35,6  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc wco_group_pkey
name Performance Asc wco_group_name_idx
origin Performance Asc wco_group_origin_idx
status Performance Asc wco_group_status_idx
unique_identifier Performance Asc wco_group_unique_identifier_idx
unique_identifier Must be unique Asc wco_group_unique_identifier_key

Close relationships  within of separation: