title = "Service Schema"; $page->description = "This page describes the service table and related schema."; $page->content = << 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               |
  +---------------------+

EOF; $page->display(); ?>