The current sql script for the database is attached here.
Web interface to do:
- Add physical location fields to web interface
- Reconcile form interface fields with database attributes - process files
- Slim code - figure out how to object orient and limit repetition, if this is possible?
- Clean in-line styling, tables to divs
- Link autocomplete value with database value for proper insertion
- Link each of these values & insert into activity_fact table
- Parameterize SQL queries to hinder SQL injection attacks
...