TABLES
8
VIEWS
0
COLUMNS
39
Constraints
17
chado.organism Tables
| Table / View | Referenced | Foreign Keys | Columns | Type | Comments |
|---|---|---|---|---|---|
| organism | 14 | 1 | 8 | Table | The organismal taxonomic classification. Note that phylogenies are represented using the phylogeny module, and taxonomies can be represented using the cvterm module or the phylogeny module. |
| organism_cvterm | 1 | 3 | 5 | Table | organism to cvterm associations. Examples: taxonomic name |
| organism_cvtermprop | 0 | 2 | 5 | Table | Extensible properties for organism to cvterm associations. Examples: qualifiers |
| organism_dbxref | 0 | 2 | 3 | Table | Links an organism to a dbxref. |
| organism_pub | 0 | 2 | 3 | Table | Attribution for organism. |
| organism_relationship | 0 | 3 | 5 | Table | Specifies relationships between organisms that are not taxonomic. For example, in breeding, relationships such as "sterile_with", "incompatible_with", or "fertile_with" would be appropriate. Taxonomic relatinoships should be housed in the phylogeny tables. |
| organismprop | 1 | 2 | 5 | Table | Tag-value properties - follows standard chado model. |
| organismprop_pub | 0 | 2 | 5 | Table | Attribution for organismprop. |