Table oc312.public.dataset 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
dataset_id serial 10  √  nextval('dataset_dataset_id_seq'::regclass)
archived_dataset_file.dataset_id fk_archived_reference_dataset R
dataset_crf_version_map.dataset_id fk_dataset_crf_ref_dataset R
dataset_filter_map.dataset_id fk_dataset_reference_dataset R
dataset_study_group_class_map.dataset_id fk_dataset_study_ref_dataset R
study_id int4 10  √  null
study.study_id fk_dataset_fk_datase_study R
status_id int4 10  √  null
status.status_id fk_dataset_fk_datase_status R
name varchar 255  √  null
description varchar 2000  √  null
sql_statement text 2147483647  √  null
num_runs int4 10  √  null
date_start date 13  √  null
date_end date 13  √  null
date_created date 13  √  null
date_updated date 13  √  null
date_last_run date 13  √  null
owner_id int4 10  √  null
user_account.user_id fk_dataset_fk_datase_user_acc R
approver_id int4 10  √  null
update_id int4 10  √  null
show_event_location bool 1  √  false
show_event_start bool 1  √  false
show_event_end bool 1  √  false
show_subject_dob bool 1  √  false
show_subject_gender bool 1  √  false
show_event_status bool 1  √  false
show_subject_status bool 1  √  false
show_subject_unique_id bool 1  √  false
show_subject_age_at_event bool 1  √  false
show_crf_status bool 1  √  false
show_crf_version bool 1  √  false
show_crf_int_name bool 1  √  false
show_crf_int_date bool 1  √  false
show_group_info bool 1  √  false
show_disc_info bool 1  √  false
odm_metadataversion_name varchar 255  √  null
odm_metadataversion_oid varchar 255  √  null
odm_prior_study_oid varchar 255  √  null
odm_prior_metadataversion_oid varchar 255  √  null
show_secondary_id bool 1  √  false
dataset_item_status_id int4 10  √  null
dataset_item_status.dataset_item_status_id dataset_fk_dataset_item_status R

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
dataset_id Primary key Asc pk_dataset
status_id Performance Asc i_dataset_status_id

Close relationships  within of separation: