Specification for Projects

Field	Type	Length	Null	Properties
projectId	int	11	N	primary key, auto_increment
scope	enum(Open, Closed, Restricted)		N	default Open
name	varchar	50	N
title	varchar	50	N
description	text		N
dateCreated	datetime		N
dateStart	datetime		Y
dateEnd	datetime		Y
createdBy	varchar	50	N
status	enum(New, On Going, Completed, Closed)		N	default New
statusReason	varchar	255	N
active	enum(Y, N)		N

Preferred character set is UTF-8 to allow project properties to be defined in other scripts as well. The table type is considered to be transactional so the recommended choice would be InnoDB.

Scope

1. Open: An open project is visible, viewable and accessible to the public (registered members). They can also create new projects and define membership.
2. Closed: A closed project is visible, partially-viewable and not-accessible to the public. Only the defined coordinators and the members can access the project.
3. Restricted: A restricted project is not-visible, not-viewable and not-accessible to the public. Only the defined coordinators and members can view and access the project.

Participants

1. Coordinators:
   1. Initially the project creator will be the coordinator.
   2. There should be at least one coordinator at all times.
   3. A coordinator can leave the project only if there is another coordinator.
   4. If there is one coordinator, and if he wishes to leave, he can invite another coordinator and then leave.
   5. Coordinators have the privilege of managing expects of the project and defining project properties and goals.

1. Members:
   1. Members create and update actions.
   2. They can invite other new members.
   3. They cannot manage project properties.
   4. They can manage project goals, etc.

Progress

Progress is measured through the average completion progress of it’s actions. As more actions are added and updated, the average is calculated where necessary each time to be display.