Entity Periods
Data license: MIT · Data source: jebboone/deitydb
- confidence
- {'description': 'high / medium / low — certainty of the period assignment'}
- rationale
- {'description': 'Justification with source citations'}
68 rows where period_id = "PER_MEDIEVAL_WEST"
This data as json, CSV (advanced)
Suggested facets: confidence, rationale, source_id
| Link | entity_id | period_id | confidence | rationale | source_id | review_status |
|---|---|---|---|---|---|---|
| ENT_CHR_COMMUNION_SAINTS,PER_MEDIEVAL_WEST | The Communion of Saints ENT_CHR_COMMUNION_SAINTS | Medieval Western PER_MEDIEVAL_WEST | high | The cult of the saints across the Christian calendar. | SRC_FARMER_SAINTS | reviewed |
| ENT_CHR_LUCIFER,PER_MEDIEVAL_WEST | Lucifer ENT_CHR_LUCIFER | Medieval Western PER_MEDIEVAL_WEST | medium | Christian reception entities primarily attested in medieval Western literature and demonology. | ||
| ENT_HERX_BOGOMILS,PER_MEDIEVAL_WEST | The Bogomils ENT_HERX_BOGOMILS | Medieval Western PER_MEDIEVAL_WEST | high | 10th-c. Balkan dualist movement founded under the priest Bogomil rejecting the material order and ecclesiastical hierarchy; transmitter of dualism westward, attested in Lambert. | SRC_LAMBERT_MH | reviewed |
| ENT_MARY_BROWN_SCAPULAR,PER_MEDIEVAL_WEST | Brown Scapular of Our Lady of Mount Carmel ENT_MARY_BROWN_SCAPULAR | Medieval Western PER_MEDIEVAL_WEST | high | Carmelite sacramental devotion (the scapular), trad. given by Our Lady of Mount Carmel to St Simon Stock (1251); a devotional object/practice rather than a figure; attested in Carmelite and Counter-Reformation devotion. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_MARY_CZESTOCHOWA,PER_MEDIEVAL_WEST | Our Lady of Częstochowa (the Black Madonna) ENT_MARY_CZESTOCHOWA | Medieval Western PER_MEDIEVAL_WEST | high | Venerated icon at the Jasna Góra monastery, Częstochowa, Poland; the 'Black Madonna,' national palladium of Poland; crowned 1717; attested in Polish religious history and Mariology. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_MARY_LORETO,PER_MEDIEVAL_WEST | Our Lady of Loreto ENT_MARY_LORETO | Medieval Western PER_MEDIEVAL_WEST | high | Marian title attached to the Holy House of Loreto (Marche, Italy), trad. translated from Nazareth; namesake of the Litany of Loreto; patroness of aviators; attested in medieval and modern Catholic devotion. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_MARY_MERCY,PER_MEDIEVAL_WEST | Our Lady of Mercy (Mercedes) ENT_MARY_MERCY | Medieval Western PER_MEDIEVAL_WEST | high | Marian title (Our Lady of Ransom / la Merced) tied to the founding of the Mercedarian Order by St Peter Nolasco (1218) for ransoming captives; feast 24 September; attested in medieval Iberian Catholic devotion. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_MARY_MOUNT_CARMEL,PER_MEDIEVAL_WEST | Our Lady of Mount Carmel ENT_MARY_MOUNT_CARMEL | Medieval Western PER_MEDIEVAL_WEST | high | Patronal title of the Carmelite Order, linked to the trad. 1251 vision of St Simon Stock and the Brown Scapular; feast 16 July; attested in medieval Carmelite tradition and Mariology. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_MARY_PERPETUAL_HELP,PER_MEDIEVAL_WEST | Our Lady of Perpetual Help ENT_MARY_PERPETUAL_HELP | Medieval Western PER_MEDIEVAL_WEST | high | Marian title centered on a Cretan-Byzantine icon (15th c.) entrusted by Pius IX to the Redemptorists (1866); widely diffused modern devotion; attested in icon history and Catholic Mariology. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_MARY_ROSARY,PER_MEDIEVAL_WEST | Our Lady of the Rosary ENT_MARY_ROSARY | Medieval Western PER_MEDIEVAL_WEST | high | Marian title tied to the Dominican Rosary devotion (trad. ascribed to St Dominic); feast (orig. Our Lady of Victory) instituted by Pius V after Lepanto, 1571; attested in Counter-Reformation Catholic devotion and liturgy. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_MARY_SORROWS,PER_MEDIEVAL_WEST | Our Lady of Sorrows ENT_MARY_SORROWS | Medieval Western PER_MEDIEVAL_WEST | high | Marian title (Mater Dolorosa) contemplating the Seven Sorrows of Mary; medieval devotion fostered by the Servite Order; feast 15 September; attested in medieval and modern Catholic Mariology. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_MARY_TITLES,PER_MEDIEVAL_WEST | Marian Titles and Devotions ENT_MARY_TITLES | Medieval Western PER_MEDIEVAL_WEST | high | Organizing hub collective for the historic titles, devotional images, and approved apparitions of the Blessed Virgin Mary across Catholic and Eastern devotion; not a separate figure. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_MARY_WALSINGHAM,PER_MEDIEVAL_WEST | Our Lady of Walsingham ENT_MARY_WALSINGHAM | Medieval Western PER_MEDIEVAL_WEST | high | English Marian shrine at Walsingham, Norfolk, founded after a vision of Richeldis de Faverches (trad. 1061); major medieval pilgrimage, suppressed at the Reformation, revived 20th c.; attested in English ecclesiastical history. | SRC_MIRAVALLE_MARIOLOGY | reviewed |
| ENT_REC_HECATE_PATRISTIC,PER_MEDIEVAL_WEST | Hecate (Patristic Reception) ENT_REC_HECATE_PATRISTIC | Medieval Western PER_MEDIEVAL_WEST | medium | Demonization continues and deepens in medieval Western Christian demonology. | ||
| ENT_SAINT_ADALBERT,PER_MEDIEVAL_WEST | Adalbert of Prague ENT_SAINT_ADALBERT | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_ANTHONY_PADUA,PER_MEDIEVAL_WEST | Anthony of Padua ENT_SAINT_ANTHONY_PADUA | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_BECKET,PER_MEDIEVAL_WEST | Thomas Becket ENT_SAINT_BECKET | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_BERNARD,PER_MEDIEVAL_WEST | Bernard of Clairvaux ENT_SAINT_BERNARD | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_BONIFACE,PER_MEDIEVAL_WEST | Boniface ENT_SAINT_BONIFACE | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_BRIDGET_SWEDEN,PER_MEDIEVAL_WEST | Bridget of Sweden ENT_SAINT_BRIDGET_SWEDEN | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_BRIGID_KILDARE,PER_MEDIEVAL_WEST | Brigid of Kildare ENT_SAINT_BRIGID_KILDARE | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_BRUNO,PER_MEDIEVAL_WEST | Bruno of Cologne ENT_SAINT_BRUNO | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_CANUTE,PER_MEDIEVAL_WEST | Canute of Denmark ENT_SAINT_CANUTE | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_CASIMIR,PER_MEDIEVAL_WEST | Casimir of Poland ENT_SAINT_CASIMIR | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_CATHERINE_GENOA,PER_MEDIEVAL_WEST | Catherine of Genoa ENT_SAINT_CATHERINE_GENOA | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_CATHERINE_SIENA,PER_MEDIEVAL_WEST | Catherine of Siena ENT_SAINT_CATHERINE_SIENA | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_CLARE,PER_MEDIEVAL_WEST | Clare of Assisi ENT_SAINT_CLARE | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_CUNIGUNDE,PER_MEDIEVAL_WEST | Cunigunde ENT_SAINT_CUNIGUNDE | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_CUTHBERT,PER_MEDIEVAL_WEST | Cuthbert ENT_SAINT_CUTHBERT | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_DENIS,PER_MEDIEVAL_WEST | Denis of Paris ENT_SAINT_DENIS | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_DOMINIC,PER_MEDIEVAL_WEST | Dominic ENT_SAINT_DOMINIC | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_EDMUND_MARTYR,PER_MEDIEVAL_WEST | Edmund the Martyr ENT_SAINT_EDMUND_MARTYR | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_EDWARD_CONFESSOR,PER_MEDIEVAL_WEST | Edward the Confessor ENT_SAINT_EDWARD_CONFESSOR | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_ELIZABETH_HUNGARY,PER_MEDIEVAL_WEST | Elizabeth of Hungary ENT_SAINT_ELIZABETH_HUNGARY | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_FAITH_CONQUES,PER_MEDIEVAL_WEST | Faith of Conques ENT_SAINT_FAITH_CONQUES | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_FOURTEEN_HELPERS,PER_MEDIEVAL_WEST | The Fourteen Holy Helpers ENT_SAINT_FOURTEEN_HELPERS | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_GENEVIEVE,PER_MEDIEVAL_WEST | Genevieve of Paris ENT_SAINT_GENEVIEVE | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_GERTRUDE,PER_MEDIEVAL_WEST | Gertrude the Great ENT_SAINT_GERTRUDE | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_GILES,PER_MEDIEVAL_WEST | Giles ENT_SAINT_GILES | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_HENRY_II,PER_MEDIEVAL_WEST | Henry II ENT_SAINT_HENRY_II | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_HILDEGARD,PER_MEDIEVAL_WEST | Hildegard of Bingen ENT_SAINT_HILDEGARD | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_JAMES_GREATER,PER_MEDIEVAL_WEST | James the Greater ENT_SAINT_JAMES_GREATER | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_LEONARD,PER_MEDIEVAL_WEST | Leonard of Noblac ENT_SAINT_LEONARD | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_LOUIS,PER_MEDIEVAL_WEST | Louis IX of France ENT_SAINT_LOUIS | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_MARGARET_SCOTLAND,PER_MEDIEVAL_WEST | Margaret of Scotland ENT_SAINT_MARGARET_SCOTLAND | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_MECHTILD,PER_MEDIEVAL_WEST | Mechtild of Hackeborn ENT_SAINT_MECHTILD | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_NEPOMUK,PER_MEDIEVAL_WEST | John of Nepomuk ENT_SAINT_NEPOMUK | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_NORBERT,PER_MEDIEVAL_WEST | Norbert of Xanten ENT_SAINT_NORBERT | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_OLAF,PER_MEDIEVAL_WEST | Olaf of Norway ENT_SAINT_OLAF | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_ROMUALD,PER_MEDIEVAL_WEST | Romuald ENT_SAINT_ROMUALD | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_ROYAL_SAINTS,PER_MEDIEVAL_WEST | Royal Saints ENT_SAINT_ROYAL_SAINTS | Medieval Western PER_MEDIEVAL_WEST | high | Royal saint cults flourished across the Western Middle Ages | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_SCHOLASTICA,PER_MEDIEVAL_WEST | Scholastica ENT_SAINT_SCHOLASTICA | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_STANISLAUS,PER_MEDIEVAL_WEST | Stanislaus of Kraków ENT_SAINT_STANISLAUS | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_STEPHEN_HUNGARY,PER_MEDIEVAL_WEST | Stephen I of Hungary ENT_SAINT_STEPHEN_HUNGARY | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_SWITHUN,PER_MEDIEVAL_WEST | Swithun ENT_SAINT_SWITHUN | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_THREE_KINGS,PER_MEDIEVAL_WEST | The Three Kings ENT_SAINT_THREE_KINGS | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_WALBURGA,PER_MEDIEVAL_WEST | Walburga ENT_SAINT_WALBURGA | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SAINT_WENCESLAUS,PER_MEDIEVAL_WEST | Wenceslaus ENT_SAINT_WENCESLAUS | Medieval Western PER_MEDIEVAL_WEST | A | Medieval Western (Latin) saint with major cultus. | SRC_FARMER_SAINTS | reviewed |
| ENT_SOL_ANAEL,PER_MEDIEVAL_WEST | Anael (Angel of Venus) ENT_SOL_ANAEL | Medieval Western PER_MEDIEVAL_WEST | high | Anael (Anachiel/Haniel) is named in the Latin astral-magic tradition as the angel of the sphere of Venus; shares its name with the Testament-of-Solomon Anael (ENT_LAT_ANAEL). | SRC_LIBER_RAZIELIS | reviewed |
| ENT_SOL_ARS_NOTORIA_ANGELS,PER_MEDIEVAL_WEST | The Angels of the Ars Notoria ENT_SOL_ARS_NOTORIA_ANGELS | Medieval Western PER_MEDIEVAL_WEST | high | The angels invoked through the notae and orationes of the Ars Notoria so the operator might receive, through angelic mediation, instantaneous infused knowledge and perfect memory of the liberal arts, theology and Scripture. | SRC_ARS_NOTORIA | reviewed |
| ENT_SOL_ARS_NOTORIA_NOTAE,PER_MEDIEVAL_WEST | The Notae of the Ars Notoria ENT_SOL_ARS_NOTORIA_NOTAE | Medieval Western PER_MEDIEVAL_WEST | high | The notae are the complex diagrammatic figures, inscribed with names of angels and verba ignota, contemplated while reciting the orationes; presented as a heaven-sent art by which knowledge of the sciences is infused. | SRC_ARS_NOTORIA | reviewed |
| ENT_SOL_BEATIFIC_VISION_OP,PER_MEDIEVAL_WEST | Operation of the Beatific Vision (Liber Juratus) ENT_SOL_BEATIFIC_VISION_OP | Medieval Western PER_MEDIEVAL_WEST | high | The central operation of the Sworn Book is a regimen of purification, prayer and consecration culminating in the operator's attainment of the beatific vision (the direct sight of God) mediated by angels. | SRC_LIBER_JURATUS | reviewed |
| ENT_SOL_CASSIEL,PER_MEDIEVAL_WEST | Cassiel ENT_SOL_CASSIEL | Medieval Western PER_MEDIEVAL_WEST | high | Cassiel (Cafziel/Captiel) is named in the Latin astral-magic tradition as the angel presiding over the sphere and hours of Saturn. | SRC_LIBER_RAZIELIS | reviewed |
| ENT_SOL_LIBER_JURATUS_KINGS,PER_MEDIEVAL_WEST | The Angelic Kings of the Air (Liber Juratus) ENT_SOL_LIBER_JURATUS_KINGS | Medieval Western PER_MEDIEVAL_WEST | high | The Sworn Book of Honorius names the kings of the air ruling the cardinal directions and the days/planets, each commanding subordinate aerial spirits, summoned within the operation aimed at the beatific vision. | SRC_LIBER_JURATUS | reviewed |
| ENT_SOL_PLANETARY_ANGELS,PER_MEDIEVAL_WEST | The Seven Planetary Angels of the Grimoire Tradition ENT_SOL_PLANETARY_ANGELS | Medieval Western PER_MEDIEVAL_WEST | high | The set of seven angels governing the planetary spheres standardized in medieval Latin astral-magic and Solomonic texts: Cassiel (Saturn), Sachiel (Jupiter), Samael (Mars), Michael (Sun), Anael (Venus), Raphael (Mercury), Gabriel (Moon). | SRC_LIBER_RAZIELIS | reviewed |
| ENT_SOL_SACHIEL,PER_MEDIEVAL_WEST | Sachiel ENT_SOL_SACHIEL | Medieval Western PER_MEDIEVAL_WEST | high | Sachiel (Zachariel) is named in the Latin Solomonic corpus as the angel governing the sphere and hours of Jupiter, invoked for prosperity and favor. | SRC_LIBER_RAZIELIS | reviewed |
| ENT_SOL_SAMAEL_MARS,PER_MEDIEVAL_WEST | Samael (Angel of Mars) ENT_SOL_SAMAEL_MARS | Medieval Western PER_MEDIEVAL_WEST | high | In the medieval Latin planetary-angel scheme Samael is assigned to the sphere of Mars; functionally distinct from the Gnostic/demiurgic Samael (ENT_GNO_SAMAEL) though sharing the name. | SRC_LIBER_RAZIELIS | reviewed |
| ENT_SOL_SEMIFORAS,PER_MEDIEVAL_WEST | The Semiforas / Schemhamphoras Names (Liber Razielis) ENT_SOL_SEMIFORAS | Medieval Western PER_MEDIEVAL_WEST | high | The Latin Liber Razielis transmits the Semiforas (a Latinization of Shem ha-Mephorash, the 'explicit Name'), powerful divine names revealed to Adam and the patriarchs conferring authority over creation and the angels. | SRC_LIBER_RAZIELIS | reviewed |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "entity_periods" (
[entity_id] TEXT REFERENCES [entities]([entity_id]),
[period_id] TEXT REFERENCES [periods]([period_id]),
[confidence] TEXT,
[rationale] TEXT,
[source_id] TEXT,
[review_status] TEXT,
PRIMARY KEY ([entity_id], [period_id])
);
CREATE INDEX [idx_entity_periods_period_id]
ON [entity_periods] ([period_id]);
CREATE INDEX [idx_entity_periods_entity_id]
ON [entity_periods] ([entity_id]);