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)'}
1 row where subject_entity_id = "ENT_HTT_ULLIKUMMI"
This data as json, CSV (advanced)
| 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 |
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]);