Table oc312.public.study_group_class 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
study_group_class_id serial 10  √  nextval('study_group_class_study_group_class_id_seq'::regclass)
dataset_study_group_class_map.study_group_class_id fk_dataset_ref_study_grp_class R
study_group.study_group_class_id fk_group_class_study_group N
subject_group_map.study_group_class_id fk_subject__fk_subjec_study_gr R
name varchar 30  √  null
study_id int4 10  √  null
owner_id int4 10  √  null
user_account.user_id fk_study_gr_fk_study__user_acc R
date_created date 13  √  null
group_class_type_id int4 10  √  null
group_class_types.group_class_type_id fk_study_gr_fk_study__group_ty R
status_id int4 10  √  null
status.status_id fk_study_gr_fk_study__status R
date_updated date 13  √  null
update_id int4 10  √  null
subject_assignment varchar 30  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
study_group_class_id Primary key Asc pk_study_group_class
status_id Performance Asc i_study_group_class_status_id
study_id Performance Asc i_study_group_class_study_id

Close relationships  within of separation: