Table oc312.public.study 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_id serial 10  √  nextval('study_study_id_seq'::regclass)
crf.source_study_id fk_source_study_id R
dataset.study_id fk_dataset_fk_datase_study R
discrepancy_note.study_id discrepancy_note_study_id_fkey R
event_definition_crf.study_id fk_study_reference_instrument R
study.parent_study_id project_is_contained_within_pa N
study_event_definition.study_id fk_study_ev_fk_study__study R
study_module_status.study_id fk_study_module_study_id R
study_parameter_value.study_id study_param_value_study_id_fk R
study_subject.study_id fk_project__reference_study2 R
study_user_role.study_id fk_person_role_study_id R
parent_study_id int4 10  √  null
study.study_id project_is_contained_within_pa N
unique_identifier varchar 30  √  null
secondary_identifier varchar 255  √  null
name varchar 255  √  null
summary varchar 255  √  null
date_planned_start date 13  √  null
date_planned_end date 13  √  null
date_created date 13  √  null
date_updated date 13  √  null
owner_id int4 10  √  null
user_account.user_id fk_study_fk_study__user_acc R
update_id int4 10  √  null
type_id int4 10  √  null
study_type.study_type_id fk_study_type R
status_id int4 10  √  null
status.status_id fk_study_fk_study__status R
principal_investigator varchar 255  √  null
facility_name varchar 255  √  null
facility_city varchar 255  √  null
facility_state varchar 20  √  null
facility_zip varchar 64  √  null
facility_country varchar 64  √  null
facility_recruitment_status varchar 60  √  null
facility_contact_name varchar 255  √  null
facility_contact_degree varchar 255  √  null
facility_contact_phone varchar 255  √  null
facility_contact_email varchar 255  √  null
protocol_type varchar 30  √  null
protocol_description varchar 1000  √  null
protocol_date_verification date 13  √  null
phase varchar 30  √  null
expected_total_enrollment int4 10  √  null
sponsor varchar 255  √  null
collaborators varchar 1000  √  null
medline_identifier varchar 255  √  null
url varchar 255  √  null
url_description varchar 255  √  null
conditions varchar 500  √  null
keywords varchar 255  √  null
eligibility varchar 500  √  null
gender varchar 30  √  null
age_max varchar 3  √  null
age_min varchar 3  √  null
healthy_volunteer_accepted bool 1  √  null
purpose varchar 64  √  null
allocation varchar 64  √  null
masking varchar 30  √  null
control varchar 30  √  null
assignment varchar 30  √  null
endpoint varchar 64  √  null
interventions varchar 1000  √  null
duration varchar 30  √  null
selection varchar 30  √  null
timing varchar 30  √  null
official_title varchar 255  √  null
results_reference bool 1  √  null
oc_oid varchar 40
old_status_id int4 10  √  1
status.status_id fk_old_status_id R

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
study_id Primary key Asc pk_study
oc_oid Performance Asc i_study_oc_oid
owner_id Performance Asc i_study_owner_id
parent_study_id Performance Asc i_study_parent_study_id
status_id Performance Asc i_study_status_id
type_id Performance Asc i_study_type_id
name Performance Asc i_study_unique_identifier
oc_oid Must be unique Asc uniq_study_oid

Close relationships  within of separation: