Table transmart.biomart.bio_asy_data_stats_all 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_assay_data_stats.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_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 Implied Constraint 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 Implied Constraint 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_pk
bio_assay_dataset_id Performance Asc bio_a__d_s_ds_idx
bio_experiment_id Performance Asc bio_a__d_s_exp_idx
feature_group_name Performance Asc bio_a__d_s_f_g_idx

Close relationships  within of separation: