Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- user_id INT(11) PRIMARY KEY AUTO_INCREMENT,
- user_name VARCHAR(45) NOT NULL,
- user_pass VARCHAR(255) NOT NULL,
- user_mail VARCHAR(100) NOT NULL,
- user_dpto VARCHAR(100) NOT NULL,
- user_resp BOOLEAN NOT NULL,
- token VARCHAR(100)
- sol_id INT(11) PRIMARY KEY AUTO_INCREMENT,
- random_number INT(11) NOT NULL,
- asunto VARCHAR(45) NOT NULL,
- emision_date DATETIME NOT NULL,
- state VARCHAR(45) NOT NULL,
- state_date DATETIME NOT NULL,
- tercero BOOLEAN NOT NULL,
- nombre_tercero VARCHAR(100),
- fecha_solicitud_tercero DATE,
- fecha_limite DATE
- user_id INT(11),
- sol_id INT(11),
- rol BOOLEAN,
- PRIMARY KEY (user_id, sol_id)
- user_who_made_request|asunto|user_who_took_it|state|state_date
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement