SDD Persistent Data Management

From Cef

Jump to: navigation, search

The system will use the MySQL database engine for storing data. This will allow the database to be easily integrated with and accessed by the rest of the system.

The database will retain user information (name, email address, school, etc.), event postings, forum postings, advertisements, and configuration data such as authorized schools and recognized advertisers. Each of these items will be a separate table. Whenever possible, the data itself will be used as a primary key - in the case of the user information table, the combination of first name, last name and email address would be unique to each user. An individual could not have more than one user account, so the person's user name would not need to be considered.When this method is not possible, a unique number will be assigned to each row of data.

Personal tools