Relationships
Data license: MIT · Data source: jebboone/deitydb
- subject_entity_id
- {'description': 'The entity initiating or holding the relationship'}
- relationship_type
- {'description': 'Typed relationship from the controlled vocabulary (see relationship_types table)'}
- object_entity_id
- {'description': 'The entity receiving or targeted by the relationship'}
- confidence
- {'description': 'high / medium / low / speculative'}
- rationale
- {'description': 'Scholarly justification for the relationship, with source citations'}
- source_id
- {'description': 'Primary source justifying this relationship'}
- period_id
- {'description': 'Historical period in which this relationship is attested (null = all periods)'}
3 rows where object_entity_id = "ENT_MNEMOSYNE"
This data as json, CSV (advanced)
Suggested facets: relationship_type, confidence, rationale, source_id, review_status
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1663 | Uranus ENT_URANUS | parent_of | Mnemosyne ENT_MNEMOSYNE | high | Hesiod Theogony 132-138. | Hesiod, Theogony and Works and Days SRC_HESIOD_THEOGONY | approved | |
| 1674 | Gaia ENT_GAIA | parent_of | Mnemosyne ENT_MNEMOSYNE | high | Hesiod Theogony 132-138. | Hesiod, Theogony and Works and Days SRC_HESIOD_THEOGONY | approved | |
| 2467 | Carmenta ENT_ITA_CARMENTA | reception_of | Mnemosyne ENT_MNEMOSYNE | low | The Camenae — the archaic Latin prophetic water-nymphs of whom Carmenta is the most prominent — were explicitly identified with the Muses (daughters of Mnemosyne) by Livius Andronicus in his translation of Homer's Odyssey (c. 240 BCE), where he renders 'Mousa' as 'Camena.' This makes Carmenta, as chief Camena, a Latin reception/equivalent of the Muse tradition that derives from Mnemosyne (Memory). Confidence low: the identification is of the Camenae-as-class with the Muses-as-class, not a specific Carmenta-Mnemosyne equation. Cicero, Acad. 1.3; Livius Andronicus, Odusia fr. 1 Warmington. | Varro, Antiquitates Rerum Divinarum (c. 47 BCE, surviving via Augustine City of God) SRC_VARRO_ANTIQ | reviewed | Archaic Italic (c. 900–509 BCE) PER_ITA_ARCHAIC |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "entity_relationships" (
[relationship_id] INTEGER PRIMARY KEY,
[subject_entity_id] TEXT REFERENCES [entities]([entity_id]),
[relationship_type] TEXT REFERENCES [relationship_types]([relationship_type]),
[object_entity_id] TEXT REFERENCES [entities]([entity_id]),
[confidence] TEXT,
[rationale] TEXT,
[source_id] TEXT REFERENCES [sources]([source_id]),
[review_status] TEXT,
[period_id] TEXT REFERENCES [periods]([period_id])
);
CREATE INDEX [idx_entity_relationships_period_id]
ON [entity_relationships] ([period_id]);
CREATE INDEX [idx_entity_relationships_source_id]
ON [entity_relationships] ([source_id]);
CREATE INDEX [idx_entity_relationships_object_entity_id]
ON [entity_relationships] ([object_entity_id]);
CREATE INDEX [idx_entity_relationships_relationship_type]
ON [entity_relationships] ([relationship_type]);
CREATE INDEX [idx_entity_relationships_subject_entity_id]
ON [entity_relationships] ([subject_entity_id]);