Schema Version: 1.3 Module: chado

biomaterial


Description

A biomaterial represents the MAGE concept of BioSource, BioSample, and LabeledExtract. It is essentially some biological material (tissue, cells, serum) that may have been processed. Processed biomaterials should be traceable back to raw biomaterials via the biomaterialrelationship table.

Columns

Column Type Size Foreign Key Nullable Default Comments
biomaterial_id bigserial 19
nextval('mage.biomaterial_biomaterial_id_seq'::regclass)
taxon_id int8 19
organism.organism_id biomaterial_taxon_id_fkey N
√ null
biosourceprovider_id int8 19
contact.contact_id biomaterial_biosourceprovider_id_fkey N
√ null
dbxref_id int8 19
dbxref.dbxref_id biomaterial_dbxref_id_fkey N
√ null
name text 2147483647
√ null
description text 2147483647
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
biomaterial_pkey Primary key Asc biomaterial_id
biomaterial_c1 Must be unique Asc name
biomaterial_idx1 Performance Asc taxon_id
biomaterial_idx2 Performance Asc biosourceprovider_id
biomaterial_idx3 Performance Asc dbxref_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the biomaterial table.

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation