SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Databáze: `emgdb`, table `event`
-- v. 0.48:
DROP TABLE IF EXISTS `event`;
CREATE TABLE IF NOT EXISTS `event` ( # an event of the protocol
`inv` VARCHAR ( 3 ) NOT NULL, # investigation code, for example A, 2A etc.
`ltr` VARCHAR ( 1 ) NOT NULL, # sequential letter of the EMG record: A, B, C, ... etc.
`n` INT ( 6 ) NOT NULL, # sequential number of this event: 1, 2, ... etc.
# AUTO_INCREMENT,
`ev` INT ( 6 ) NULL, # event number in the GDF event table
`typ` INT ( 6 ) NULL, # event type in the GDF event table
`t1s` FLOAT (8,4) NULL, # starting timepoint [s]
`dts` FLOAT (8,4) NULL, # delta t = duration of this event [s]
`t2s` FLOAT (8,4) NULL, # ending timepoint = t1 + dt [s]
`t1` TIME NULL, # starting timepoint
`dt` TIME NULL, # delta t = duration of this event
`t2` TIME NULL, # ending timepoint = t1 + dt
`MB1` FLOAT (4,1) NULL, # amount of MB saved in the binary file (the value readed from the EMG display)
`MB2` FLOAT (4,1) NULL, # dtto – ending point
`ch` SET ('all','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20') NULL,
# the number of channel
`event` ENUM ( # what type of this event:
'record', # recording of EMG
'amplifier', # amplifier
'electrode', # some action with some/any electrode(s) (electrical aspect)
'needle', # mechanical aspect of the needle electrode(s): moving, pushing etc.
'press', # pressure on some point (stimulus on the remote TrP)
'motion', # some motion or another activity of the patient
'speech', # the patient is speaking
'disturbance', # some kind of disturbance of the investigation
'iritation', # some kind of iritation
'signal', # signal observed: some EMG activity (waves) occur etc.
'instruction', # instructions given to the patient
'breath', # controlled breathing
'quiet', # bedrest without any activity or disturbance
'position', # the position of the body etc.
'picture', # a picture (photo) taken
'mark', # marker (touching electrode atc.)
'calib', # calibration
'other' # other kind of event
) NULL,
`attr` VARCHAR (100) NULL, # some attribute of the event:
`side` ENUM ( # side of the action, laterality:
'sin', # l. sinister = the left side
'dx', # l. dexter = the rigth side
'bilat', # bilateral = both sides
'med', # medial = in the middle
'left', # moving, position of head etc.
'right'
) NULL,
`value` VARCHAR (10 ) NULL , # some quantification of the event: the value
`unit` ENUM ( # physical unit, for example:
'N', # physical force of the pressure [Newton],
'uV', # the amplitude of the EMG activity [microVolt]
'mV', # the amplitude of the EMG activity [milliVolt]
'uV/DIV', # the gain of the amplifier [microVolt/division]
'mV/DIV', # the gain of the amplifier [milliVolt/division]
'Hz', # the frequence [Herz]
'kHz', # the frequence [kiloHerz]
'mm', # the deep of the needle [millimeter]
's', # the period of controlled breathing [second] (for example: 15 s = 5+5+5)
# localtime
'CET', # Central European Time
'CEST', # Central European Summer Time: (last March Sun - last Oct Sun)
'alg' # pressure units on the algometer
) NULL,
`comment` VARCHAR( 1000 ) NULL , # some free comment to the event
# 15 columns total
PRIMARY KEY ( `inv`, `ltr`, `n` )
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 COMMENT = 'event occured in the time of EMG recording';
SHOW WARNINGS;
SELECT * FROM event;
SHOW WARNINGS;
SHOW TABLES;
SHOW WARNINGS;
