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_HTT_INARAS"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1538 | Inaras ENT_HTT_INARAS | guides | Tarhunna ENT_HTT_TARHUNNA | high | In the first version of the Illuyanka myth (CTH 321 §§1-8), Inaras devises and executes the strategy that allows Tarhunna (the storm god) to defeat Illuyanka: she prepares the feast that lures the serpent into vulnerability and recruits the mortal Hupasiya to bind him. Tarhunna's victory over Illuyanka is explicitly enabled by Inaras's cunning rather than the storm god's direct power alone. | Harry A. Hoffner Jr., Hittite Myths, 2nd ed. (Society of Biblical Literature, 1998) SRC_HOFFNER_HITTITE_MYTHS | reviewed | Hittite Empire Period PER_HTT_EMPIRE |
| 5972 | Inaras ENT_HTT_INARAS | member_of | The Hittite Pantheon ENT_HTT_PANTHEON | high | Inara(s) is the Hittite protective/tutelary goddess of the Illuyanka myth. | Harry A. Hoffner Jr., Hittite Myths, 2nd ed. (Society of Biblical Literature, 1998) SRC_HOFFNER_HITTITE_MYTHS | 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]);