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)'}
5 rows where subject_entity_id = "ENT_ISR_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 |
|---|---|---|---|---|---|---|---|---|
| 530 | Sophia/Wisdom ENT_ISR_SOPHIA | participates_in_creation | Creation ENT_CREATION | medium | Wisdom participates in creation/order traditions. | Dictionary of Deities and Demons in the Bible SRC_DDD_BIBLE | reviewed | |
| 553 | Sophia/Wisdom ENT_ISR_SOPHIA | embodies | Wisdom ENT_WISDOM | high | Sophia/Wisdom is personified wisdom. | Dictionary of Deities and Demons in the Bible SRC_DDD_BIBLE | reviewed | |
| 1379 | Sophia/Wisdom ENT_ISR_SOPHIA | reception_of | Athirat/Asherah ENT_CAN_ASHERAH | low | Sophia/Wisdom as possible sublimation of suppressed Asherah; consort-of-the-high-god position in Proverbs 8 parallels Asherah's role at Ugarit. Scholarly hypothesis; contested. | Dictionary of Deities and Demons in the Bible SRC_DDD_BIBLE | reviewed | Second Temple Period PER_ISR_SECOND_TEMPLE |
| 1442 | Sophia/Wisdom ENT_ISR_SOPHIA | received_as | Shekhinah ENT_JM_SHEKHINAH | medium | The Kabbalistic Shekhinah (divine indwelling/feminine presence, tenth sefirah in the Zohar) is the reception and elaboration of the Sophia/Wisdom tradition: Proverbs 8:30–31 presents Wisdom as beside God "like a master workman" and "delighting before him"; Sirach 24 has Wisdom dwell in Israel. The Zohar develops this into the Shekhinah as God's feminine presence that dwells with Israel in exile, weeps for Jerusalem, and is reunited with the masculine divine at the end of time. Scholem (Kabbalah, 1974) explicitly traces this from Sophia through Philo into Kabbalistic theology. | Gershom Scholem, Kabbalah SRC_SCHOLEM_KABBALAH | reviewed | Jewish Mystical Medieval PER_JM_MEDIEVAL |
| 1444 | Sophia/Wisdom ENT_ISR_SOPHIA | received_as | Hokhmah ENT_JM_HOKHMAH | medium | The Kabbalistic sefirah Hokhmah (Wisdom, second sefirah in the Tree of Life) is the direct reception of the Hebrew Sophia/Wisdom hypostasis into the Kabbalistic emanation system. Both are feminine personifications of divine wisdom that stand at the highest level of the accessible divine realm; both are described as the first emanation through which creation proceeds (Proverbs 8:22: "The LORD created me at the beginning of his work"). Scholem documents the continuity; the Zohar's treatment of Hokhmah explicitly echoes the Wisdom of Proverbs. | Gershom Scholem, Kabbalah SRC_SCHOLEM_KABBALAH | reviewed | Jewish Mystical Medieval PER_JM_MEDIEVAL |
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]);