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_MES_APSU"
This data as json, CSV (advanced)
Suggested facets: relationship_type, confidence, source_id
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1499 | Oceanus ENT_OCEANUS | aligned_with | Apsu ENT_MES_APSU | medium | Functional/typological cognate, not an attested reception (the cosmic-sovereignty/chaos parallels route through Hurrian-Hittite intermediaries or are modern comparisons; Burkert, West). | 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 |
| 2431 | Nun ENT_EGY_NUN | aligned_with | Apsu ENT_MES_APSU | medium | Nun and Apsu are the two nearest cross-cultural parallels for the concept of the primordial male freshwater/undifferentiated-water abyss from which creation emerges: Nun is the Egyptian primordial watery chaos (gendered male), while Apsu is the Akkadian primordial freshwater ocean (also gendered male) who mingles with Tiamat (salt water) to produce the first gods in the Enuma Elish. Both Nun and Apsu represent the primordial water-before-creation as an existential category, both are gendered male, and both precede and enable the creation of the ordered cosmos. The parallel is widely noted in comparative cosmogony scholarship. Confidence medium: both are independently developed primordial water deities with no direct historical connection; the parallel is structural/typological. Pinch (2002) pp. 167-168. | Geraldine Pinch, Egyptian Mythology SRC_PINCH_EGYPTIAN_MYTH | reviewed | Old Kingdom PER_EGY_OLD_KINGDOM |
| 3001 | Lahmu ENT_MES_LAHMU | child_of | Apsu ENT_MES_APSU | high | Apsu and Tiamat bring forth Lahmu and Lahamu (Enuma Elish I.10). | Enuma Elish (the Babylonian Epic of Creation), c. late 2nd millennium BCE SRC_ENUMA_ELISH | reviewed | |
| 3005 | Mummu ENT_MES_MUMMU | aligned_with | Apsu ENT_MES_APSU | high | Mummu is the vizier and counsellor of Apsu (Enuma Elish I.30-48). | Enuma Elish (the Babylonian Epic of Creation), c. late 2nd millennium BCE SRC_ENUMA_ELISH | reviewed |
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]);