Event Database for a local Church

This is just a collection of ideas, which will hopefully at some time evolve into a documentation.

It is inspired by the usefulness (almost need) to collect all events of a local church (Christus-Treff Marburg) in one single database for publishing on a web site.

This database should be filled by a few authorized people (who will be given a password) that do not have HTML knowledge and not enough understanding to be given the ftp password of the main website. It will contain many types of events, not just the standard Sunday service.

This database will be queried (read, used) in various pages in various ways:

• index.html to show all events of the next few weeks

• certain event types (or groups of types) to show all events of these types for as long ahead as known, e.g. Sunday service, Thursday service, everything else

Data Structure

Table "event"

e_id

long integer, primary (unique) key

e_et_id

integer, references evtype.et_id

e_datetime

float? date? What types are available in MySQL?
date and time

e_location

string(100) for a brief information about the location, perhaps enhanced by a link

e_speaker

string(100), Name of the speaker (if applicable)

e_topic

string (200), Topic of that day's event, e.g. topic and bible verses of the sermon

e_contact

string (200), name of the contact person; depending on local style, phone number and/or email address might be included.

Table "evtype"

et_id

integer, primary (unique) key

et_name

string(30), short but readable name of the event type, e.g. "Sunday service" or "Come - Prayer Night". Should fit in a user visible table column "event type"

et_short_desc

string (100), slightly longer description of the event type, e.g. "the family friendly worship service"

et_long_desc

memo, long description of the event type (1 or 2 paragraphs)

et_location

string(100), describing the location of the event, e.g. "ChristHaus/Cafe", or "various member's homes"

et_symbol_filename

string, containing the filename of a symbol, containing a tiny (should not enlarge the height of the line of a multi-type event calendar) logo of the event

et_background_color

string containing a colour definition (e.g. "#9999FF") that should be used for events of this type - should look nice together with the logo.

Home | Christian Missions | Christustreff Marburg | Pictures of Marburg | Job | Remote Communications | Linux OS | Psion page | Contact

Last updated: 05.05.2007 17:43:09 Martin Stut, email: , Marburg, Germany
URL: http://www.stut.de/eventdb.html