The current sql script for the database is attached here.
Web interface to do:
- Include location_dim table for city, state, country data in while loop in getautoname.php file
- Constrain issue data by value entered in series name form in source autocomplete files
- Slim code - figure out how to object orient and limit repetition, if this is possible?
- Finish autocomplete integration with rest of forms (letter is done)
- Link autocomplete value with database value for proper insertion
- Link each of these values & insert into activity_fact table
- Style forms
...
- Connect source_of_source table (as a "snowflake")
- Reverse engineer script to build diagram of database tables
- Include location_dim table for city, state, country data in while loop in getautoname.php file
As of 6/3/2015