Table pub.mgd.mgi_organism_mgitype A record in this table represents the relationship between an Organism and a MGI Type; what Organisms are valid for a given MGI Type. An Organism can be associated with one or more MGI Types. This enables us to generate a list of Organisms by MGI Type. Examples are Orthology, Molecular Segment , GXD Antigen, GXD Antibody, Sequence, Marker.
|
Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 198 rows at Mon Sep 28 09:47 EDT 2020 |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
_organism_key + _mgitype_key | Primary key | Asc/Asc | mgi_organism_mgitype_pkey |
_createdby_key | Performance | Asc | mgi_organism_mgitype_idx_createdby_key |
_mgitype_key | Performance | Asc | mgi_organism_mgitype_idx_mgitype_key |
_modifiedby_key | Performance | Asc | mgi_organism_mgitype_idx_modifiedby_key |
![]() ![]() ![]() |