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)'}
1 row where subject_entity_id = "ENT_MER_SEBIUMEKER"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 2365 | Sebiumeker ENT_MER_SEBIUMEKER | patron_of | Fertility ENT_FERTILITY | medium | Sebiumeker's role as a creator/progenitor deity at Musawwarat es-Sufra places him in the domain of fertility and generation. His human form (as opposed to Apedemak's lion head) and his depiction in scenes of divine procreation suggest fertility patronage. Confidence medium: the creator deity attribution is inferred from iconographic context rather than directly inscribed in surviving texts. Török (1997) p. 483. | László Török, The Kingdom of Kush: Handbook of the Napatan-Meroitic Civilization (Handbook of Oriental Studies, Section 1: The Near and Middle East, Vol. 31; E.J. Brill, Leiden / New York / Cologne, 1997) SRC_TÖRÖK_MEROE | reviewed | Napatan–Meroitic Kingdom of Kush PER_MER_NAPATAN_MEROITIC |
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]);