--
-- Table structure for table `subject`
--

CREATE TABLE subject (
  subID smallint(5) unsigned NOT NULL auto_increment,
  PPG varchar(20) default NULL,
  firstName varchar(100) default NULL,
  middleInitial char(1) default NULL,
  lastName varchar(100) default NULL,
  gender char(1) default NULL,
  birth date default NULL,
  education varchar(50) default NULL,
  brainLesion tinyint(1) default NULL,
  ethnicity varchar(50) default NULL,
  hearing varchar(50) default NULL,
  sight varchar(50) default NULL,
  handedness varchar(50) default NULL,
  subjectType varchar(50),
  subjectSubType varchar(50),
  comment blob,
  PRIMARY KEY  (subID)
) TYPE=MyISAM;


--
-- Table structure for table `sessionData`
--

CREATE TABLE sessionData (
  subID smallint(5) unsigned NOT NULL default '0',
  sessionID smallint(5) unsigned NOT NULL auto_increment,
  expDate date NOT NULL default '0000-00-00',
  experimenter varchar(100) NOT NULL default '',
  comment blob,
  expType varchar(100) NOT NULL default '',
  age smallint(5) unsigned default '0',
  timeStarted TIME,
  dataFile varchar(250),
  PRIMARY KEY  (sessionID)
) TYPE=MyISAM;

--
-- Table structure for table `heartmeasures`
--

CREATE TABLE heartmeasures (
  subID smallint(5) unsigned default NULL,
  sessionID smallint(5) unsigned default NULL,
  clipID varchar(50) default NULL,
  dataComment blob,
  heartRateMean double default NULL,
  heartRateStdDev double default NULL,
  RSAMean double default NULL,
  RSAStdDev double default NULL,
  RRMean double default NULL,
  RRStdDev double default NULL,
  comment blob,
  isValid tinyint(1) default NULL,
  RPeakList text,
  numRPeaks double default NULL,
  shortestBeat double default NULL,
  longestBeat double default NULL,
  RSAMin double default NULL,
  RSAMax double default NULL,
  RSACount double default NULL,
  RSAList text
) TYPE=MyISAM;

--
-- Table structure for table `respmeasures`
--

CREATE TABLE respmeasures (
  subID smallint(5) unsigned default NULL,
  sessionID smallint(5) unsigned default NULL,
  clipID varchar(50) default NULL,
  dataComment blob,
  totalBreathMean double default NULL,
  totalBreathStdDev double default NULL,
  inspTimeMean double default NULL,
  inspTimeStdDev double default NULL,
  expTimeMean double default NULL,
  expTimeStdDev double default NULL,
  postInspPauseMean double default NULL,
  postInspPauseStdDev double default NULL,
  postExpPauseMean double default NULL,
  postExpPauseStdDev double default NULL,
  inspDutyTimeMean double default NULL,
  inspDutyTimeStdDev double default NULL,
  respRateMean double default NULL,
  respRateStdDev double default NULL,
  comment blob,
  isValid tinyint(1) default NULL,
  peakPauseList text,
  troughPauseList text,
  peakList text,
  troughList text,
  numBreaths double default NULL,
  shortestBreath double default NULL,
  longestBreath double default NULL
) TYPE=MyISAM;

--
-- Table structure for table `comboboxes`
--

CREATE TABLE comboboxes (
  boxID varchar(20) NOT NULL default '',
  boxChoice varchar(50) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `comboboxes`
--

INSERT INTO comboboxes VALUES ('Education','unknown');
INSERT INTO comboboxes VALUES ('Experimenter','unknown');
INSERT INTO comboboxes VALUES ('Ethnicity','white');
INSERT INTO comboboxes VALUES ('Ethnicity','unknown');
INSERT INTO comboboxes VALUES ('Hearing','unknown');
INSERT INTO comboboxes VALUES ('Sight','unknown');
INSERT INTO comboboxes VALUES ('Handedness','unknown');
INSERT INTO comboboxes VALUES ('ExperimentType','unknown');
INSERT INTO comboboxes VALUES ('ExperimentType','Erica Sound Clips');
INSERT INTO comboboxes VALUES ('subjectSubType','not entered');
INSERT INTO comboboxes VALUES ('SubjectType','1 normal control');
INSERT INTO comboboxes VALUES ('SubjectType','2 b. amygdala');
INSERT INTO comboboxes VALUES ('SubjectType','3 left amygdala');
INSERT INTO comboboxes VALUES ('SubjectType','4 right amygdala');
INSERT INTO comboboxes VALUES ('SubjectType','5 VM prefrontal');
INSERT INTO comboboxes VALUES ('SubjectType','6 right hemisphere');
INSERT INTO comboboxes VALUES ('SubjectType','7 BD control');
INSERT INTO comboboxes VALUES ('SubjectType','8 excluded');

--
-- Table structure for table `calcekg`
--

CREATE TABLE calcekg (
  subID smallint(5) unsigned NOT NULL default '0',
  subType varchar(50) default NULL,
  gender char(1) default NULL,
  age smallint(5) unsigned default NULL,
  clip varchar(50) default NULL,
  RPeakList blob,
  RSAList blob
) TYPE=MyISAM;

--
-- Table structure for table `calcresp`
--

CREATE TABLE calcresp (
  subID smallint(5) unsigned NOT NULL default '0',
  subType varchar(50) default NULL,
  gender char(1) default NULL,
  age smallint(5) unsigned default NULL,
  clip varchar(50) default NULL,
  peakList blob,
  troughList blob,
  peakPauseList blob,
  troughPauseList blob
) TYPE=MyISAM;
