| Table pub.mgd.voc_evidence A record in this table represents one evidence statement which supports one Annotation. There can be one or more Evidence records per Annotation. Although the schema supports zero or more Evidence records per Annotation, editorially at least one Evidence record is required per Annotation.
|
Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 3,102,651 rows at Tue Nov 11 10:12 EST 2025 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| _annotevidence_key | Primary key, Used to cluster data | Asc | voc_evidence_pkey |
| _annot_key | Performance | Asc | voc_evidence_idx_clustered |
| _createdby_key | Performance | Asc | voc_evidence_idx_createdby_key |
| creation_date | Performance | Asc | voc_evidence_idx_creation_date |
| _evidenceterm_key | Performance | Asc | voc_evidence_idx_evidenceterm_key |
| modification_date | Performance | Asc | voc_evidence_idx_modification_date |
| _modifiedby_key | Performance | Asc | voc_evidence_idx_modifiedby_key |
| _refs_key | Performance | Asc | voc_evidence_idx_refs_key |
|