Table transmart.biomart.bio_assay_analysis_data_tea 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
assay_analysis_data.bio_asy_analysis_data_id Implied Constraint R
bio_assay_analysis_data.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_t_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_t_fk2 R
bio_assay_platform_id int8 19  √  null
bio_assay_platform.bio_assay_platform_id bio_assay_analysis_data_t_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_experiment_type varchar 50  √  null
bio_assay_feature_group_id int8 19  √  null
bio_assay_feature_group.bio_assay_feature_group_id bio_asy_ad_tea_fg_fk R
tea_rank int8 19  √  null
probeset_id int8 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_asy_analysis_data_id Primary key Asc bio_aa_data_t_pk
bio_assay_analysis_id + bio_asy_analysis_data_id Performance Asc/Asc baad_idx_tea_analysis
bio_experiment_id + bio_assay_analysis_id Performance Asc/Asc baad_idx_tea_exp_analysis
bio_experiment_id + bio_assay_analysis_id + bio_asy_analysis_data_id Performance Asc/Asc/Asc baad_idx_tea_exp_analysis1
bio_assay_feature_group_id + bio_experiment_id Performance Asc/Asc baad_idx_tea_fg_experiment
bio_assay_feature_group_id + bio_asy_analysis_data_id Performance Asc/Asc baad_idx_tea_probe_id
feature_group_name + bio_asy_analysis_data_id Performance Asc/Asc baad_idx_tea_probe_name
bio_assay_analysis_id + tea_rank Performance Asc/Asc baad_idx_tea_rank
bio_assay_analysis_id + tea_rank Performance Asc/Asc baadt_idx17
bio_assay_analysis_id + bio_asy_analysis_data_id Performance Asc/Asc baadt_idx7
bio_experiment_type + bio_asy_analysis_data_id Performance Asc/Asc idx_baad_idx_tea_experiment_type
bio_assay_feature_group_id + bio_assay_analysis_id Performance Asc/Asc idx_baad_idx_tea_probe_analysis
bio_assay_feature_group_id + bio_assay_analysis_id Performance Asc/Asc idx_baadt_fg_ad
bio_experiment_type + bio_asy_analysis_data_id Performance Asc/Asc idx_baadt_idx10

Close relationships  within of separation: