biosample


Columns

Column Type Size Nulls Auto Default Children Parents Comments
biosample_id uuid 2147483647 gen_random_uuid()
biosample_data_source.biosample_id Implied Constraint R
biosample_set_biosample.biosample_id biosample_set_biosample_biosample_id_fkey R
experiment_metadata.biosample_id Implied Constraint R
read_file_metadata.biosample_id Implied Constraint R
biomaterial_type biomaterial_type 2147483647 null
term text 2147483647 null
data_source_id uuid 2147483647 null
data_source.data_source_id biosample_data_source_id_fkey R
ontology_id uuid 2147483647 √ null
ontology.ontology_id biosample_ontology_id_fkey R
biosource_id uuid 2147483647 null
biosource.biosource_id biosample_biosource_id_fkey R
treatments text 2147483647 √ null
perturbed bool 1 √ null
disease_term_id text 2147483647 √ null
disease_term_name text 2147483647 √ null
health_status text 2147483647 √ null
genetic_modifications text 2147483647 √ null
alternative_data_source_id uuid 2147483647 √ null
data_source.data_source_id biosample_alternative_data_source_id_fkey R
organ_slims _text 2147483647 √ null
cell_slims _text 2147483647 √ null
developmental_slims _text 2147483647 √ null
system_slims _text 2147483647 √ null
synonyms _text 2147483647 √ null
age_at_collection numrange 2147483647 √ null
age_at_collection_unit age_unit_type 2147483647 √ null
time_post_fertilisation numeric 0 √ null
time_post_fertilisation_unit time_post_fertilisation_unit_type 2147483647 √ null
thermal_time numeric 0 √ null
life_stage_id uuid 2147483647 √ null
life_stage.life_stage_id biosample_life_stage_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
biosample_pkey Primary key Asc biosample_id
ix_biosample_alternative_data_source_id Performance Asc alternative_data_source_id
ix_biosample_biosource_id Performance Asc biosource_id
ix_biosample_data_source_id Performance Asc data_source_id
ix_biosample_life_stage_id Performance Asc life_stage_id
ix_biosample_ontology_id Performance Asc ontology_id

Relationships

Close relationships within degrees of separation