Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. user_id INT(11) PRIMARY KEY AUTO_INCREMENT,
  2. user_name VARCHAR(45) NOT NULL,
  3. user_pass VARCHAR(255) NOT NULL,
  4. user_mail VARCHAR(100) NOT NULL,
  5. user_dpto VARCHAR(100) NOT NULL,
  6. user_resp BOOLEAN NOT NULL,
  7. token VARCHAR(100)
  8.  
  9. sol_id INT(11) PRIMARY KEY AUTO_INCREMENT,
  10. random_number INT(11) NOT NULL,
  11. asunto VARCHAR(45) NOT NULL,
  12. emision_date DATETIME NOT NULL,
  13. state VARCHAR(45) NOT NULL,
  14. state_date DATETIME NOT NULL,
  15. tercero BOOLEAN NOT NULL,
  16. nombre_tercero VARCHAR(100),
  17. fecha_solicitud_tercero DATE,
  18. fecha_limite DATE
  19.  
  20. user_id INT(11),
  21. sol_id INT(11),
  22. rol BOOLEAN,
  23. PRIMARY KEY (user_id, sol_id)
  24.  
  25. user_who_made_request|asunto|user_who_took_it|state|state_date
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement