text: CREATE TABLE `doctor` (
    `iddoc` int(11) NOT NULL AUTO_INCREMENT,
    `nombre` varchar(80) NOT NULL,
    `apellidos` varchar(150) NOT NULL,
    `username` varchar(30) NOT NULL,
    `email` varchar(150) NOT NULL,
    `passwd` varchar(150) NOT NULL,
    `fecnac` varchar(20) NOT NULL,
    `sexo` varchar(12) NOT NULL,
    `direccion` varchar(200) DEFAULT NULL,
    `departamento` varchar(20) DEFAULT NULL,
    `provincia` varchar(30) DEFAULT NULL,
    `distrito` varchar(30) DEFAULT NULL,
    `profesion` varchar(100) NOT NULL,
    `telefono` varchar(40) NOT NULL,
    `avatar` varchar(200) NOT NULL,
    `biografica` text NOT NULL,
    `status` tinyint(1) DEFAULT NULL,
    `fecCreate` datetime DEFAULT NULL,
    PRIMARY KEY (`iddoc`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  