-- Tabela informações do cliente/paciente

DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `profession` varchar(255) DEFAULT NULL,
  `sex` tinyint(1) NOT NULL,
  `marital_status` tinyint(1) NOT NULL,
  `role` varchar(20) NOT NULL DEFAULT 'customer',
  `cpf` varchar(20) DEFAULT NULL,
  `rg` varchar(20) DEFAULT NULL,
  `birth_date` date NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `cep` varchar(10) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `complement` varchar(255) DEFAULT NULL,
  `neighborhood` varchar(255) DEFAULT NULL,
  `estate` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `references` varchar(255) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- tablela de consultas dos clientes/pacientes
-- contem dados de doenças dos pacientes
DROP TABLE IF EXISTS `customers_consultations`;
CREATE TABLE `customers_consultations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `obesity` varchar(255) DEFAULT NULL,
  `psychological` varchar(255) DEFAULT NULL,
  `cancer` varchar(255) DEFAULT NULL,
  `osteoarthritis` varchar(255) DEFAULT NULL,
  `tuberculosis` varchar(255) DEFAULT NULL,
  `herniated_disc` varchar(255) DEFAULT NULL,
  `osteoporosis` varchar(255) DEFAULT NULL,
  `stifle` varchar(255) DEFAULT NULL,
  `fractures` varchar(255) DEFAULT NULL,
  `scoliosis` varchar(255) DEFAULT NULL,
  `ligament` varchar(255) DEFAULT NULL,
  `hyper_lordosis` varchar(255) DEFAULT NULL,
  `pregnant` varchar(255) DEFAULT NULL,
  `kyphosis` varchar(255) DEFAULT NULL,
  `alerigia` varchar(255) DEFAULT NULL,
  `symptoms` varchar(255) DEFAULT NULL,
  `others` varchar(255) DEFAULT NULL,
  `observations` text,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;