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 object_entity_id = "ENT_MES_NAMMU"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 2432 | Nun ENT_EGY_NUN | aligned_with | Nammu ENT_MES_NAMMU | medium | Nun (Egyptian primordial watery abyss) and Nammu (Sumerian primordial sea-goddess, "the mother who gave birth to heaven and earth," Atrahasis Prologue; Enki and Ninhursag) are structurally parallel as the primordial undifferentiated water from which creation emerges and from which the creator deity is born. The parallel is noted in standard works on comparative ancient Near Eastern cosmogony. Key difference: Nun is gendered male; Nammu is gendered female (the Great Mother of Sumerian theology). Despite the gender inversion, both serve as the primordial creative matrix — the undifferentiated watery whole that precedes and enables creation. Confidence medium: independently developed traditions; structural parallel without direct historical connection. Pinch (2002) pp. 167-168. | Geraldine Pinch, Egyptian Mythology SRC_PINCH_EGYPTIAN_MYTH | reviewed | Old Kingdom PER_EGY_OLD_KINGDOM |
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]);