Table oc312.public.study_event_definition 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_event_definition_id serial 10  √  nextval('study_event_definition_study_event_definition_id_seq'::regclass)
event_definition_crf.study_event_definition_id fk_event_de_reference_study_ev R
study_event.study_event_definition_id fk_study_ev_fk_study__study_ev R
study_id int4 10  √  null
study.study_id fk_study_ev_fk_study__study R
name varchar 2000  √  null
description varchar 2000  √  null
repeating bool 1  √  null
type varchar 20  √  null
category varchar 2000  √  null
owner_id int4 10  √  null
user_account.user_id fk_study_ev_fk_studye_user_acc R
status_id int4 10  √  null
status.status_id fk_study_ev_fk_studye_status R
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
ordinal int4 10  √  null
oc_oid varchar 40

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
study_event_definition_id Primary key Asc pk_study_event_definition
oc_oid Performance Asc i_study_event_definition_oc_oid
status_id Performance Asc i_study_event_definition_status_id
update_id Performance Asc i_study_event_definition_update_id
oc_oid Must be unique Asc uniq_study_event_def_oid

Close relationships  within of separation: