This is the Order of Worship that was used as a model for these database schema.
| Description | Type |
|---|---|
| Prelude | Music |
| Announcements (our church calls this "In Step With St. Stephen") | Reading |
| Exchange Greetings | Reading |
| Choral Introit | Anthem or Music |
| Call To Worship | Reading |
| Hymn of Praise | Music |
| Prayer of Confession | Reading |
| Assurance of Pardon | Reading |
| Gloria Patri (aka Glory Be To The Father...) | Music |
| Choral Anthem | Anthem or Music |
| Children's Sermon (our church calls this "A Moment With The Children") | Reading |
| Offering (our church calls this "Our Gifts To God") | Music |
| Doxology (aka Praise God from Whom All Blessings Flow...) | Music |
| Prayer Of Dedication | Reading |
| Statement of Faith (typically either the Apostles Creed or Nicene Creed) | Reading |
| The Ascription | Reading |
| Hymn | Music |
| Prayer of Illumination | Reading |
| Sermon | Sermon |
| Closing Hymn | Music |
| Benediction | Reading |
| Response | Anthem or Music |
| Postlude | Music |
A service is composed of service components with some additional fields. They are all linked together with a common service id.
+---------------------+ | service | +---------------------+ | id | | timestamp | | title | (usually the lectionary day description) | subtitle | (usually a "Thought for the day" type thing) +---------------------+
Service components that make up a given service are stored like this:
+---------------------+ | service_component | +---------------------+ | id | | service_id | (reference to service table, id field) | order | (integer indicating the worship order) | stand | (should the congregation stand? boolean y/n) | title | (optional title for component such as Hymn of Praise, Offertory, etc.) | type | (reference to a specific service type table) | type_id | (reference to id in service type table) | person | (name of musician, reader, pastor, etc.) +---------------------+
The service types each have their own table.
+---------------------+ | anthem | (choir anthems from music library) +---------------------+ | id | | account | | title | | composer | | author | | arranger | | publisher | | scripture | | voicing | | pages | | length | | copies | | publish_date | | purchase_date | | lyrics | | notes | +---------------------+ +---------------------+ | music | (freeform entry optionally filled from hymnbook XML file) +---------------------+ | id | | title | | composer | | author | | tune | | lyrics | | notes | +---------------------+ +---------------------+ | reading | (can be a reponsive reading, prayer, creed, etc.) +---------------------+ | id | | content | | notes | +---------------------+ +---------------------+ | scripture | (freeform entry filled from xml file) +---------------------+ | id | | reference | | translation | | content | | notes | +---------------------+ +---------------------+ | sermon | +---------------------+ | id | | title | | theme | | scripture | (the scripture reference used for the sermon) | excerpt | (an optional field for an excerpt from scripture or sermon) | content | | notes | +---------------------+