biosource_data_source

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

biosource_id

uuid

2147483647

√

null

biosource.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

Implied Constraint

R

age

numrange

2147483647

√

null

alternative_data_source_id

uuid

2147483647

√

null

data_source.data_source_id

Implied Constraint

R

life_stage_id

uuid

2147483647

√

null

life_stage.life_stage_id

Implied Constraint

R

biosource_accession

text

2147483647

√

null

biosource_alternative_accession

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

WITH biosource_ds AS (
         SELECT biosource_1.biosource_id,
            data_source.accession AS biosource_accession
           FROM (biosource biosource_1
             LEFT JOIN data_source ON ((biosource_1.data_source_id = data_source.data_source_id)))
        ), biosource_alternative_ds AS (
         SELECT biosource_1.biosource_id,
            data_source.accession AS biosource_alternative_accession
           FROM (biosource biosource_1
             LEFT JOIN data_source ON ((biosource_1.alternative_data_source_id = data_source.data_source_id)))
        )
 SELECT biosource.biosource_id,
    biosource.sex,
    biosource.age_unit,
    biosource.data_source_id,
    biosource.age,
    biosource.alternative_data_source_id,
    biosource.life_stage_id,
    biosource_ds.biosource_accession,
    biosource_alternative_ds.biosource_alternative_accession
   FROM ((biosource
     LEFT JOIN biosource_ds ON ((biosource.biosource_id = biosource_ds.biosource_id)))
     LEFT JOIN biosource_alternative_ds ON ((biosource.biosource_id = biosource_alternative_ds.biosource_id)));

biosource_data_source

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views