Guest User

Untitled

a guest
Sep 20th, 2017
137
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. );
  22.  
  23. CREATE TABLE ResultsNeglet (
  24. IDPaciente VARCHAR(10) NOT NULL,
  25. fecha TIMESTAMP 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