Bailey db tables Oct 07
Posted by sarneil on 05 Nov 2007 in Activity Log
- 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
