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 subject_entity_id = "ENT_VAL_ZOE"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 637 | Zoe ENT_VAL_ZOE | member_of | Aeons ENT_GNO_AEONS | high | Zoe is a Valentinian aeon. | Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC | reviewed | |
| 2442 | Zoe ENT_VAL_ZOE | parent_of | Decad ENT_VAL_DECAD | high | Irenaeus AH I.2.5: Zoe and Logos together produce the ten Decad aeons. The pairing of Logos (Word) and Zoe (Life) as the generative principle of the second Pleroma tier reflects the Johannine theological matrix (John 1:4: "In him was life [zoe], and the life was the light of all people") that underpins Valentinian cosmological speculation. | 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 |
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]);