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)'}
57 rows where object_entity_id = "ENT_DISEASE"
This data as json, CSV (advanced)
Suggested facets: relationship_type, confidence, source_id
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 334 | Sekhmet ENT_EGY_SEKHMET | causes_affliction | Disease ENT_DISEASE | medium | Sekhmet can send plague and disease; Disease is a cross-traditional abstraction. | Richard H. Wilkinson, The Complete Gods and Goddesses of Ancient Egypt SRC_WILKINSON_EGYPTIAN_GODS | reviewed | |
| 455 | Lamashtu ENT_MES_LAMASHTU | causes_affliction | Disease ENT_DISEASE | medium | Lamashtu is associated with disease and harm. | Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO | reviewed | |
| 488 | Utukku ENT_MES_UTUKKU | causes_affliction | Disease ENT_DISEASE | medium | Utukku spirits/demons can cause affliction. | Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO | reviewed | |
| 489 | Nergal ENT_MES_NERGAL | causes_affliction | Disease ENT_DISEASE | medium | Nergal is associated with plague and destructive disease. | Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO | reviewed | |
| 490 | Pazuzu ENT_MES_PAZUZU | causes_affliction | Disease ENT_DISEASE | medium | Pazuzu is a dangerous wind demon connected to disease and affliction. | Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO | reviewed | |
| 491 | Rabisu ENT_MES_RABISU | causes_affliction | Disease ENT_DISEASE | medium | Rabisu is a lurking demon associated with affliction. | Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO | reviewed | |
| 716 | Demons ENT_CHR_DEMONS | causes_affliction | Disease ENT_DISEASE | medium | Demons can be associated with affliction and illness in Christian texts. | Christian demonology reference layer SRC_CHRISTIAN_DEMONOLOGY_GENERAL | reviewed | |
| 1105 | Artosael ENT_LAT_DECAN_ARTOSAEL | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1106 | Barsaphael ENT_LAT_DECAN_BARSAPHAEL | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1107 | Belbel ENT_LAT_DECAN_BELBEL | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1108 | Kourtael ENT_LAT_DECAN_KOURTAEL | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1109 | Kourtael II ENT_LAT_DECAN_KOURTAEL_2 | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1110 | Marmareth ENT_LAT_DECAN_MARMARETH | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1111 | Orophael ENT_LAT_DECAN_OROPHAEL | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1112 | Ruax ENT_LAT_DECAN_RUAX | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1113 | Decans ENT_LAT_DECANS | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1114 | Sphandor ENT_LAT_DECAN_SPHANDOR | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1115 | Sphendonael ENT_LAT_DECAN_SPHENDONAEL | causes_affliction | Disease ENT_DISEASE | medium | This decan demon is associated with bodily disease or affliction in the Testament of Solomon. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1126 | Atrax ENT_LAT_DECAN_ATRAX | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Atrax is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1127 | Bobel ENT_LAT_DECAN_BOBEL | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Bobel is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1128 | Buldumech ENT_LAT_DECAN_BULDUMECH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Buldumech is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1129 | Ieropael ENT_LAT_DECAN_IEROPAEL | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Ieropael is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1130 | Katanikotael ENT_LAT_DECAN_KATANIKOTAEL | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Katanikotael is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1131 | Kumeatel ENT_LAT_DECAN_KUMEATEL | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Kumeatel is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1132 | Mardero ENT_LAT_DECAN_MARDERO | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Mardero is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1133 | Naoth ENT_LAT_DECAN_NAOTH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Naoth is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1134 | Roeled ENT_LAT_DECAN_ROELED | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Roeled is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1135 | Saphathorael ENT_LAT_DECAN_SAPHATHORAEL | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Saphathorael is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1145 | Akton ENT_LAT_DECAN_AKTON | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Akton is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1146 | Alath ENT_LAT_DECAN_ALATH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Alath is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1147 | Alleborith ENT_LAT_DECAN_ALLEBORITH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Alleborith is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1148 | Anatreth ENT_LAT_DECAN_ANATRETH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Anatreth is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1149 | Anoster ENT_LAT_DECAN_ANOSTER | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Anoster is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1150 | Enenuth ENT_LAT_DECAN_ENENUTH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Enenuth is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1151 | Harpax ENT_LAT_DECAN_HARPAX | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Harpax is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1152 | Nefthada ENT_LAT_DECAN_NEFTHADA | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Nefthada is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1153 | Pheth ENT_LAT_DECAN_PHETH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Pheth is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1160 | Agchonion ENT_LAT_DECAN_AGCHONION | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Agchonion is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1161 | Autothith ENT_LAT_DECAN_AUTOTHITH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Autothith is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1162 | Bianakith ENT_LAT_DECAN_BIANAKITH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Bianakith is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1163 | Hephesikireth ENT_LAT_DECAN_HEPHESIKIRETH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Hephesikireth is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1164 | Ichthion ENT_LAT_DECAN_ICHTHION | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Ichthion is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1165 | Phthenoth ENT_LAT_DECAN_PHTHENOTH | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, Phthenoth is one of the thirty-six decans (heavenly decan-spirits of the zodiac) who afflict humankind with disease; when bound by Solomon it names the specific ailment it inflicts and the angelic name that thwarts it. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 1191 | Leophoros ENT_LAT_LEOPHOROS | causes_affliction | Disease ENT_DISEASE | medium | In the Testament of Solomon, the demon Leophoros, interrogated and bound by Solomon, is described as bringing affliction upon disease. | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | reviewed | |
| 3858 | Sulak ENT_MES_SULAK | causes_affliction | Disease ENT_DISEASE | high | Lurker of the privy who strikes with sudden seizure | Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO | reviewed | |
| 3859 | Edimmu ENT_MES_EDIMMU | causes_affliction | Disease ENT_DISEASE | high | Restless ghost that afflicts the living with illness | Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO | reviewed | |
| 3864 | Febris ENT_ROM_FEBRIS | causes_affliction | Disease ENT_DISEASE | high | Goddess of fever propitiated to avert malarial illness | Georg Wissowa, Religion und Kultus der Römer (2nd ed., Munich, 1912) SRC_WISSOWA_RKR | reviewed | |
| 3865 | Mefitis ENT_ROM_MEFITIS | causes_affliction | Disease ENT_DISEASE | medium | Goddess of noxious exhalations held to cause sickness | Georg Wissowa, Religion und Kultus der Römer (2nd ed., Munich, 1912) SRC_WISSOWA_RKR | reviewed | |
| 3890 | Sebastian ENT_CHR_SEBASTIAN | opposes | Disease ENT_DISEASE | medium | Invoked against plague | Jacobus de Voragine, Golden Legend SRC_GOLDEN_LEGEND | reviewed | |
| 3923 | Asag ENT_MES_ASAG | causes_affliction | Disease ENT_DISEASE | high | The monstrous demon of disease in the Lugale | Electronic Text Corpus of Sumerian Literature SRC_ETCSL | reviewed | |
| 3957 | Shul-pa-e ENT_MES_SHULPAE | causes_affliction | Disease ENT_DISEASE | medium | Regarded as a bringer of disease | Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO | reviewed | |
| 4544 | Buer ENT_GOE_BUER | presides_over | Disease ENT_DISEASE | high | Buer teaches the virtues of herbs and heals all distempers. | The Lesser Key of Solomon (Lemegeton), Book I: Ars Goetia; ed. S. L. MacGregor Mathers & Aleister Crowley (1904) SRC_LEMEGETON | reviewed | |
| 4611 | Marbas ENT_GOE_MARBAS | presides_over | Disease ENT_DISEASE | high | Marbas both causes and cures diseases. | The Lesser Key of Solomon (Lemegeton), Book I: Ars Goetia; ed. S. L. MacGregor Mathers & Aleister Crowley (1904) SRC_LEMEGETON | reviewed | |
| 4641 | Sabnock ENT_GOE_SABNOCK | presides_over | Disease ENT_DISEASE | high | Afflicts men with wounds and rotten sores full of worms. | The Lesser Key of Solomon (Lemegeton), Book I: Ars Goetia; ed. S. L. MacGregor Mathers & Aleister Crowley (1904) SRC_LEMEGETON | reviewed | |
| 4652 | Shax ENT_GOE_SHAX | presides_over | Disease ENT_DISEASE | high | Takes away the sight, hearing and understanding of any man. | The Lesser Key of Solomon (Lemegeton), Book I: Ars Goetia; ed. S. L. MacGregor Mathers & Aleister Crowley (1904) SRC_LEMEGETON | reviewed | |
| 4666 | Vepar ENT_GOE_VEPAR | presides_over | Disease ENT_DISEASE | high | Kills men within three days by wounds that putrefy. | The Lesser Key of Solomon (Lemegeton), Book I: Ars Goetia; ed. S. L. MacGregor Mathers & Aleister Crowley (1904) SRC_LEMEGETON | reviewed | |
| 5372 | Dybbuk ENT_JM_DYBBUK | presides_over | Disease ENT_DISEASE | medium | The dybbuk manifests as affliction/illness of the possessed host requiring exorcism. | Medieval and early-modern Jewish folklore (Sefer Hasidim; East European and Lurianic demonological tradition) SRC_JEWISH_FOLKLORE | 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]);