Table oc312.public.crf 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_id serial 10  √  nextval('crf_crf_id_seq'::regclass)
crf_version.crf_id fk_versioni_reference_instrume R
event_definition_crf.crf_id fk_study_inst_reference R
item_group.crf_id fk_item_group_crf R
status_id int4 10  √  null
status.status_id fk_crf_fk_crf_fk_status R
name varchar 255  √  null
description varchar 2048  √  null
owner_id int4 10  √  null
user_account.user_id fk_crf_crf_user_user_acc R
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
oc_oid varchar 40
source_study_id int4 10  √  null
study.study_id fk_source_study_id R

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
crf_id Primary key Asc pk_crf
name Performance Asc i_crf_name
oc_oid Performance Asc i_crf_oc_oid
owner_id Performance Asc i_crf_owner_id
status_id Performance Asc i_crf_status_id
oc_oid Must be unique Asc uniq_crf_oc_oid

Close relationships  within of separation: