Relationships

2,079 typed, source-backed relationships between entities. Each row records a directed relationship (subject → type → object) with a justifying source and rationale note. See relationship_types for the full controlled vocabulary of 70 relationship types. Key types: reception_of / received_as (transmission across traditions), equated_with (interpretatio graeca / analogues), parent_of (genealogy), member_of (collective membership), emanates_from (Gnostic/Neoplatonic structure).

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)'}

18 rows where source_id = "SRC_HEKHALOT_SCHAFER_SYNOPSE"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subject_entity_id, relationship_type, object_entity_id, confidence

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
1028 Ophanim ENT_JM_OPHANIM member_of Angels ENT_ANGELS high Ophanim are angelic beings associated with the throne vision. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1029 Chayyot ENT_JM_CHAYYOT member_of Angels ENT_ANGELS high Chayyot are angelic living creatures. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1030 Hashmallim ENT_JM_HASHMALLIM member_of Angels ENT_ANGELS high Hashmallim are radiant angelic beings. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1037 Merkabah ENT_JM_MERKABAH undergoes_process Ascent ENT_THEURGIC_ASENT high Merkabah mysticism is associated with heavenly ascent. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1044 Merkabah ENT_JM_MERKABAH undergoes_process Heavenly Journey ENT_HEAVENLY_JOURNEY high Merkabah traditions concern ascent through heavenly realms. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1048 Sandalphon ENT_JM_SANDALPHON associated_ritual Prayer ENT_PRAYER high Sandalphon is associated with prayer and heavenly mediation. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1050 Merkabah ENT_JM_MERKABAH identified_with Throne ENT_THRONE high Merkabah is the divine throne-chariot. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1220 Seraphim ENT_JM_SERAPHIM member_of Angels ENT_ANGELS high Seraphim is enumerated among the ranks of the angelic host (Angels) in the Hekhalot/3 Enoch literature. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1221 Chayyot ENT_JM_CHAYYOT guardian_of Throne ENT_THRONE medium In the Hekhalot/Merkavah literature, the Chayyot are the angelic order that bears and surrounds the divine Throne in the celestial throne-liturgy. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1222 Ophanim ENT_JM_OPHANIM guardian_of Throne ENT_THRONE medium In the Hekhalot/Merkavah literature, the Ophanim are the angelic order that bears and surrounds the divine Throne in the celestial throne-liturgy. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1223 Hashmallim ENT_JM_HASHMALLIM guardian_of Throne ENT_THRONE medium In the Hekhalot/Merkavah literature, the Hashmallim are the angelic order that bears and surrounds the divine Throne in the celestial throne-liturgy. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1224 Seraphim ENT_JM_SERAPHIM guardian_of Throne ENT_THRONE medium In the Hekhalot/Merkavah literature, the Seraphim are the angelic order that bears and surrounds the divine Throne in the celestial throne-liturgy. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1225 Sandalphon ENT_JM_SANDALPHON associated_ritual Praise ENT_PRAISE medium In the Hekhalot literature, Sandalphon weaves the prayers and praises of Israel into crowns for the divine Throne, bound to the heavenly liturgy of praise. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
1226 Sandalphon ENT_JM_SANDALPHON member_of Angels ENT_ANGELS high Sandalphon is enumerated among the ranks of the angelic host (Angels) in the Hekhalot/3 Enoch literature. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
2812 Sar ha-Panim ENT_JM_SAR_HAPANIM identified_with Metatron ENT_JM_METATRON high The Prince of the Presence of the Hekhalot is Metatron. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
2816 Zagzagel ENT_JM_ZAGZAGEL aligned_with Sar Torah ENT_JM_SAR_TORAH medium Zagzagel and the Sar Torah are both princes who impart the secrets of Torah. Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
3973 Nuriel ENT_JM_NURIEL presides_over Fire ENT_FIRE medium Angel of fire Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  
4007 Kemuel ENT_JM_KEMUEL guardian_of Merkabah ENT_JM_MERKABAH medium Gatekeeper of heaven before the throne Peter Schäfer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_SCHAFER_SYNOPSE reviewed  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);