Tables


SchemaSpy Analysis of rdr.public

Generated on Wed Nov 11 16:43 UTC 2026

XML Representation
Insertion Order Deletion Order
TABLES 41
VIEWS 34
COLUMNS 683
Constraints 69
Anomalies 1
Routines 11

Database Properties

Database Type: PostgreSQL - 14.24 (Debian 14.24-1.pgdg13+2)

Schema public

standard public schema

Tables

Table / View Children Parents Columns Type Comments
assembly 8 2 4 Table
run_alignment_task 0 2 2 Table
bucket 1 0 3 Table
species 10 0 2 Table
biosource 3 3 7 Table
data_source 35 1 8 Table
analysis_file 0 3 7 Table
alembic_version 0 0 1 Table
alignment_task 2 0 2 Table
dnase_seq 0 2 2 Table
biosample_set_biosample 0 2 2 Table
mask_file 0 2 3 Table
s3_object 0 2 4 Table
biosample 4 5 24 Table
archive 1 0 4 Table
chip_seq 0 5 7 Table
posix_file 0 1 3 Table
replicate_set 24 1 2 Table
inclusion_list 0 1 3 Table
histone_target 1 0 3 Table
file 12 1 9 Table
quality_annotation 0 0 5 Table
rna_seq 0 2 3 Table
biosample_set 6 1 3 Table
life_stage 7 1 4 Table
atac_seq 0 2 3 Table
run 6 2 7 Table
replicate 3 4 5 Table
experiment 6 2 5 Table
metadata_override 0 0 4 Table
track 0 1 3 Table
barcode_file 0 3 4 Table
multiome 0 3 4 Table
alignment_file 0 4 5 Table
read_file 0 4 11 Table
tf_target 1 0 3 Table
public_url 0 1 3 Table
ontology 8 0 3 Table
epigenome 21 4 7 Table
read_file_set 9 1 2 Table
epigenome_group 7 1 3 Table
replicate_data_source 0 5 6 View
experiment_signal_and_control_data_source 0 5 17 View
experiment_target_info 0 3 9 View
base_epigenome_replicates 0 1 21 View
analysis_file_experiment_info 0 5 23 View
base_epigenomes_flat_payload 0 0 1 View
biosample_biological_group 0 1 2 View
curated_experiment_analysis_files 0 1 7 View
experiment_control_data_source 0 3 10 View
base_epigenomes_payload 0 0 1 View
curated_open_chromatin_assay_metadata 0 3 24 View
life_stage_with_ontology 0 2 6 View
epigenome_data_source 0 4 7 View
biosample_sample_type 0 1 2 View
biosample_data_source 0 6 26 View
replicate_set_data_source 0 2 3 View
experiment_signal_data_source 0 3 10 View
run_accession 0 3 8 View
base_epigenomes_replicates_and_files 0 2 31 View
experiment_signal_target_info 0 3 9 View
read_file_data_source 0 4 12 View
metadata_dimensions 0 0 1 View
biosample_set_data_source 0 2 4 View
open_chromatin_base_epigenome 0 0 20 View
biosample_term_group 0 1 2 View
experiment_control_target_info 0 3 9 View
base_epigenomes 0 0 20 View
experiment_data_source 0 3 10 View
library_data_source 0 2 3 View
curated_experiment_metadata 0 3 24 View
biosource_data_source 0 4 9 View
read_file_metadata 0 14 73 View
analysis_file_info_with_checks 0 5 25 View
experiment_metadata 0 12 59 View