Uživatel:Kychot/emgdb event stru.sql

Z Wikiverzity
Skočit na navigaci Skočit na vyhledávání
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;