biosource


Columns

Column Type Size Nulls Auto Default Children Parents Comments
biosource_id uuid 2147483647 gen_random_uuid()
biosample.biosource_id biosample_biosource_id_fkey R
biosample_data_source.biosource_id Implied Constraint R
biosource_data_source.biosource_id Implied Constraint R
sex sex_type 2147483647 null
age_unit age_unit_type 2147483647 √ null
data_source_id uuid 2147483647 √ null
data_source.data_source_id biosource_data_source_id_fkey R
age numrange 2147483647 √ null
alternative_data_source_id uuid 2147483647 √ null
data_source.data_source_id biosource_alternative_data_source_id_fkey R
life_stage_id uuid 2147483647 √ null
life_stage.life_stage_id biosource_life_stage_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
biosource_pkey Primary key Asc biosource_id
ix_biosource_alternative_data_source_id Performance Asc alternative_data_source_id
ix_biosource_data_source_id Performance Asc data_source_id
ix_biosource_life_stage_id Performance Asc life_stage_id

Relationships

Close relationships within degrees of separation