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)'}
10 rows where source_id = "SRC_CATECHISM_CC"
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 |
|---|---|---|---|---|---|---|---|---|
| 7819 | Heaven ENT_CHRR_HEAVEN | member_of | The Christian Cosmos ENT_CHRR_COSMOS | high | Heaven is a principal realm of the structured Christian cosmos. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed | |
| 7820 | Hell (Christian) ENT_CHRR_HELL | member_of | The Christian Cosmos ENT_CHRR_COSMOS | high | Hell is a principal realm of the structured Christian cosmos. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed | |
| 7821 | Purgatory ENT_CHRR_PURGATORY | member_of | The Christian Cosmos ENT_CHRR_COSMOS | high | Purgatory is the intermediate purifying realm of the Christian cosmos. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed | |
| 7822 | Limbo of the Fathers (Limbus Patrum) ENT_CHRR_LIMBUS_PATRUM | member_of | The Christian Cosmos ENT_CHRR_COSMOS | high | The Limbo of the Fathers is a region of the Christian otherworld cosmos. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed | |
| 7823 | Limbo of the Infants (Limbus Infantium) ENT_CHRR_LIMBUS_INFANTUM | member_of | The Christian Cosmos ENT_CHRR_COSMOS | medium | The Limbo of the Infants is a theorized region of the Christian cosmos. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed | |
| 7826 | The Bosom of Abraham ENT_CHRR_BOSOM_ABRAHAM | equated_with | Limbo of the Fathers (Limbus Patrum) ENT_CHRR_LIMBUS_PATRUM | high | Christian tradition identifies the Bosom of Abraham with the Limbo of the Fathers, the rest of the righteous dead before Christ. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed | |
| 7827 | The Beatific Vision ENT_CHRR_BEATIFIC_VISION | dwells_in | The Empyrean ENT_CHRR_EMPYREAN | medium | The Beatific Vision is enjoyed by the blessed in the Empyrean, the highest heaven. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed | |
| 7831 | Limbo of the Fathers (Limbus Patrum) ENT_CHRR_LIMBUS_PATRUM | member_of | The Nine Circles of Hell ENT_CHRR_NINE_CIRCLES | medium | Dante places Limbo as the first of the nine circles of Hell. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed | |
| 7835 | Hell (Christian) ENT_CHRR_HELL | reception_of | Gehenna ENT_JM_GEHENNA | medium | The Christian conception of Hell as the place of eternal punishment develops from the Jewish Gehenna. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed | |
| 7836 | The Bosom of Abraham ENT_CHRR_BOSOM_ABRAHAM | reception_of | Sheol ENT_ISR_SHEOL | low | The Bosom of Abraham as the rest of the righteous dead draws on the older Israelite Sheol as abode of the dead. | Catechism of the Catholic Church (1992, rev. 1997) SRC_CATECHISM_CC | reviewed |
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]);