Table webco_3.9.1.public.group_member 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
origin varchar 2147483647  √  null
modified timestamp 29,6  √  null
group_oid int8 19
group_authorization.group_oid authorization_group_fkeys
wco_group.obj_oid fkcgroup_member_group_oid
person_oid int8 19
group_authorization.person_oid authorization_group_fkeys
person.obj_oid fkcgroup_member_person_oid
expire timestamp 29,6  √  null

Table contained 0 rows at Tue Feb 04 14:58 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc group_member_pkey
expire Performance Asc group_member_expire_idx
group_oid Performance Asc group_member_group_idx
origin Performance Asc group_member_origin_idx
person_oid Performance Asc group_member_person_idx
group_oid + person_oid Must be unique Asc/Asc unique_membership

Close relationships  within of separation: