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)'}
4 rows where object_entity_id = "ENT_TYPHON"
This data as json, CSV (advanced)
Suggested facets: confidence, period_id
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1482 | Ullikummi ENT_HTT_ULLIKUMMI | received_as | Typhon ENT_TYPHON | medium | The Song of Ullikummi and Hesiod's Typhon narrative share the same plot structure: (1) the defeated predecessor deity (Kumarbi/defeated Titans, or Gaia acting on behalf of the old order) creates a monstrous adversary; (2) the monster grows to threaten heaven and challenge the storm god champion; (3) the champion (Teshub/Zeus) must struggle to defeat the monster. West (1997) pp. 300-302 makes this parallel explicit. In both myths, the monster's defeat marks the final establishment of the current divine order. Confidence medium because the narrative parallels are strong but the transmission mechanism is indirect (probably via Anatolian-Ionian contact rather than direct textual borrowing). | Martin L. West, The East Face of Helicon: West Asiatic Elements in Greek Poetry and Myth (Oxford: Clarendon Press, 1997) SRC_WEST_EAST_HELICON | reviewed | Archaic Period PER_GRK_ARCHAIC |
| 1494 | Tiamat ENT_MES_TIAMAT | aligned_with | Typhon ENT_TYPHON | medium | Functional/typological cognate (no attested diffusion of the Mesopotamian deity into the later cult); per Burkert/West the real transmission, where any, runs through Hurrian-Hittite intermediaries. | Walter Burkert, The Orientalizing Revolution: Near Eastern Influence on Greek Culture in the Early Archaic Age (Harvard University Press, 1992) SRC_BURKERT_ORIENT_REV | reviewed | Archaic Period PER_GRK_ARCHAIC |
| 7865 | Echidna ENT_MON_ECHIDNA | paired_with | Typhon ENT_TYPHON | high | Hesiod, Theog. 306-308: Echidna couples with Typhon (Typhaon) to bear the monster brood. paired_with (not consort_of, which is not a valid type). | Hesiod, Theogony and Works and Days SRC_HESIOD_THEOGONY | reviewed | |
| 8027 | Devil ENT_CHR_DEVIL | reception_of | Typhon ENT_TYPHON | medium | Combat-myth (chaoskampf) dragon-adversary underlying the Christian dragon-Satan (Rev. 12); Forsyth, The Old Enemy. | Neil Forsyth, The Old Enemy: Satan and the Combat Myth (Princeton University Press, 1987) SRC_FORSYTH_OLD_ENEMY | reviewed | Late Antiquity PER_LATE_ANTIQUE |
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]);