Reviewed table structure developed at end of September with Clifton. Also applied to sys admin for mysql database for the project. Once I've got the empty db going, I'll contact Simon to get tab-delimited data files to work with.

• Accused
• • one record for every individual, so slightly fewer records than the number of trials, as a small number of individuals will be involved in more than one trial
  • accused_id (primary key)
  • surname
  • given name
  • gender
  • age
• AKA
• • one record for every instance of an alias name, the same aka name may point to different accuseds and one accused may have more than one AKA
  • aka_id (primary key)
  • name
  • accused_id
• Trial
• • one record for every trial
  • trial_id (primary key)
  • case_number (used to link trials together where individuals were tried together)
  • sources
  • notes
  • trial_date_start
  • trial_date_end
  • Jury
  • accused_id_fk
  • respited (a Boolean indicator for the respited larcenies)
• Recorder_report
• • ?one record for every trial
  • recorder_report_id (primary key)
  • report_text
  • footnote
  • trial_id_fk
• Crime
• • one record for every charge, total slightly higher than number of trials as some trials included 2+ charges
  • crime_id (primary key)
  • crime_description
  • crime_details
  • trial_id_fk
• Respite_sentence
• • one record for every respite of sentence, total slightly higher than number of trials as some trials included 2+ respites
  • respite_id (primary key)
  • respite_decision
  • trial_id_fk
• Outcome
• • one record for every trial OR one record for every outcome, total slightly higher than number of trials as some trials included 2+ outcomes
  • outcome_id (primary key)
  • type (execution, pardon, died, other)
  • date
  • description
  • location
  • further_notes
  • reference
  • trial _id_fk