-- phpMyAdmin SQL Dump
-- version 4.7.7
-- https://www.phpmyadmin.net/
--
-- Host: mindmatters.mysql.dbaas.com.br
-- Generation Time: 15-Dez-2023 às 08:18
-- Versão do servidor: 5.7.32-35-log
-- PHP Version: 5.6.40-0+deb8u12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 */;

--
-- Database: `mindmatters`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `agendamento`
--

CREATE TABLE `agendamento` (
  `id_agendamento` int(11) NOT NULL,
  `data` datetime NOT NULL,
  `usuario` int(11) NOT NULL,
  `profissional` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `endereco`
--

CREATE TABLE `endereco` (
  `id_endereco` int(11) NOT NULL,
  `cep` varchar(9) COLLATE latin1_general_ci NOT NULL,
  `rua` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `bairro` varchar(60) COLLATE latin1_general_ci NOT NULL,
  `numero` int(5) NOT NULL,
  `complemento` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `cidade` varchar(40) COLLATE latin1_general_ci NOT NULL,
  `uf` varchar(2) COLLATE latin1_general_ci NOT NULL,
  `pessoa` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `endereco`
--

INSERT INTO `endereco` (`id_endereco`, `cep`, `rua`, `bairro`, `numero`, `complemento`, `cidade`, `uf`, `pessoa`) VALUES
(2, '', '', '', 0, '', '', '', 47),
(3, '', '', '', 0, '', '', '', 65),
(4, '12345-678', 'Rua tal', '', 0, '', 'Cidade', 'SP', 74),
(5, '12345-678', '', 'Bairro', 0, '', '', '', 75),
(6, '18400-400', 'Rua ', 'Bairro', 0, '', 'Itapeva', 'SP', 76),
(7, '', '', '', 0, '', '', '', 77),
(8, '18440-440', '', '', 0, '', 'Itaporanga', 'SP', 78),
(9, '18403-215', 'Rua Amador Batista Rosa', 'Conjunto Habitacional Jardim Vitória', 283, '', 'Itapeva', 'SP', 79),
(10, '18406-190', 'Rua Pedro Pivovar', 'Parque Residencial Itapeva', 225, '', 'Itapeva', 'SP', 80),
(11, '18400-400', '', '', 0, '', 'Itapeva', 'SP', 81),
(12, '', '', 'Bela Vista', 0, '', '', 'SP', 82),
(13, '', '', '', 0, 'Sobrado', 'Itapeva', 'SP', 83),
(14, '', '', '', 0, '', '', '', 84),
(15, '', '', '', 0, '', '', '', 87),
(16, '', '', '', 0, '', '', '', 94);

-- --------------------------------------------------------

--
-- Estrutura da tabela `endereco_clinica`
--

CREATE TABLE `endereco_clinica` (
  `id_clinica` int(11) NOT NULL,
  `nome_clinica` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `endereco` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `ficha_usuario`
--

CREATE TABLE `ficha_usuario` (
  `id_ficha` int(11) NOT NULL,
  `nome_completo` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `sexo` enum('Feminino','Masculino') COLLATE latin1_general_ci DEFAULT NULL,
  `cpf` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `nome_mae` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `naturalidade` varchar(150) COLLATE latin1_general_ci DEFAULT NULL,
  `usuario` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `ficha_usuario`
--

INSERT INTO `ficha_usuario` (`id_ficha`, `nome_completo`, `sexo`, `cpf`, `nome_mae`, `naturalidade`, `usuario`) VALUES
(1, 'Paula Machado Silva', NULL, '65746389935', NULL, NULL, 1),
(3, 'maria', NULL, '51474821804', NULL, NULL, 3),
(6, 'maria julia', NULL, '38502466801', NULL, NULL, 6),
(7, 'anaaaa', NULL, '51780713878', NULL, NULL, 7),
(8, 'Antunes Pontes da Costa', NULL, '58374837890', NULL, NULL, 8),
(9, 'Alana Prado proença', NULL, '58274838983', NULL, NULL, 11),
(10, 'Andreia Almeida', NULL, '', NULL, NULL, 14),
(11, 'Aquiles Felizardo', NULL, '', NULL, NULL, 15),
(12, 'Ana Julia', NULL, '', NULL, NULL, 16),
(13, 'Felipe Albuquerque', NULL, '', NULL, NULL, 17),
(14, 'Maria Joana', NULL, '', NULL, NULL, 18),
(15, 'Juliana', NULL, '', NULL, NULL, 19),
(16, 'Isabele Lima', NULL, '', NULL, NULL, 20),
(17, 'Maria Rodrigues', NULL, '', NULL, NULL, 21),
(18, 'eduardo', NULL, '', NULL, NULL, 22),
(19, 'Alberto Santos', NULL, '', NULL, NULL, 23),
(20, 'Mariana Ferreira', NULL, '', NULL, NULL, 24),
(21, 'Amelia Ramos', NULL, '', NULL, NULL, 25),
(22, 'Maria Benfica', NULL, '', NULL, NULL, 26),
(23, 'Lais lopes', NULL, '', NULL, NULL, 27),
(24, 'Marcos Paiva', NULL, '', NULL, NULL, 28),
(25, 'Marcos Paiva', NULL, '', NULL, NULL, 29),
(26, 'Eliane Camargo', NULL, '', NULL, NULL, 30),
(27, 'Rosangela Santiago Das Neves', NULL, '', NULL, NULL, 31),
(28, 'ALBERT FERREIRA GOMES', NULL, '', NULL, NULL, 32),
(29, 'Albert Ferreira', NULL, '', NULL, NULL, 33),
(30, 'Não Lais Lopes', NULL, '', NULL, NULL, 34),
(31, 'Nunes Andrade Leite', NULL, '', NULL, NULL, 35),
(32, 'Amanda Mello', NULL, '', NULL, NULL, 36),
(33, 'Isabela Lima', NULL, '', NULL, NULL, 37),
(34, 'Amora Gomes', NULL, '', NULL, NULL, 38),
(35, 'Maria Clara Santos', NULL, '', NULL, NULL, 39),
(36, 'Amanda Mello ', NULL, '', NULL, NULL, 40),
(37, 'Ageu Batista da Cruz', NULL, '', NULL, NULL, 41),
(38, 'Eliana Almeida', NULL, '', NULL, NULL, 42),
(39, 'Alzira Barros Cabral', NULL, '', NULL, NULL, 43),
(40, 'Vanderlei Silva', NULL, '', NULL, NULL, 44),
(41, 'Ruas Farias', NULL, '', NULL, NULL, 45),
(42, 'Karina Silva Dias', NULL, '', NULL, NULL, 46),
(43, 'Maria Joana Gonçalves filho', NULL, '', NULL, NULL, 47),
(44, 'Eliane Primeira', NULL, '', NULL, NULL, 48),
(45, 'Maria Jardim', NULL, '', NULL, NULL, 49),
(46, 'Cristiano Figueira', NULL, '', NULL, NULL, 50),
(47, 'John Smith', NULL, '', NULL, NULL, 51),
(48, 'Simone Gomes', NULL, '', NULL, NULL, 52),
(49, 'Luiz Pedro', NULL, '', NULL, NULL, 53),
(50, 'Maya Clarice Rayssa Carvalho', NULL, '', NULL, NULL, 54),
(51, 'Rita de Cássia', NULL, '', NULL, NULL, 55),
(52, 'Carla Matos Silva ', NULL, '', NULL, NULL, 56),
(53, 'Antonio Nunes', NULL, '', NULL, NULL, 57),
(54, 'Juliana Figueira Oliveira', NULL, '', NULL, NULL, 58),
(55, 'Luan Santana', NULL, '', NULL, NULL, 59),
(56, 'Maria Lima', NULL, '', NULL, NULL, 60),
(57, 'Maria Verneque', NULL, '', NULL, NULL, 61),
(58, 'Juliano Alberto', NULL, '', NULL, NULL, 62),
(59, 'Paola Camargo Nunes', NULL, '', NULL, NULL, 63),
(60, 'Karine Ramos Pinheiro', NULL, '', NULL, NULL, 64),
(61, 'Rita', NULL, '', NULL, NULL, 65);

-- --------------------------------------------------------

--
-- Estrutura da tabela `login_profissional`
--

CREATE TABLE `login_profissional` (
  `id_login` int(11) NOT NULL,
  `username` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(40) COLLATE latin1_general_ci NOT NULL,
  `senha` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `profissional` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `login_profissional`
--

INSERT INTO `login_profissional` (`id_login`, `username`, `email`, `senha`, `profissional`) VALUES
(1, 'Anthony Gabriel', 'anthonymiller90@hotmail.com', 'millergabriel90', 1),
(2, 'Davi Luccas', 'daviLuccas761@gmail.com', 'arvore761', 2),
(3, '', 'cristiane@gmail.com', '12345678', 3),
(4, '', 'elias@gmail.com', '12345678', 4),
(5, '', 'laislopes1@gmail.com', '12345678', 5),
(6, '', 'heloisa_salvatore@gmail.com', '12345678', 6),
(7, '', 'claudiapsi@gmail.com', 'claudiapsi@euu', 7),
(8, '', 'elaine_primeira@gmail.com', '12345678', 8),
(9, '', 'elaine_segunda@gmail.com', '12345678', 9),
(10, '', 'joaquim_emanuel@gmail.com', '12345678', 10),
(11, '', 'carmen_cruz@gmail.com', '12345678', 11),
(12, '', 'carmen_oliveira@gmail.com', '12345678', 12),
(13, '', 'rita1@gmail.com', '12345678', 13),
(14, '', 'rita123@gmail.com', '1234', 14),
(15, '', 'andersonnpsi@gmail.com', 'andersoneu', 15),
(16, '', 'marioalmeida@gmail.com', '9874125630', 16),
(17, '', 'marcos123@gmail.com', '12345', 17);

-- --------------------------------------------------------

--
-- Estrutura da tabela `noticias_favoritas`
--

CREATE TABLE `noticias_favoritas` (
  `id_usuario` int(11) NOT NULL,
  `id_noticia` varchar(50) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `noticias_favoritas`
--

INSERT INTO `noticias_favoritas` (`id_usuario`, `id_noticia`) VALUES
(6, '59adca1d-a3cf-4f57-b467-8589e662111b'),
(7, '2ad92dac-ad00-4ea2-942e-e320f2cbf2c4'),
(7, '8b967e42-01a5-43c8-80d8-a9e42172b9ac'),
(7, '75bb4541-4943-46b3-9fdc-97d932b2b311'),
(7, '5c131f32-341a-4700-a73a-0abbb6c1d307'),
(11, '75bb4541-4943-46b3-9fdc-97d932b2b311'),
(11, '5c131f32-341a-4700-a73a-0abbb6c1d307'),
(11, 'a89c65eb-9eef-466b-8788-8c74813fe5fb'),
(3, '2ad92dac-ad00-4ea2-942e-e320f2cbf2c4'),
(3, '08c1582d-baaf-4148-99d1-e27892d8a59b'),
(31, '2ad92dac-ad00-4ea2-942e-e320f2cbf2c4'),
(31, '08c1582d-baaf-4148-99d1-e27892d8a59b'),
(35, '75bb4541-4943-46b3-9fdc-97d932b2b311'),
(35, '2ad92dac-ad00-4ea2-942e-e320f2cbf2c4'),
(39, '2ad92dac-ad00-4ea2-942e-e320f2cbf2c4'),
(40, '75bb4541-4943-46b3-9fdc-97d932b2b311'),
(41, '2ad92dac-ad00-4ea2-942e-e320f2cbf2c4'),
(41, '08c1582d-baaf-4148-99d1-e27892d8a59b'),
(46, '2ad92dac-ad00-4ea2-942e-e320f2cbf2c4'),
(46, '87e4c9d7-8352-44b5-9e44-9bb29e974356'),
(46, '60823d6e-0496-43a4-8ace-8102be4f8a7f'),
(47, '2ad92dac-ad00-4ea2-942e-e320f2cbf2c4'),
(47, '8b967e42-01a5-43c8-80d8-a9e42172b9ac'),
(47, '75bb4541-4943-46b3-9fdc-97d932b2b311'),
(44, '2ad92dac-ad00-4ea2-942e-e320f2cbf2c4'),
(49, '5c131f32-341a-4700-a73a-0abbb6c1d307'),
(50, '5c131f32-341a-4700-a73a-0abbb6c1d307'),
(54, '75bb4541-4943-46b3-9fdc-97d932b2b311'),
(54, '5c131f32-341a-4700-a73a-0abbb6c1d307'),
(54, 'ba72aecf-82e8-45c7-91ce-83a9e1cc4103'),
(54, '60823d6e-0496-43a4-8ace-8102be4f8a7f'),
(53, '59adca1d-a3cf-4f57-b467-8589e662111b'),
(53, '08c1582d-baaf-4148-99d1-e27892d8a59b'),
(54, '59adca1d-a3cf-4f57-b467-8589e662111b'),
(25, '75bb4541-4943-46b3-9fdc-97d932b2b311'),
(64, '5c131f32-341a-4700-a73a-0abbb6c1d307');

-- --------------------------------------------------------

--
-- Estrutura da tabela `pessoa`
--

CREATE TABLE `pessoa` (
  `id_pessoa` int(11) NOT NULL,
  `nome` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `dataNasc` date DEFAULT NULL,
  `tipo` enum('Profissional','Usuário') COLLATE latin1_general_ci NOT NULL,
  `telefone` varchar(16) COLLATE latin1_general_ci DEFAULT NULL,
  `email` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `senha` varchar(100) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `pessoa`
--

INSERT INTO `pessoa` (`id_pessoa`, `nome`, `dataNasc`, `tipo`, `telefone`, `email`, `senha`) VALUES
(1, 'Paula Machado Silva', '2000-07-04', 'Usuário', NULL, '', ''),
(2, 'Ana Maria Braga', '1970-05-04', 'Usuário', NULL, '', ''),
(3, 'maria', '2005-12-05', 'Usuário', NULL, '', ''),
(6, 'maria julia', '2006-12-02', 'Usuário', NULL, '', ''),
(7, 'anaaaa', '2005-02-10', 'Usuário', NULL, '', ''),
(8, '	Anthony Gabriel Miller', NULL, 'Profissional', '(15) 99654-3200', '', ''),
(9, 'Davi Luccas Dias', NULL, 'Profissional', '(21) 99109-6544', '', ''),
(10, 'Antunes Pontes da Costa', '1989-04-08', 'Usuário', NULL, '', ''),
(27, 'Alana Prado proença', '2023-11-24', 'Usuário', NULL, '', ''),
(30, 'Andreia Almeida', '2005-12-05', 'Usuário', '1599564-2635', '', ''),
(31, 'Aquiles Felizardo', '2001-03-05', 'Usuário', '1599564-4512', '', ''),
(32, 'Ana Julia', '2003-04-02', 'Usuário', '1599745-3265', 'anajulia@gmail.com', 'anajulia@1234'),
(33, 'Felipe Albuquerque', '1999-01-02', 'Usuário', '1599632-4512', 'felipe123456@gmail.com', 'felipe@3546'),
(34, 'Maria Joana', '1990-03-02', 'Usuário', '1599851-7465', 'mariajoana@gmail.com', 'maria@45123669'),
(35, 'Juliana', '2006-12-06', 'Usuário', '1599632-1245', 'juliana@gmail.com', 'juliana@4512'),
(36, 'Isabele Lima', '2001-12-06', 'Usuário', '1599421-4651', 'isabele@gmail.com', 'isabele@123'),
(37, 'Maria Rodrigues', '2005-05-04', 'Usuário', '1599632-7458', 'mariarodrigues@gmail.com', 'mariarodrigues19@'),
(38, 'eduardo', '2005-03-09', 'Usuário', '1599841-4526', 'eduardo@gmail.com', 'eduardo@'),
(39, 'Alberto Santos', '2003-12-06', 'Usuário', '15996547896', 'albertosantos@gmail.com', 'alberto12345'),
(40, 'Mariana Ferreira', '1999-07-08', 'Usuário', '15996358741', 'marianaferreira@gmail.com', 'marianaferreira'),
(41, 'Amelia Ramos', '2001-08-04', 'Usuário', '15998741256', 'amelia@gmail.com', 'amelia12345'),
(42, 'Maria Benfica', '2002-10-10', 'Usuário', '15996325874', 'mariabenfica@gmail.com', 'maria12345'),
(43, 'Lais lopes', '2005-05-05', 'Usuário', '15995641235', 'laislopes@gmail.com', 'lais12345@'),
(44, 'Marcos Paiva', '2002-02-02', 'Usuário', '15996253252', 'marcosp@gmail.com', 'marcos12345@'),
(45, 'Marcos Paiva', '2002-02-02', 'Usuário', '15996253252', 'marcosp@gmail.com', 'marcos12345@'),
(46, 'Cristiane Souza', NULL, 'Profissional', '15998776655', '', ''),
(47, 'Eliane Camargo', '1987-11-18', 'Usuário', '11998776655', 'eliane@gmail.com', ''),
(48, 'Rosangela Santiago Das Neves', '1972-01-18', 'Usuário', '15996095148', 'rosangelasantiagoneves@gmail.com', 'duduneves'),
(49, 'ALBERT FERREIRA GOMES', '2005-12-05', 'Usuário', '15998193067', 'albertgomes888@gmail.com', '3132,,5@'),
(50, 'Elias Miguel', NULL, 'Profissional', '15998776655', '', ''),
(51, 'Albert Ferreira', '2005-08-03', 'Usuário', '15998541702', 'albertferreira@gmail.com', '123456789'),
(52, 'Lais Lopes', NULL, 'Profissional', '15 998776655', '', ''),
(53, 'Não Lais Lopes', '2023-11-05', 'Usuário', '12123123123', 'laislopes2@gmail.com', '12345678'),
(54, 'Nunes Andrade Leite', '1998-04-03', 'Usuário', '15998764536', 'NunesssLeitaoo@gmaio.com', 'leitenunes'),
(55, 'Amanda Mello', '2005-05-05', 'Usuário', '15998564713', 'amandamello@gmail.com', '125364789'),
(56, 'Isabela Lima', '1998-12-03', 'Usuário', '15992540125', 'isabelalima@gmail.com', '125643987'),
(57, 'Amora Gomes', '1997-10-10', 'Usuário', '15995471256', 'amora@gmail.com', '123456987'),
(58, 'Maria Clara Santos', '1993-03-09', 'Usuário', '15993674890', 'maria@gmail.com', 'maria23'),
(59, 'Amanda Mello ', '2005-05-05', 'Usuário', '15998652147', 'amandamello123@gmail.com', 'amanda12345'),
(60, 'Ageu Batista da Cruz', '1975-12-18', 'Usuário', '15997235794', 'ageubatistacruzz@gmail.com', 'argelinobaitaca'),
(61, 'Eliana Almeida', '2006-07-09', 'Usuário', '15996523112', 'eliana@gmail.com', '123456789'),
(62, 'Alzira Barros Cabral', '1979-02-08', 'Usuário', '15997456378', 'alzirabarrosetec@gmail.com', 'alzirinhadograu'),
(63, 'Vanderlei Silva', '1980-03-03', 'Usuário', '15996587415', 'vanderlei@gmail.com', 'vanderlei123@'),
(64, 'Ruas Farias', '2005-12-30', 'Usuário', '15 998776655', 'ruan_farias@gmail.com', '12345678'),
(65, 'Heloísa Salvatore', NULL, 'Profissional', '15 998776655', 'heloisa_salvatore@gmail.com', '12345678'),
(66, 'Karina Silva Dias', '2004-03-02', 'Usuário', '15992783678', 'karinaeu@gmail.com', 'kahsilva'),
(67, 'Maria Joana Gonçalves filho', '2003-12-07', 'Usuário', '(15)997467846', 'joanaa@gmail.com', 'joaninha'),
(68, 'Cláudia Santos Moreira', NULL, 'Profissional', '(15)996473890', '', ''),
(69, 'Eliane Primeira', '2000-12-11', 'Usuário', '12 998121212', 'eliane_primeira@gmail.com', '12345678'),
(70, 'Elaine Primeira', NULL, 'Profissional', '15 998151515', 'elaine_primeira@gmail.com', '12345678'),
(71, 'Elaine Segunda', NULL, 'Profissional', '12 998121212', 'elaine_segunda@gmail.com', '12345678'),
(72, 'Maria Jardim', '2003-12-03', 'Usuário', '15998254712', 'mariajardim@gmail.com', '123456789'),
(73, 'Cristiano Figueira', '2001-10-10', 'Usuário', '15995684585', 'cristiano@gmail.com', '123654789'),
(74, 'Joaquim Emanuel', NULL, 'Profissional', '16 9916161616', 'joaquim_emanuel@gmail.com', '12345678'),
(75, 'John Smith', '2000-12-10', 'Usuário', '15 9915151515', 'john_smith@gmail.com', '1234'),
(76, 'Simone Gomes', '2000-12-22', 'Usuário', '12345678910', 'simone_gomes@gmail.com', ''),
(77, 'Luiz Pedro', '2000-12-18', 'Usuário', '15 998776655', 'luiz_pedro@gmail.com', '1234'),
(78, 'Carmen Cruz', NULL, 'Profissional', '15 999777666', 'carmen_cruz@gmail.com', '12345678'),
(79, 'Maya Clarice Rayssa Carvalho', '2003-12-15', 'Usuário', '(15) 98275-7980', 'maya_clarice@gmail.com', '12345678'),
(80, 'Carmen Oliveira', NULL, 'Profissional', '15 99888777', 'carmen_oliveira@gmail.com', '12345678'),
(81, 'Rita de Cássia', '2000-12-04', 'Usuário', '15 998776655', 'rita@gmail.com', '1234'),
(82, 'Rita de Cássia', NULL, 'Profissional', '15 998776655', 'rita1@gmail.com', '12345678'),
(83, 'Rita de Cássia', NULL, 'Profissional', '15 998776655', 'rita123@gmail.com', '1234'),
(84, 'Carla Matos Silva ', '2002-12-19', 'Usuário', '15996374878', 'carlasilvaa@gmail.com', 'eucarla'),
(85, 'Antonio Nunes', '2004-08-08', 'Usuário', '15992583697', 'antonio@gmail.com', '123654789'),
(86, 'Juliana Figueira Oliveira', '2001-08-04', 'Usuário', '15998574528', 'julianaferreira@gmail.com', 'juliana123'),
(87, 'Anderson Santos Silva', NULL, 'Profissional', '15996374867', 'andersonnpsi@gmail.com', 'andersoneu'),
(88, 'Luan Santana', '1990-10-03', 'Usuário', '15994587624', 'luan@gmail.com', '123456789'),
(89, 'Maria Lima', '2006-06-06', 'Usuário', '15998369858', 'marialima@gmail.com', '123546789'),
(90, 'Maria Verneque', '2000-04-07', 'Usuário', '15996582589', 'mariaverneque@gmail.com', 'maria123'),
(91, 'Mario Almeida', NULL, 'Profissional', '15998745874', 'marioalmeida@gmail.com', '9874125630'),
(92, 'Juliano Alberto', '2001-01-01', 'Usuário', '15993658958', 'juliano@gmail.com', '123456789'),
(93, 'Paola Camargo Nunes', '1992-08-17', 'Usuário', '15997456783', 'paolanunes@gmail.com', 'paola123'),
(94, 'Karine Ramos Pinheiro', '1999-11-05', 'Usuário', '48995478735', 'pinhkahramos@gmail.com', 'kah123'),
(95, 'Rita', '2000-03-02', 'Usuário', '15996587415', 'rita12345@gmail.com', 'rita123'),
(96, 'Marcos Silva Santos', NULL, 'Profissional', '15997456738', 'marcos123@gmail.com', '12345');

-- --------------------------------------------------------

--
-- Estrutura da tabela `profissional`
--

CREATE TABLE `profissional` (
  `id_profissional` int(11) NOT NULL,
  `terapias` varchar(150) COLLATE latin1_general_ci DEFAULT NULL,
  `cpf` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
  `crp` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `atendimento` set('Online','Presencial') COLLATE latin1_general_ci DEFAULT NULL,
  `forma_pagamento` set('Pix','Débito','Crédito','Dinheiro','PASH - Plano Assistencial de Saúde Holística') COLLATE latin1_general_ci DEFAULT NULL,
  `pessoa` int(11) NOT NULL,
  `endereco_clinica` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `profissional`
--

INSERT INTO `profissional` (`id_profissional`, `terapias`, `cpf`, `crp`, `atendimento`, `forma_pagamento`, `pessoa`, `endereco_clinica`) VALUES
(1, NULL, NULL, '', NULL, NULL, 8, NULL),
(2, NULL, NULL, '', NULL, NULL, 9, NULL),
(3, NULL, NULL, '01/123.123', NULL, NULL, 46, NULL),
(4, NULL, NULL, '02/123.123', NULL, NULL, 50, NULL),
(5, NULL, NULL, '03/123.123', NULL, NULL, 52, NULL),
(6, NULL, NULL, '66/123.123', NULL, NULL, 65, NULL),
(7, NULL, NULL, '03456789', NULL, NULL, 68, NULL),
(8, NULL, NULL, '15/151.151', NULL, NULL, 70, NULL),
(9, NULL, NULL, '12/121.121', NULL, NULL, 71, NULL),
(10, NULL, NULL, '12/123.123', NULL, NULL, 74, NULL),
(11, NULL, NULL, '99/123.123', NULL, NULL, 78, NULL),
(12, NULL, NULL, '15/998.887', NULL, NULL, 80, NULL),
(13, NULL, NULL, '12/234.234', NULL, NULL, 82, NULL),
(14, NULL, NULL, '23/234.234', NULL, NULL, 83, NULL),
(15, NULL, NULL, '04/657.367', NULL, NULL, 87, NULL),
(16, NULL, NULL, '02/025896', NULL, NULL, 91, NULL),
(17, NULL, NULL, '31098678', NULL, NULL, 96, NULL);

-- --------------------------------------------------------

--
-- Estrutura da tabela `usuario`
--

CREATE TABLE `usuario` (
  `id_usuario` int(11) NOT NULL,
  `username` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(40) COLLATE latin1_general_ci NOT NULL,
  `senha` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `pessoa` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `usuario`
--

INSERT INTO `usuario` (`id_usuario`, `username`, `email`, `senha`, `pessoa`) VALUES
(1, 'Paula Machado', 'paulinhasilva27@gmail.com', 'paulinha123', 1),
(2, 'Ana Maria', 'anamaria23@gmail.com', 'maisvoce', 2),
(3, 'maria', 'mj633957@gmail.com', '123456', 3),
(6, 'maria julia', 'mah.almeida431@gmail.com', '123456789', 6),
(7, 'anaaaaaa', 'anaaaaa@gmail.com', '126359841', 7),
(8, 'Antunes Pontes', 'antiness567@gmail.com', 'pontes567', 10),
(11, 'Alaninha', 'alaninhafogosa@gmail.com', 'alaninhaETC', 27),
(14, '', 'andreiaalmeida@gmail.com', '1245@andreia', 30),
(15, '', 'aquilesfilho123@gmail.com', 'aquiles12345678', 31),
(16, '', 'anajulia@gmail.com', 'anajulia@1234', 32),
(17, '', 'felipe123456@gmail.com', 'felipe@3546', 33),
(18, '', 'mariajoana@gmail.com', 'maria@45123669', 34),
(19, '', 'juliana@gmail.com', 'juliana@4512', 35),
(20, '', 'isabele@gmail.com', 'isabele@123', 36),
(21, '', 'mariarodrigues@gmail.com', 'mariarodrigues1', 37),
(22, '', 'eduardo@gmail.com', 'eduardo@', 38),
(23, '', 'albertosantos@gmail.com', 'alberto12345', 39),
(24, '', 'marianaferreira@gmail.com', 'marianaferreira', 40),
(25, '', 'amelia@gmail.com', 'amelia12345', 41),
(26, '', 'mariabenfica@gmail.com', 'maria12345', 42),
(27, '', 'laislopes@gmail.com', 'lais12345@', 43),
(28, '', 'marcosp@gmail.com', 'marcos12345@', 44),
(29, '', 'marcosp@gmail.com', 'marcos12345@', 45),
(30, '', 'eliane@gmail.com', '', 47),
(31, '', 'rosangelasantiagoneves@gmail.com', 'duduneves', 48),
(32, '', 'albertgomes888@gmail.com', '3132,,5@', 49),
(33, '', 'albertferreira@gmail.com', '123456789', 51),
(34, '', 'laislopes2@gmail.com', '12345678', 53),
(35, '', 'NunesssLeitaoo@gmaio.com', 'leitenunes', 54),
(36, '', 'amandamello@gmail.com', '125364789', 55),
(37, '', 'isabelalima@gmail.com', '125643987', 56),
(38, '', 'amora@gmail.com', '123456987', 57),
(39, '', 'maria@gmail.com', 'maria23', 58),
(40, '', 'amandamello123@gmail.com', 'amanda12345', 59),
(41, '', 'ageubatistacruzz@gmail.com', 'argelinobaitaca', 60),
(42, '', 'eliana@gmail.com', '123456789', 61),
(43, '', 'alzirabarrosetec@gmail.com', 'alzirinhadograu', 62),
(44, '', 'vanderlei@gmail.com', 'vanderlei123@', 63),
(45, '', 'ruan_farias@gmail.com', '12345678', 64),
(46, '', 'karinaeu@gmail.com', 'kahsilva', 66),
(47, '', 'joanaa@gmail.com', 'joaninha', 67),
(48, '', 'eliane_primeira@gmail.com', '12345678', 69),
(49, '', 'mariajardim@gmail.com', '123456789', 72),
(50, '', 'cristiano@gmail.com', '123654789', 73),
(51, '', 'john_smith@gmail.com', '1234', 75),
(52, '', 'simone_gomes@gmail.com', '', 76),
(53, '', 'luiz_pedro@gmail.com', '1234', 77),
(54, '', 'maya_clarice@gmail.com', '12345678', 79),
(55, '', 'rita@gmail.com', '1234', 81),
(56, '', 'carlasilvaa@gmail.com', 'eucarla', 84),
(57, '', 'antonio@gmail.com', '123654789', 85),
(58, '', 'julianaferreira@gmail.com', 'juliana123', 86),
(59, '', 'luan@gmail.com', '123456789', 88),
(60, '', 'marialima@gmail.com', '123546789', 89),
(61, '', 'mariaverneque@gmail.com', 'maria123', 90),
(62, '', 'juliano@gmail.com', '123456789', 92),
(63, '', 'paolanunes@gmail.com', 'paola123', 93),
(64, '', 'pinhkahramos@gmail.com', 'kah123', 94),
(65, '', 'rita12345@gmail.com', 'rita123', 95);

-- --------------------------------------------------------

--
-- Estrutura da tabela `usuario_entity`
--

CREATE TABLE `usuario_entity` (
  `id` int(11) NOT NULL,
  `full_name` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `password` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `role` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `username` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `cpf` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `data_nascimento` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `usuario_entity`
--

INSERT INTO `usuario_entity` (`id`, `full_name`, `password`, `email`, `role`, `username`, `cpf`, `data_nascimento`) VALUES
(46, 'Rita de Cássia', 'irineuUrubu12', 'santiagoritinhacassia@gmail.com', '', '', '', '0000-00-00 00:00:00'),
(47, 'Delbert Langworth III', '7yENx59hin30bti', 'Lamar_Weber@yahoo.com', '', '', '', '0000-00-00 00:00:00'),
(48, 'Colin Considine', 'JVVzQPL4v4F8mR7', 'Kelsi.Robel@yahoo.com', '', '', '', '0000-00-00 00:00:00'),
(49, 'Elsie Borer', 'Rt8VzkbeAUI0Zpx', 'Casimir_Kshlerin@yahoo.com', '', '', '', '0000-00-00 00:00:00'),
(50, 'Maria Aparecida', 'cidinha67', 'aparecidaase@gmail.com', '', '', '', '0000-00-00 00:00:00'),
(51, 'Suzana Maria Roça dos Santos', 'FerReiRa123@:su', 'oliverasantos@gmail.com', '', '', '', '0000-00-00 00:00:00'),
(52, 'Susie Kerluke', 'srsDBeIGxmcHZ56', 'Kameron_Rodriguez74@hotmail.com', '', '', '', '0000-00-00 00:00:00'),
(53, 'Sofia Andrade', 'sofia123', 'sofia0905@gmail.com', '', '', '', '0000-00-00 00:00:00'),
(54, 'Ms. Percy Mayer', 'C1CAb5iB5In9v6X', 'Felicity60@gmail.com', '', '', '', '0000-00-00 00:00:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `agendamento`
--
ALTER TABLE `agendamento`
  ADD PRIMARY KEY (`id_agendamento`),
  ADD KEY `usuario` (`usuario`),
  ADD KEY `profissional` (`profissional`);

--
-- Indexes for table `endereco`
--
ALTER TABLE `endereco`
  ADD PRIMARY KEY (`id_endereco`),
  ADD KEY `pessoa` (`pessoa`);

--
-- Indexes for table `endereco_clinica`
--
ALTER TABLE `endereco_clinica`
  ADD PRIMARY KEY (`id_clinica`),
  ADD KEY `endereco` (`endereco`);

--
-- Indexes for table `ficha_usuario`
--
ALTER TABLE `ficha_usuario`
  ADD PRIMARY KEY (`id_ficha`),
  ADD KEY `usuario` (`usuario`);

--
-- Indexes for table `login_profissional`
--
ALTER TABLE `login_profissional`
  ADD PRIMARY KEY (`id_login`),
  ADD KEY `profissional` (`profissional`);

--
-- Indexes for table `noticias_favoritas`
--
ALTER TABLE `noticias_favoritas`
  ADD KEY `id_usuario` (`id_usuario`);

--
-- Indexes for table `pessoa`
--
ALTER TABLE `pessoa`
  ADD PRIMARY KEY (`id_pessoa`);

--
-- Indexes for table `profissional`
--
ALTER TABLE `profissional`
  ADD PRIMARY KEY (`id_profissional`),
  ADD KEY `pessoa` (`pessoa`),
  ADD KEY `endereco_clinica` (`endereco_clinica`);

--
-- Indexes for table `usuario`
--
ALTER TABLE `usuario`
  ADD PRIMARY KEY (`id_usuario`),
  ADD KEY `pessoa` (`pessoa`);

--
-- Indexes for table `usuario_entity`
--
ALTER TABLE `usuario_entity`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `agendamento`
--
ALTER TABLE `agendamento`
  MODIFY `id_agendamento` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `endereco`
--
ALTER TABLE `endereco`
  MODIFY `id_endereco` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `endereco_clinica`
--
ALTER TABLE `endereco_clinica`
  MODIFY `id_clinica` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ficha_usuario`
--
ALTER TABLE `ficha_usuario`
  MODIFY `id_ficha` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `login_profissional`
--
ALTER TABLE `login_profissional`
  MODIFY `id_login` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `pessoa`
--
ALTER TABLE `pessoa`
  MODIFY `id_pessoa` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;

--
-- AUTO_INCREMENT for table `profissional`
--
ALTER TABLE `profissional`
  MODIFY `id_profissional` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `usuario`
--
ALTER TABLE `usuario`
  MODIFY `id_usuario` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT for table `usuario_entity`
--
ALTER TABLE `usuario_entity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- Constraints for dumped tables
--

--
-- Limitadores para a tabela `agendamento`
--
ALTER TABLE `agendamento`
  ADD CONSTRAINT `agendamento_ibfk_1` FOREIGN KEY (`usuario`) REFERENCES `usuario` (`id_usuario`),
  ADD CONSTRAINT `agendamento_ibfk_2` FOREIGN KEY (`profissional`) REFERENCES `profissional` (`id_profissional`);

--
-- Limitadores para a tabela `endereco`
--
ALTER TABLE `endereco`
  ADD CONSTRAINT `endereco_ibfk_1` FOREIGN KEY (`pessoa`) REFERENCES `pessoa` (`id_pessoa`);

--
-- Limitadores para a tabela `endereco_clinica`
--
ALTER TABLE `endereco_clinica`
  ADD CONSTRAINT `endereco_clinica_ibfk_1` FOREIGN KEY (`endereco`) REFERENCES `endereco` (`id_endereco`);

--
-- Limitadores para a tabela `ficha_usuario`
--
ALTER TABLE `ficha_usuario`
  ADD CONSTRAINT `ficha_usuario_ibfk_1` FOREIGN KEY (`usuario`) REFERENCES `usuario` (`id_usuario`);

--
-- Limitadores para a tabela `login_profissional`
--
ALTER TABLE `login_profissional`
  ADD CONSTRAINT `login_profissional_ibfk_1` FOREIGN KEY (`profissional`) REFERENCES `profissional` (`id_profissional`);

--
-- Limitadores para a tabela `noticias_favoritas`
--
ALTER TABLE `noticias_favoritas`
  ADD CONSTRAINT `noticias_favoritas_ibfk_1` FOREIGN KEY (`id_usuario`) REFERENCES `usuario` (`id_usuario`) ON UPDATE CASCADE;

--
-- Limitadores para a tabela `profissional`
--
ALTER TABLE `profissional`
  ADD CONSTRAINT `profissional_ibfk_1` FOREIGN KEY (`pessoa`) REFERENCES `pessoa` (`id_pessoa`),
  ADD CONSTRAINT `profissional_ibfk_2` FOREIGN KEY (`endereco_clinica`) REFERENCES `endereco_clinica` (`id_clinica`);

--
-- Limitadores para a tabela `usuario`
--
ALTER TABLE `usuario`
  ADD CONSTRAINT `usuario_ibfk_1` FOREIGN KEY (`pessoa`) REFERENCES `pessoa` (`id_pessoa`);
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 */;
