Table oc312.public.crf_version 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
crf_version_id serial 10  √  nextval('crf_version_crf_version_id_seq'::regclass)
decision_condition.crf_version_id fk_decision_fk_decisi_crf_vers R
event_crf.crf_version_id fk_subject_referenc_instrument R
event_definition_crf.default_version_id fk_versioning_study_inst N
filter_crf_version_map.crf_version_id fk_filter_c_reference_crf_vers R
item_group_metadata.crf_version_id fk_crf_metadata R
section.crf_version_id fk_section_version R
versioning_map.crf_version_id fk_versioni_fk_versio_crf_vers R
crf_id int4 10
crf.crf_id fk_versioni_reference_instrume R
name varchar 255  √  null
description varchar 4000  √  null
revision_notes varchar 255  √  null
status_id int4 10  √  null
status.status_id fk_crf_vers_fk_crf_ve_status R
date_created date 13  √  null
date_updated date 13  √  null
owner_id int4 10  √  null
user_account.user_id fk_crf_vers_crf_versi_user_acc R
update_id int4 10  √  null
oc_oid varchar 40

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
crf_version_id Primary key Asc pk_crf_version
name Performance Asc i_crf_version_name
oc_oid Performance Asc i_crf_version_oc_oid
status_id Performance Asc i_crf_version_status_id
oc_oid Must be unique Asc uniq_crf_version_oc_oid

Close relationships  within of separation: