Table pub.mgd.mrk_marker A record in this table represents a Marker (gene, dna segment, complex/cluster). Mouse Markers have MGI Accession IDs. Non-mouse Markers (human, rat, etc.) are also stored in this table.
|
Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 1,156,379 rows at Mon Apr 25 09:05 EDT 2022 |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
_marker_key | Primary key | Asc | mrk_marker_pkey |
_marker_key + _organism_key | Must be unique | Asc/Asc | mrk_marker_idx_marker_key |
chromosome | Performance | Asc | mrk_marker_idx_clustered |
_createdby_key | Performance | Asc | mrk_marker_idx_createdby_key |
_marker_status_key | Performance | Asc | mrk_marker_idx_marker_status_key |
_marker_type_key + _marker_key | Performance | Asc/Asc | mrk_marker_idx_marker_type_key |
_modifiedby_key | Performance | Asc | mrk_marker_idx_modifiedby_key |
_organism_key | Performance | Asc | mrk_marker_idx_organism_key |
symbol | Performance | Asc | mrk_marker_idx_symbol |
![]() ![]() ![]() |