The current sql script for the database is attached here.

Web interface to do:

• fix issue (series) situation (for other than letters)

• Make guide for training (David)
• Add helpful hints - as HTML divs pulled in from HTML guide? (David)
• Autocomplete changes (for all autocomplete fields like person):
  • selected person, input box disappears, replaced by an non-editable box with selected person's info (and X in the corner which takes user back to blank input box in case they select the wrong person)
  • after creating a new person, have that person already selected (as above) when the person clicks out of the pop-up form
• Finish styling all detail pages (submit, Hello + Log Out header, etc)
• Clean in-line styling, tables to divs - page after submit - button to return to main form
• CSS for mobile (tablet, at least)
  
  

Database to do:

• Add John's office phys loc for training

• cron script for db backup/dumps (nightly (3am)) (append date/time in filename cobra_db_backup_20150909)

• Finish data dictionary explaining each entity and attribute, and ER diagram to reflect
• Add triggers for modifications into audit table
  
• Change to real NULL on db for values that are blank
  • Query builder based on non-empty fields?

Fall 2015 major to dos:

• hire people - work with them to input data - add them as DB users
• Usability tests with form & input - make sure everything is inserting into the db correctly and form is intuitive
• Input spreadsheet data - does Will have suggestions for this automatically or would it be easier to put people on the case?
• Connect source_dim to GCD and location_dim to Getty
• Data entry for DVDs and Michigan images
• Data analysis - quantitative & qualitative (narrative abt interesting letters)
• Apply for grants:
  • Collab Research - due Dec 9th 2015 --> arrange meeting with collaborators
  • DH Implementation - due Feb 17, 2016
  • Community/Public... - due June 2016
  • Humanities Collections & Reference Resources - due July 2016
    
    

Done:

• 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
• Constrain issue data by value entered in series name form in source autocomplete files
• Finish autocomplete integration in all forms
• Add page number to source table (if from an issue)
• Style forms
• make basic ER Diagram for San Diego
• Fix nested form issue
• Reconcile form interface fields with database attributes - process files
• Added mutable attribute tables to SQL script, models
• Reconcile "mutable" fields to new tables
• Add physical location fields to web interface
• Link autocomplete value (person, location, source, physical location) with database value, insert into activity_fact as one new record, with activity
• Object orient forms & processes 
• Parameterize SQL queries to hinder SQL injection attacks
• Change "create new" links to buttons
• Parameterize autocompletes
• Reconcile Issue Autocomplete bug (issue_number search works but not pub_date search...weird)
• Add fields to physical location - end up separating this from location?? YES! Became new table connected to both location_dim and activity_fact
  • Collection name
  • Collection ID number
  • repository (ex. Bodlein Library)
  • institution (ex. U of Oxford)
    (we decide how to insert private collections)
• Add note field to letter & review (look at Richard's "notes" in spreadsheet)
• Upon main form submission, return to index.php
• Delete sex & gender mutable tables, replace with m_f and gender_note attributes in person_dim table
• Add password protection - connect to DB in config file (as parameters)
• Add created insert statements from members table (into one audit table)
• Link everything to one config file
• Add php secure permission to currently html forms

As of 8/31/2015