Data Model

gistfile1.txt

Patients
  age - int
  intervention   (str, always IV tPA)
  patient id:     alpha num, 6 - 12 chars
  LSN             datetime
  Triage          datetime
  MRI             datetime
  treatment       datetime
  LSN-triage      int (minutes)
  LSN-MRI         int(minutes)
  LSN-treat       int(minutes)
  ethnic origin   string
  hispanic origin string
  sex             string or bool or whatever
  toast           string
  nhss_total      table
  Type 1 Int Code always 1    # these things are probably useful because the   
  Base DWI Eval   always 1    # people who were talking earlier said they were
  Base PWI Eval   -1, 0, 1
  nihss           table
                      2 hr
                      discharge
                      5 days
                      30 days 
                      90 days
  ranking score     table
                      pre
                      5 days
                      30 days
                      90 days
  Studies table
    timeline time     something in [pre, 2hr, discharge, 5 days, 30 days, 90 days]
    date              date
    time              time
    description       long string # but only a limited number of kinds of strings
                                  # ie MR BRAIN or MR FED STR BRAIN
    studyID           10 digit number
    series table
      number             4 digit number
      description        str (ie. DWI, TUMBLE)
      images             table
        number            long, long number
        pathname          url






Data Model for report
  author          string
  title           string             
  images          table
    order           int     #(what number in the series)
    notes           string  
    arrows and stuff if we let people
    arrows and stuff if we let people draw on them