run


Columns

Column Type Size Nulls Auto Default Children Parents Comments
run_id uuid 2147483647 gen_random_uuid()
barcode_file.run_id barcode_file_run_id_fkey R
read_file.run_id read_file_run_id_fkey R
read_file_data_source.run_id Implied Constraint R
read_file_metadata.run_id Implied Constraint R
run_accession.run_id Implied Constraint R
run_alignment_task.run_id run_alignment_task_run_id_fkey R
read_length int4 10 null
read_file_set_id uuid 2147483647 √ null
read_file_set.read_file_set_id run_read_file_set_id_fkey R
data_source_id uuid 2147483647 √ null
data_source.data_source_id run_data_source_id_fkey R
read_count int4 10 null
technical_replicate int4 10 null
run_type run_type 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
run_pkey Primary key Asc run_id
ix_run_data_source_id Performance Asc data_source_id
ix_run_read_file_set_id Performance Asc read_file_set_id
uq_run_read_file_set_id_technical_replicate Must be unique Asc/Asc read_file_set_id + technical_replicate

Relationships

Close relationships within degrees of separation