Table clean.public.event_definition_crf Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
event_definition_crf_id serial 10  √  nextval('event_definition_crf_event_definition_crf_id_seq'::regclass)
dataset_crf_version_map
study_event_definition_id int4 10  √  null
study_event_definition
study_id int4 10  √  null
study
crf_id int4 10  √  null
crf
required_crf bool 1  √  null
double_entry bool 1  √  null
require_all_text_filled bool 1  √  null
decision_conditions bool 1  √  null
null_values varchar 255  √  null
default_version_id int4 10  √  null
crf_version
status_id int4 10  √  null
status
owner_id int4 10  √  null
user_account
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
ordinal int4 10  √  null
electronic_signature bool 1  √  false
hide_crf bool 1  √  false
source_data_verification_code int4 10  √  null
selected_version_ids varchar 150  √  null
parent_id int4 10  √  null

Table contained 0 rows at Wed Feb 01 09:18 EST 2012

Indexes:
Column(s) Type Sort
event_definition_crf_id Primary key Asc
crf_id Performance Asc
default_version_id Performance Asc
electronic_signature Performance Asc
ordinal Performance Asc
status_id Performance Asc
study_id Performance Asc

Close relationships  within of separation: