Table transmart.biomart.bio_assay_analysis_data 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_asy_analysis_data_id int8 19
bio_assay_analysis_data_tea.bio_asy_analysis_data_id Implied Constraint R
fold_change_ratio int8 19  √  null
raw_pvalue float8 17,17  √  null
adjusted_pvalue float8 17,17  √  null
r_value float8 17,17  √  null
rho_value float8 17,17  √  null
bio_assay_analysis_id int8 19
bio_assay_analysis.bio_assay_analysis_id bio_assay_analysis_data_n_fk1 R
adjusted_p_value_code varchar 100  √  null
feature_group_name varchar 100
bio_experiment_id int8 19  √  null
bio_experiment.bio_experiment_id bio_assay_analysis_data_n_fk2 R
bio_assay_platform_id int8 19  √  null
bio_assay_platform.bio_assay_platform_id bio_assay_analysis_data_n_fk3 R
etl_id varchar 100  √  null
preferred_pvalue float8 17,17  √  null
cut_value float8 17,17  √  null
results_value varchar 100  √  null
numeric_value float8 17,17  √  null
numeric_value_code varchar 50  √  null
tea_normalized_pvalue float8 17,17  √  null
bio_assay_feature_group_id int8 19  √  null
bio_assay_feature_group.bio_assay_feature_group_id bio_asy_ad_fg_fk R
probeset_id int8 19  √  null
lsmean1 float8 17,17  √  null
lsmean2 float8 17,17  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
feature_group_name Performance Asc baad_fgn_idx
bio_assay_feature_group_id + bio_experiment_id Performance Asc/Asc baad_idx1
bio_experiment_id + bio_assay_analysis_id + bio_asy_analysis_data_id Performance Asc/Asc/Asc baad_idx11
bio_experiment_id + bio_assay_analysis_id + bio_assay_feature_group_id Performance Asc/Asc/Asc baad_idx12
bio_assay_feature_group_id + bio_asy_analysis_data_id Performance Asc/Asc baad_idx14
bio_assay_platform_id Performance Asc baad_idx4
bio_experiment_id + bio_assay_analysis_id Performance Asc/Asc baad_idx6
bio_assay_analysis_id + bio_asy_analysis_data_id Performance Asc/Asc baad_idx7
bio_assay_analysis_id + bio_assay_feature_group_id Performance Asc/Asc bad_idx13
bio_asy_analysis_data_id Must be unique Asc pk_baad

Close relationships  within of separation: