The Data Owner column indicates who owns the data in the table. In some cases it is owned by the site, such as the actual information about a specific scout. In other cases it is owned by the system, such as each merit badge and it’s associated id. The schema of these tables are of course subject to change over time. The data will change depending on the data type. Some pieces of data must be tied to it’s unique id and therefore must remain constant. As the project is enhanced I would like to keep the system data ids and content unmodified even if they become obsolete. If the PHP files get modified and they have a dependency on a table entry that must be changed as well, there is an increased likelihood that sites who upgrade will miss the database change. The result will be a difficult bug to detect because there is data in the entry it is just incorrect. There may be some eloquent term to describe this in database ease but database management is not my expertise.

Tables	Description	Data Owner
accesslog	Time and ip addresses of remote clients accessing site.	Site
award	This is a list of all the awards. Right now this is just Merit badges. Someday it will hopefully include cubs, varsity, venture, etc.	System
award_type	This allows for future growth by allowing the creation of additional awards for cubs, varsity, venture etc.	System
calendars	This table contains calendar names and descriptions. There is multiple calendar support in ScoutTrak but no UI to add another calendar. To add another calendar you need to add another entry in this table. Once the entry exists the UI will allow editing and viewing.	Site
camp	This table contains campout names, dates, and descriptions.	Site
events	This is the list of events for the calendar.	Site
library	Conatins data for the merit badge or any library resources.	Site
mbcounselor	List of merit badge counselors with their phone numbers. NOTE: There is no UI for editing these entries yet.	Site
positions	Tracks the leadership positions held by a scout.	Site
requirements	This is a list of all the requirements.	System
scout	Scout information, i.e.. Name, Rank, Birthdate. Also flags for hiding from reports (paranoid parents) and marking as former scout	Site
scout_award	This is where the actual awards are recorded. It includes the scoutId the awardId and the date.	Site
scout_camp	This is where the actual campout attendance is recorded. It includes the scoutId, campoutid, and the duration the scout attended.	Site
scout_req	This is where the actual requirements are recorded. It includes the scout Id the requirement ID and the date.	Site
sys_user	User names and passwords.	Site