Table transmart.biomart.bio_experiment Generated by
SchemaSpy
Legend: SourceForge.net
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
bio_experiment_id int8 19
assay_analysis_data.bio_experiment_id Implied Constraint R
bio_assay.experiment_id dataset_experiment_fk R
bio_assay_analysis_data.bio_experiment_id bio_assay_analysis_data_n_fk2 R
bio_assay_analysis_data_tea.bio_experiment_id bio_assay_analysis_data_t_fk2 R
bio_assay_data.bio_experiment_id bio_asy_exp_fk R
bio_assay_data_stats.bio_experiment_id bio_asy_dt_stat_exp_s_fk R
bio_assay_dataset.bio_experiment_id bio_dataset_experiment_fk R
bio_asy_data_stats_all.bio_experiment_id Implied Constraint R
bio_clinical_trial.bio_experiment_id bio_clinical_trial_bio_experim R
bio_marker_exp_analysis_mv.bio_experiment_id Implied Constraint R
bio_marker_exp_analysis_mv_10.bio_experiment_id Implied Constraint R
bio_stats_exp_marker.bio_experiment_id Implied Constraint R
gse_analysis.bio_experiment_id Implied Constraint R
study.bio_experiment_id study_bio_experiment_id_fk R
tmp_omicsoft_compound.bio_experiment_id Implied Constraint R
bio_experiment_type varchar 200  √  null
title varchar 1000  √  null
description varchar 4000  √  null
design varchar 2000  √  null
start_date timestamp 29,6  √  null
completion_date timestamp 29,6  √  null
primary_investigator varchar 400  √  null
contact_field varchar 400  √  null
etl_id varchar 100  √  null
status varchar 100  √  null
overall_design varchar 2000  √  null
accession varchar 100  √  null
entrydt timestamp 29,6  √  null
updated timestamp 29,6  √  null
institution varchar 400  √  null
country varchar 1000  √  null
biomarker_type varchar 255  √  null
target varchar 255  √  null
access_type varchar 100  √  null

Table contained 0 rows at Wed Jun 26 00:10 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
bio_experiment_id Primary key Asc experimentdim_pk
accession Performance Asc bio_exp_acen_idx
bio_experiment_type Performance Asc bio_exp_type_idx
bio_experiment_id Must be unique Asc bio_experiment_pk

Close relationships  within of separation: