a guest Sep 20th, 2017 114 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE ConfigNeglet (
  2. IDPaciente VARCHAR(10) NOT NULL,
  3. fechaActivacion DATE NOT NULL,
  4. ejercicio NUMBER(1) NOT NULL,
  5. fechaEmision DATE NOT NULL,
  6. transparenciaCuadrante NUMBER(3) NOT NULL,
  7. tipoFigura NUMBER(1) NOT NULL,
  8. tamanioTarget NUMBER(1) NOT NULL,
  9. backgroundColor VARCHAR(7) NOT NULL,
  10. tiempoExposicion NUMBER(3) NOT NULL,
  11. tiempoAparicion  NUMBER(1) NOT NULL,
  12. velocidadTrayectoriaTarget NUMBER(1) NOT NULL,
  13. cantElementosDistractores NUMBER(2) NOT NULL,
  14. tamanioElementosDistractores NUMBER(1) NOT NULL,
  15. vTrayectElementosDistractores NUMBER(1) NOT NULL,
  16. cantRepeticionFrase NUMBER(2) NOT NULL,
  17. delayFrase NUMBER(1) NOT NULL,
  18. controlInhibitorioMotor NUMBER(1) NOT NULL,
  19. tiempoEjercicio NUMBER(3) NOT NULL,
  20. PRIMARY KEY (IDPaciente, fechaActivacion,ejercicio)
  21. );
  23. CREATE TABLE ResultsNeglet (
  24. IDPaciente VARCHAR(10) NOT NULL,
  26. ejercicio NUMBER(2) NOT NULL,
  27. fechaInicio TIMESTAMP NOT NULL,
  28. cantItems NUMBER(4) NOT NULL,
  29. cantClicks NUMBER(4) NOT NULL,
  30. cantAciertos NUMBER(4) NOT NULL,
  31. c1 NUMBER(3)    NOT NULL,
  32. c2 NUMBER(3) NOT NULL,
  33. c3 NUMBER(3) NOT NULL,
  34. c4 NUMBER(3) NOT NULL,
  35. PRIMARY KEY (IDPaciente, Fecha)
  36. );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand