Table oc312.public.subject_group_map Generated by
SchemaSpy
Legend:
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
subject_group_map_id serial 10  √  nextval('subject_group_map_subject_group_map_id_seq'::regclass)
study_group_class_id int4 10  √  null
study_group_class.study_group_class_id fk_subject__fk_subjec_study_gr R
study_subject_id int4 10  √  null
study_subject.study_subject_id fk_subject__subject_g_study_su R
study_group_id int4 10  √  null
study_group.study_group_id fk_subject__fk_subjec_group_ro R
status_id int4 10  √  null
status.status_id fk_subject__fk_subjec_status R
owner_id int4 10  √  null
user_account.user_id fk_subject__fk_sub_gr_user_acc R
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
notes varchar 255  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
subject_group_map_id Primary key Asc pk_subject_group_map
status_id Performance Asc i_subject_group_map_status_id
study_group_class_id Performance Asc i_subject_group_map_study_group_class_id

Close relationships  within of separation: