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)'}
2 rows where object_entity_id = "ENT_EGY_MUT"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1568 | Amun ENT_EGY_AMUN | spouse_of | Mut ENT_EGY_MUT | high | Amun and Mut form the divine couple of the Theban Triad (Amun–Mut–Khonsu), with Khonsu as their son. Mut's Precinct at Karnak (south of the main Amun temple complex) was her primary cult center. The pairing is the dominant theological arrangement of the New Kingdom Egyptian state religion. Wilkinson (2003) p. 151. | Richard H. Wilkinson, The Complete Gods and Goddesses of Ancient Egypt SRC_WILKINSON_EGYPTIAN_GODS | reviewed | New Kingdom PER_EGY_NEW_KINGDOM |
| 2100 | Wosret ENT_EGY_WOSRET | received_as | Mut ENT_EGY_MUT | medium | Wosret's role as female counterpart of Amun at Karnak was gradually absorbed by Mut from the Middle Kingdom onward; the two goddesses overlap in their Theban protective function. UCLA Encyclopedia of Egyptology. | UCLA Encyclopedia of Egyptology SRC_UCLA_EGYPTOLOGY | approved |
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]);