assembly


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ensembl_accession varchar 2147483647 √ null
assembly_id uuid 2147483647 gen_random_uuid()
alignment_file.assembly_id alignment_file_assembly_id_fkey R
analysis_file.assembly_id analysis_file_assembly_id_fkey R
base_epigenomes_replicates_and_files.assembly_id Implied Constraint R
curated_experiment_analysis_files.assembly_id Implied Constraint R
curated_experiment_metadata.assembly_id Implied Constraint R
curated_open_chromatin_assay_metadata.assembly_id Implied Constraint R
experiment_metadata.assembly_id Implied Constraint R
mask_file.assembly_id mask_file_assembly_id_fkey R
file_id uuid 2147483647 null
file.file_id assembly_file_id_fkey R
species_id uuid 2147483647 null
species.species_id assembly_species_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
assembly_pkey Primary key Asc assembly_id
assembly_ensembl_accession_key Must be unique Asc ensembl_accession
ix_assembly_file_id Performance Asc file_id
ix_assembly_species_id Performance Asc species_id

Relationships

Close relationships within degrees of separation