Table transmart.biomart.bio_assay_data_stats 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_assay_data_stats_id int8 19
bio_asy_data_stats_all.bio_assay_data_stats_id Implied Constraint R
bio_sample_count int8 19  √  null
quartile_1 float8 17,17  √  null
quartile_2 float8 17,17  √  null
quartile_3 float8 17,17  √  null
max_value float8 17,17  √  null
min_value float8 17,17  √  null
bio_sample_id int8 19  √  null
bio_sample.bio_sample_id bio_asy_dt_stats_smp_s_fk R
feature_group_name varchar 120  √  null
value_normalize_method varchar 50  √  null
bio_experiment_id int8 19  √  null
bio_experiment.bio_experiment_id bio_asy_dt_stat_exp_s_fk R
mean_value float8 17,17  √  null
std_dev_value float8 17,17  √  null
bio_assay_dataset_id int8 19  √  null
bio_assay_dataset.bio_assay_dataset_id bio_asy_dt_stats_ds_s_fk R
bio_assay_feature_group_id int8 19
bio_assay_feature_group.bio_assay_feature_group_id bio_asy_dt_fg_fk R

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

Indexes:
Column(s) Type Sort Constraint Name
bio_assay_data_stats_id Primary key Asc bio_asy_dt_stats_s_pk
bio_assay_dataset_id Performance Asc bio_a_d_s_ds__s_idx
bio_experiment_id Performance Asc bio_a_d_s_exp__s_idx
feature_group_name + bio_assay_data_stats_id Performance Asc/Asc bio_a_d_s_f_g_s_idx
bio_assay_feature_group_id + bio_assay_data_stats_id Performance Asc/Asc bio_a_d_s_fgi_s_idx

Close relationships  within of separation: