Banco teste

-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Tempo de geração: 14-Jul-2021 às 06:12 -- Versão do servidor: 10.4.20-MariaDB -- versão do PHP: 7.3.29 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Banco de dados: `ehealth` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `tbconsultas` -- CREATE TABLE `tbconsultas` ( `consulta` int(11) NOT NULL, `medico_FK` int(11) NOT NULL, `paciente_FK` int(11) NOT NULL, `data` datetime NOT NULL, `prontuario` text COLLATE utf8_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Extraindo dados da tabela `tbconsultas` -- INSERT INTO `tbconsultas` (`consulta`, `medico_FK`, `paciente_FK`, `data`, `prontuario`) VALUES (1, 18, 34, '2021-07-10 10:00:00', NULL), (2, 4, 24, '2021-07-14 10:00:00', NULL), (3, 10, 11, '2021-07-02 10:00:00', NULL), (4, 16, 11, '2021-07-11 10:00:00', NULL), (5, 9, 5, '2021-07-12 10:00:00', NULL), (6, 11, 6, '2021-06-17 10:00:00', NULL), (7, 10, 9, '2021-06-05 10:00:00', NULL), (8, 17, 36, '2021-06-19 08:00:00', NULL), (9, 12, 8, '2021-06-03 08:00:00', NULL), (10, 18, 34, '2021-06-08 08:00:00', NULL), (11, 15, 22, '2021-05-07 08:00:00', NULL), (12, 20, 5, '2021-05-11 08:00:00', NULL), (13, 16, 31, '2021-05-09 08:00:00', NULL), (14, 11, 11, '2021-05-16 08:00:00', NULL), (15, 2, 23, '2021-06-17 08:00:00', NULL), (16, 17, 6, '2021-06-03 07:00:00', NULL), (17, 7, 16, '2021-06-11 07:00:00', NULL), (18, 6, 3, '2021-08-07 07:00:00', NULL), (19, 10, 20, '2021-08-16 07:00:00', NULL), (20, 4, 26, '2021-08-07 07:00:00', NULL), (21, 15, 8, '2021-09-11 07:00:00', NULL), (22, 16, 30, '2021-09-07 07:00:00', NULL), (23, 5, 13, '2021-09-13 07:00:00', NULL), (24, 19, 10, '2021-10-05 07:00:00', NULL), (25, 17, 9, '2021-10-08 14:00:00', NULL), (26, 14, 31, '2021-10-10 14:00:00', NULL), (27, 13, 15, '2021-10-13 14:00:00', NULL), (28, 19, 7, '2021-11-14 14:00:00', NULL), (29, 18, 30, '2021-11-05 14:00:00', NULL), (30, 8, 19, '2021-11-11 14:00:00', NULL), (31, 6, 24, '2021-12-12 14:00:00', NULL), (32, 3, 14, '2021-12-07 14:00:00', NULL), (33, 14, 6, '2021-12-04 16:00:00', NULL), (34, 19, 21, '2021-12-16 16:00:00', NULL), (35, 8, 14, '2021-05-10 16:00:00', NULL), (36, 4, 27, '2021-05-03 16:00:00', NULL), (37, 6, 12, '2021-05-07 16:00:00', NULL), (38, 13, 25, '2021-08-14 16:00:00', NULL), (39, 16, 20, '2021-09-04 16:00:00', NULL), (40, 13, 5, '2021-10-14 10:00:00', NULL), (41, 15, 8, '2021-10-05 07:00:00', NULL), (42, 16, 34, '2021-10-08 14:00:00', NULL), (43, 5, 22, '2021-10-10 14:00:00', NULL), (44, 19, 5, '2021-10-13 14:00:00', NULL), (45, 17, 31, '2021-11-14 14:00:00', NULL), (46, 14, 11, '2021-11-05 14:00:00', NULL), (47, 13, 23, '2021-11-11 14:00:00', NULL), (48, 19, 6, '2021-12-12 14:00:00', NULL), (49, 18, 16, '2021-12-07 14:00:00', NULL), (50, 8, 3, '2021-12-04 16:00:00', NULL), (51, 6, 20, '2021-05-11 08:00:00', NULL), (52, 3, 30, '2021-05-09 08:00:00', NULL), (53, 14, 19, '2021-05-16 08:00:00', NULL), (54, 19, 24, '2021-06-17 08:00:00', NULL), (55, 8, 14, '2021-06-03 07:00:00', NULL), (56, 4, 6, '2021-06-11 07:00:00', NULL), (57, 6, 21, '2021-08-07 07:00:00', NULL), (58, 13, 14, '2021-08-16 07:00:00', NULL), (59, 16, 27, '2021-10-05 07:00:00', NULL), (60, 13, 12, '2021-10-08 14:00:00', NULL); -- -------------------------------------------------------- -- -- Estrutura da tabela `tbespecialidades` -- CREATE TABLE `tbespecialidades` ( `especialidade` int(11) NOT NULL, `descricao` varchar(100) COLLATE utf8_bin NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Extraindo dados da tabela `tbespecialidades` -- INSERT INTO `tbespecialidades` (`especialidade`, `descricao`) VALUES (1, 'Clínica Médica'), (2, 'Cirurgia Geral'), (3, 'Pediatria'), (4, 'Ginecologia'), (5, 'Anestesiologia'), (6, 'Ortopedia'), (7, 'Oftalmologia'), (8, 'Cardiologia'), (9, 'Radiologia'), (10, 'Psiquiatria'), (11, 'Dermatologia'), (12, 'Otorrinolaringologia'), (13, 'Endocrinologia'), (14, 'Cirurgia Plástica'), (15, 'Infectologia'), (16, 'Cirurgia Vascular'), (17, 'Urologia'), (18, 'Cancerologia'), (19, 'Nefrologia'), (20, 'Neurologia'); -- -------------------------------------------------------- -- -- Estrutura da tabela `tbmedicos` -- CREATE TABLE `tbmedicos` ( `medico` int(11) NOT NULL, `nome` varchar(100) COLLATE utf8_bin NOT NULL, `CRM` varchar(20) COLLATE utf8_bin NOT NULL, `especialidade_FK` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Extraindo dados da tabela `tbmedicos` -- INSERT INTO `tbmedicos` (`medico`, `nome`, `CRM`, `especialidade_FK`) VALUES (1, 'Óscar Bento', '35643-AM', 4), (2, 'Tomás Bento', '99158-BA', 11), (3, 'Diego Varela', '90518-CE', 10), (4, 'Eduardo Bandeira', '32533-MG', 18), (5, 'Óscar Alves', '24544-PE', 16), (6, 'Xande Amaral', '98445-RJ', 12), (7, 'Viriato Mendes', '50916-SC', 10), (8, 'Toninho Martins', '26362-SP', 10), (9, 'Teófilo Pires', '93836-PR', 15), (10, 'Duarte Montenegro', '36918-DF', 11), (11, 'Natália Vasconcelos', '36187-AM', 13), (12, 'Micaela Silvestre', '20970-BA', 6), (13, 'Benedita Saldanha', '80250-CE', 7), (14, 'Cláudia Carvalho', '26050-MG', 5), (15, 'Luana Cordeiro', '43381-PE', 5), (16, 'Graça Pimentel', '56543-RJ', 17), (17, 'Rosalina Guerra', '25463-SC', 12), (18, 'Catarina Coutinho', '25876-SP', 10), (19, 'Paulina Leitão', '21105-PR', 5), (20, 'Julinha Florencio', '97577-SP', 3); -- -------------------------------------------------------- -- -- Estrutura da tabela `tbpacientes` -- CREATE TABLE `tbpacientes` ( `paciente` int(11) NOT NULL, `nome` varchar(100) COLLATE utf8_bin NOT NULL, `cpf` varchar(20) COLLATE utf8_bin NOT NULL, `idade` int(11) NOT NULL, `plano` int(11) NOT NULL, `data_cadastro` datetime NOT NULL, `data_alteracao` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Extraindo dados da tabela `tbpacientes` -- INSERT INTO `tbpacientes` (`paciente`, `nome`, `cpf`, `idade`, `plano`, `data_cadastro`, `data_alteracao`) VALUES (1, 'Diniz Pires', '514.894.163-91', 52, 1, '2021-07-10 10:00:00', NULL), (2, 'Nataniel Pascoal', '534.151.401-11', 41, 1, '2021-07-10 10:00:00', NULL), (3, 'António Pinho', '248.192.194-18', 51, 1, '2021-07-10 10:00:00', NULL), (4, 'Marcos Neves', '389.367.934-77', 41, 1, '2021-07-10 10:00:00', NULL), (5, 'Jônatas Batista', '754.409.244-83', 21, 0, '2021-07-10 10:00:00', NULL), (6, 'Danilo Luz', '161.548.261-57', 12, 0, '2021-07-10 10:00:00', NULL), (7, 'Maximiano Vomlel', '722.630.643-35', 42, 0, '2021-07-10 10:00:00', NULL), (8, 'Helder Luz', '431.451.354-79', 14, 0, '2021-07-10 10:00:00', NULL), (9, 'Caio Campos', '742.243.308-11', 37, 1, '2021-07-10 10:00:00', NULL), (10, 'Rafinha Mendez', '216.833.504-24', 59, 1, '2021-07-10 10:00:00', NULL), (11, 'Brunilda Alvim', '111.900.893-78', 47, 1, '2021-07-10 10:00:00', NULL), (12, 'Liana Albuquerque', '771.265.193-51', 38, 0, '2021-07-10 10:00:00', NULL), (13, 'Lena Menezes', '647.136.966-72', 60, 1, '2021-07-10 10:00:00', NULL), (14, 'Mara Águas', '670.363.514-99', 29, 0, '2021-07-10 10:00:00', NULL), (15, 'Eneida Rodrigues', '960.801.916-33', 17, 1, '2021-07-10 10:00:00', NULL), (16, 'Doroteia Mata', '707.782.266-47', 19, 0, '2021-07-10 10:00:00', NULL), (17, 'Madalena Garcia', '383.331.691-80', 12, 1, '2021-07-10 10:00:00', NULL), (18, 'Apolônia Gama', '971.587.464-95', 48, 0, '2021-07-10 10:00:00', NULL), (19, 'Débora Leitão', '154.969.486-29', 68, 1, '2021-07-10 10:00:00', NULL), (20, 'Carmo Braga', '696.253.894-82', 23, 0, '2021-07-10 10:00:00', NULL), (21, 'Reynaldo Câmara', '810.861.641-28', 63, 0, '2021-07-10 10:00:00', NULL), (22, 'Nelson Pereira', '313.275.441-61', 10, 1, '2021-07-10 10:00:00', NULL), (23, 'Eduardo Cerqueira', '144.260.364-34', 58, 1, '2021-07-10 10:00:00', NULL), (24, 'Telmo Seixas', '197.797.790-17', 20, 1, '2021-07-10 10:00:00', NULL), (25, 'Valério Ávila', '456.573.796-38', 49, 1, '2021-07-10 10:00:00', NULL), (26, 'Carlitos Rodrigues', '283.992.564-11', 30, 1, '2021-07-10 10:00:00', NULL), (27, 'Noah Moreira', '774.541.399-41', 8, 0, '2021-07-10 10:00:00', NULL), (28, 'Eduardo Peres', '606.458.415-57', 24, 0, '2021-07-10 10:00:00', NULL), (29, 'Lucas do Rosário', '650.746.404-47', 20, 1, '2021-07-10 10:00:00', NULL), (30, 'Norberto Barbosa', '703.983.506-40', 43, 0, '2021-07-10 10:00:00', NULL), (31, 'Luísa Barboza', '236.985.723-40', 28, 0, '2021-07-10 10:00:00', NULL), (32, 'Margarida Borges', '192.430.181-41', 35, 0, '2021-07-10 10:00:00', NULL), (33, 'Lucília Brandão', '777.353.845-12', 66, 0, '2021-07-10 10:00:00', NULL), (34, 'Benigna Almeida', '917.729.903-99', 8, 1, '2021-07-10 10:00:00', NULL), (35, 'Lucinda Serra', '488.559.482-96', 68, 0, '2021-07-10 10:00:00', NULL), (36, 'Sofia Saraiva', '586.924.742-72', 41, 0, '2021-07-10 10:00:00', NULL), (37, 'Irene Tomás', '597.424.576-81', 68, 1, '2021-07-10 10:00:00', NULL), (38, 'Luzia Azevedo', '963.594.987-21', 5, 1, '2021-07-10 10:00:00', NULL), (39, 'Rosa Serra', '170.863.962-23', 69, 1, '2021-07-10 10:00:00', NULL), (40, 'Lucinda Freitas', '415.273.994-91', 21, 1, '2021-07-10 10:00:00', NULL); -- -- Índices para tabelas despejadas -- -- -- Índices para tabela `tbconsultas` -- ALTER TABLE `tbconsultas` ADD PRIMARY KEY (`consulta`); -- -- Índices para tabela `tbespecialidades` -- ALTER TABLE `tbespecialidades` ADD PRIMARY KEY (`especialidade`); -- -- Índices para tabela `tbmedicos` -- ALTER TABLE `tbmedicos` ADD PRIMARY KEY (`medico`); -- -- Índices para tabela `tbpacientes` -- ALTER TABLE `tbpacientes` ADD PRIMARY KEY (`paciente`); -- -- AUTO_INCREMENT de tabelas despejadas -- -- -- AUTO_INCREMENT de tabela `tbconsultas` -- ALTER TABLE `tbconsultas` MODIFY `consulta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61; -- -- AUTO_INCREMENT de tabela `tbespecialidades` -- ALTER TABLE `tbespecialidades` MODIFY `especialidade` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT de tabela `tbmedicos` -- ALTER TABLE `tbmedicos` MODIFY `medico` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT de tabela `tbpacientes` -- ALTER TABLE `tbpacientes` MODIFY `paciente` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;