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)'}
8 rows where subject_entity_id = "ENT_GNO_SOPHIA"
This data as json, CSV (advanced)
Suggested facets: relationship_type, confidence, source_id, period_id
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 593 | Sophia ENT_GNO_SOPHIA | member_of | Aeons ENT_GNO_AEONS | high | Sophia is an aeon in several Gnostic systems. | Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC | reviewed | |
| 597 | Sophia ENT_GNO_SOPHIA | participates_in_creation | Creation ENT_CREATION | medium | Sophia’s fall often triggers lower creation/demiurgic generation. | Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC | reviewed | |
| 602 | Sophia ENT_GNO_SOPHIA | undergoes_process | Fall ENT_FALL | high | Sophia is associated with fall/deficiency and restoration motifs. | Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC | reviewed | |
| 608 | Sophia ENT_GNO_SOPHIA | embodies | Wisdom ENT_WISDOM | high | Sophia means Wisdom and functions as wisdom personification/aeon. | Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC | reviewed | |
| 1446 | Sophia ENT_GNO_SOPHIA | received_as | Shekhinah ENT_JM_SHEKHINAH | medium | The Gnostic Sophia (exiled aeon who falls from the Pleroma and must be redeemed) is structurally parallel to — and may have directly influenced — the Kabbalistic Shekhinah (divine presence that goes into exile with Israel and yearns for reunion with the masculine divine at the end of time). Both are feminine divine beings in a state of exile/fall who must be restored. Scholem (Origins of the Kabbalah) discusses the Gnostic Sophia's contribution to Kabbalistic conceptions of the Shekhinah; Idel notes the structural parallel while debating the direction of influence. Medium confidence: the parallel is documented; direct influence vs. parallel development remains debated. | Gershom Scholem, Kabbalah SRC_SCHOLEM_KABBALAH | reviewed | Jewish Mystical Medieval PER_JM_MEDIEVAL |
| 2449 | Sophia ENT_GNO_SOPHIA | member_of | Dodecad ENT_VAL_DODECAD | high | Sophia (the 30th and final aeon of the entire Pleroma) is paired with Theletos as the sixth (last) pair of the Dodecad. Her position as the outermost aeon — closest to the Pleroma boundary (Horos) and furthest from Bythos — is a structural precondition for her fall: she is the most distant from the Father and therefore most susceptible to the desire to comprehend him directly. Irenaeus AH I.2.2-3. | Irenaeus of Lyons, Adversus Haereses (Against Heresies), c. 180 CE; ed. Rousseau & Doutreleau, SC 263-264, 293-294, 210-211 (Cerf, 1979-2002) SRC_IRENAEUS_AH | reviewed | Gnostic and Neoplatonic (2nd–4th c.) PER_GNO_2ND_4TH |
| 2450 | Sophia ENT_GNO_SOPHIA | spouse_of | Theletos ENT_VAL_THELETOS | high | Irenaeus AH I.2.2: Sophia is paired with Theletos as the final syzygy of the Dodecad. The separation of Sophia from Theletos — her desire to comprehend the Father without her proper consort — is the cosmological disaster that generates Achamoth and ultimately the material world. The Sophia-Theletos pairing is the most theologically loaded syzygy in the Valentinian Pleroma, since it is the integrity of this pairing (Wisdom operating within the bounds of divine Will) that separates the ordered Pleroma from the chaotic material creation. | Irenaeus of Lyons, Adversus Haereses (Against Heresies), c. 180 CE; ed. Rousseau & Doutreleau, SC 263-264, 293-294, 210-211 (Cerf, 1979-2002) SRC_IRENAEUS_AH | reviewed | Gnostic and Neoplatonic (2nd–4th c.) PER_GNO_2ND_4TH |
| 2584 | Sophia ENT_GNO_SOPHIA | member_of | Eleleth ENT_SET_ELELETH | medium | Sophia is associated with the fourth luminary Eleleth before her fall. | Apocryphon of John (The Secret Book of John), NHC II,1 / III,1 / IV,1 and BG 8502,2; c. 2nd c. CE, Egypt SRC_APOCRYPHON_JOHN | reviewed | Gnostic and Neoplatonic (2nd–4th c.) PER_GNO_2ND_4TH |
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]);