Table dvnDb.public.usergroup 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
id serial 10  √  nextval('usergroup_id_seq'::regclass)
loginaffiliate.usergroup_id fk_loginaffiliate_usergroup_id R
logindomain.usergroup_id fk_logindomain_usergroup_id R
study_usergroup.allowedgroups_id fk_study_usergroup_allowedgroups_id R
studyfile_usergroup.allowedgroups_id fk_studyfile_usergroup_allowedgroups_id R
vdc_fileusergroup.allowedfilegroups_id fk_vdc_fileusergroup_allowedfilegroups_id R
vdc_usergroup.allowedgroups_id fk_vdc_usergroup_allowedgroups_id R
vdcuser_usergroup.usergroups_id fk_vdcuser_usergroup_usergroups_id R
description varchar 255  √  null
friendlyname varchar 255  √  null
name varchar 255  √  null
pinservice varchar 255  √  null
version int8 19  √  null

Table contained 0 rows at Fri May 30 15:33 MDT 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc usergroup_pkey

Close relationships  within of separation: