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_URA_ARUBANI"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 2356 | Arubani ENT_URA_ARUBANI | spouse_of | Khaldi ENT_URA_KHALDI | medium | Arubani is designated "the deity of Khaldi" in Urartian inscriptions and is associated with him as his divine consort. The pairing mirrors the broader Hurrian theological pattern where the supreme deity (Teshub) has a consort (Hepat). Confidence medium: the spousal relationship is inferred from the inscriptional association rather than being explicitly stated as marriage in the surviving Urartian texts. Piotrovsky (1969) pp. 100-102. | Boris B. Piotrovsky, The Ancient Civilization of Urartu: An Archaeological Adventure, trans. James Hogarth (Cowles / Cresset Press, New York / London, 1969) SRC_PIOTROVSKY_URARTU | reviewed | Kingdom of Urartu PER_URA_IRON_AGE |
| 2357 | Arubani ENT_URA_ARUBANI | aligned_with | Shaushka ENT_HTT_SHAUSHKA | medium | Arubani and Hurrian/Hittite Shaushka are structurally parallel: both are the goddess associated with the supreme storm/war deity (Arubani with Khaldi; Shaushka as consort of Teshub), both are love/arts/fertility deities complementing their consort's war function. If Teisheba = Teshub through Hurro-Urartian inheritance, then Arubani as Khaldi's consort plausibly inherits the Shaushka role. Confidence medium: the comparison is structurally sound but the surviving evidence for Arubani's precise functions is thin. Zimansky (1985) p. 72. | Paul E. Zimansky, Ecology and Empire: The Structure of the Urartian State (Studies in Ancient Oriental Civilization 41; Oriental Institute of the University of Chicago, Chicago, 1985) SRC_ZIMANSKY_URARTU | reviewed | Kingdom of Urartu PER_URA_IRON_AGE |
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]);