Define database schema

Registered by Tim Black on 2010-05-05

Define the database schema, building on PresbyterySite's tables, but adding flexible groupings of congregations (presbytery, classis, synod, denomination, church planting network, retreat/conference/camp, NAPARC, ICRC), external data sources & versioning.

Tables:

congregation
congregation_data
group
group_data
source

Infer the tables' fields from the data in the following & from PresbyterySite's database schema:

http://www.reformiert-online.net/weltweit/index.php?lg=eng
http://mountainretreatorg.net/churchit/churchit.html

NOTE: Once one milestone's needs are met by the database schema, move this blueprint to the next milestone.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Essential
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
Drafting
Series goal:
Accepted for couchapp-backbone
Implementation:
Unknown
Milestone target:
milestone icon 0.3

Related branches

Sprints

Whiteboard

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.