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 subject_entity_id = "ENT_EGY_ATUM"
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 |
|---|---|---|---|---|---|---|---|---|
| 248 | Atum ENT_EGY_ATUM | cult_form_of | Ra ENT_EGY_RA | medium | Atum is an evening/creator solar form related to Ra in solar theology. | Richard H. Wilkinson, The Complete Gods and Goddesses of Ancient Egypt SRC_WILKINSON_EGYPTIAN_GODS | reviewed | |
| 1564 | Atum ENT_EGY_ATUM | parent_of | Shu ENT_EGY_SHU | high | Pyramid Texts Utterance 600: Atum spat out Shu ("who spat out Shu, who expectorated Tefnut") from Heliopolis. Also PT 527, 1248 describe Atum creating Shu and Tefnut by masturbation (the "hand of Atum" tradition). Atum as the creator of the first divine pair Shu (air) and Tefnut (moisture) is the foundational act of the Heliopolitan cosmogony and the root of the Ennead genealogy. | R. O. Faulkner, The Ancient Egyptian Pyramid Texts (Oxford University Press, 1969; repr. Aris & Phillips, 1998) SRC_FAULKNER_PYRAMID_TEXTS | reviewed | Old Kingdom PER_EGY_OLD_KINGDOM |
| 1565 | Atum ENT_EGY_ATUM | parent_of | Tefnut ENT_EGY_TEFNUT | high | Pyramid Texts Utterance 600: Atum expectorated Tefnut alongside Shu. Tefnut (moisture/cosmic order) is the twin of Shu and the second generation of the Ennead; both are products of Atum's creative act at the primordial moment on the Benben hill of Heliopolis. | R. O. Faulkner, The Ancient Egyptian Pyramid Texts (Oxford University Press, 1969; repr. Aris & Phillips, 1998) SRC_FAULKNER_PYRAMID_TEXTS | 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]);