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

horizontal rule in rainbow colours (2,1 kB)

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:

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.

horizontal rule in rainbow colours (2,1 kB)

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: email address as image, Marburg, Germany
URL: http://www.stut.de/eventdb.html