Table pub.mgd.mgi_keyvalue A record in this table represents ordered key-value pairs (strings), associated with an object of a specific MGI Type.
|
Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 28,913,433 rows at Mon Sep 11 06:12 EDT 2023 |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
_keyvalue_key | Primary key, Used to cluster data | Asc | mgi_keyvalue_pkey |
_createdby_key | Performance | Asc | mgi_keyvalue_idx_createdby_key |
key | Performance | Asc | mgi_keyvalue_idx_key |
_mgitype_key | Performance | Asc | mgi_keyvalue_idx_mgitype_key |
_modifiedby_key | Performance | Asc | mgi_keyvalue_idx_modifiedby_key |
_object_key | Performance | Asc | mgi_keyvalue_idx_object_key |
_object_key + sequencenum | Performance | Asc/Asc | mgi_keyvalue_idx_objectkeysequencenum |
|