--
-- Create table `module_med_doctor`
--

DROP TABLE IF EXISTS `module_med_doctor`;
CREATE TABLE `module_med_doctor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) DEFAULT NULL,
  `name` VARCHAR(64) DEFAULT NULL,
  `email` VARCHAR(64) DEFAULT NULL,
  `crm` VARCHAR(24) DEFAULT NULL,
  `crm_obs` VARCHAR(2048) DEFAULT NULL,
  `signature` VARCHAR(128) DEFAULT NULL,
  `password` VARCHAR(64) DEFAULT NULL,
  `phone` VARCHAR(11) DEFAULT NULL,
  `cell_phone` VARCHAR(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),

  INDEX `fk_crm_groups_idx` (`group_id` ASC),

  CONSTRAINT `fk_crm_groups_id`
  FOREIGN KEY (`group_id`)
  REFERENCES `crm_groups` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

--
-- Create table `module_med_diary`
--

DROP TABLE IF EXISTS `module_med_diary`;
CREATE TABLE `module_med_diary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doctor_id` int(11) DEFAULT NULL,
  `diary` VARCHAR(255) DEFAULT NULL,
  `interval` VARCHAR(255) DEFAULT NULL,
  `default` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_module_med_doctor_idx` (`doctor_id` ASC),
  CONSTRAINT `fk_module_med_doctor`
  FOREIGN KEY (`doctor_id`)
  REFERENCES `module_med_doctor` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

--
-- Create table `module_med_type_exam`
--

DROP TABLE IF EXISTS `module_med_type_exam`;
CREATE TABLE `module_med_type_exam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exam` VARCHAR(255) DEFAULT NULL,
  `preparation` VARCHAR(2024) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

--
-- Insert table `crm_groups`
--
INSERT INTO `crm_groups` (`id`, `gname`, `color`, `discount`, `parent`, `pid`, `exempt`, `description`, `separateinvoices`, `sorder`, `c1`, `c2`, `c3`, `c4`, `c5`, `default`) VALUES (NULL, 'Patient', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1');

--
-- Create table `module_med_agreement`
--

DROP TABLE IF EXISTS `module_med_agreement`;
CREATE TABLE `module_med_agreement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agreement` VARCHAR(255) DEFAULT NULL,
  `code` VARCHAR(32) DEFAULT NULL,
  `params` VARCHAR(2024) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

--
-- Create table `module_med_diary`
--

DROP TABLE IF EXISTS `module_med_scheduling`;
CREATE TABLE `module_med_scheduling` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `diary_id` int(11) DEFAULT NULL,
  `patient_id` int(11) DEFAULT NULL,
  `type_exam_id` int(11) DEFAULT NULL,
  `agreement_id` int(11) DEFAULT NULL,
  `date` DATE DEFAULT NULL,
  `hour` TIME DEFAULT NULL,
  `agreement_guide` VARCHAR(255) DEFAULT NULL,
  `observation` TEXT DEFAULT NULL,
  `status` ENUM('pendente','confirmado','aguardando atendimento','atendido','cancelado') NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),

  INDEX `fk_module_med_diary_idx` (`diary_id` ASC),
  INDEX `fk_crm_accounts_idx` (`patient_id` ASC),
  INDEX `fk_module_med_type_exam_idx` (`type_exam_id` ASC),
  INDEX `fk_module_med_agreement_idx` (`agreement_id` ASC),

  CONSTRAINT `fk_module_med_diary_id`
  FOREIGN KEY (`diary_id`)
  REFERENCES `module_med_diary` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,

  CONSTRAINT `fk_crm_accounts_id`
  FOREIGN KEY (`patient_id`)
  REFERENCES `crm_accounts` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,

  CONSTRAINT `fk_module_med_type_exam_id`
  FOREIGN KEY (`type_exam_id`)
  REFERENCES `module_med_type_exam` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,

  CONSTRAINT `fk_module_med_agreement_id`
  FOREIGN KEY (`agreement_id`)
  REFERENCES `module_med_agreement` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

--
-- Create table `module_med_payments`
--

DROP TABLE IF EXISTS `module_med_payments`;
CREATE TABLE `module_med_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `scheduling_id` int(11) DEFAULT NULL,
  `value` DECIMAL(10,2) NOT NULL,
  `date` DATE DEFAULT NULL,
  `observation` TEXT DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_module_med_scheduling_idx` (`scheduling_id` ASC),

  CONSTRAINT `fk_module_med_scheduling`
  FOREIGN KEY (`scheduling_id`)
  REFERENCES `module_med_scheduling` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

--
-- Create table `module_med_payments`
--

DROP TABLE IF EXISTS `module_med_scheduling_exams`;
CREATE TABLE `module_med_scheduling_exams` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `scheduling_id` int(11) DEFAULT NULL,
  `type_exam_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),

  INDEX `fk_module_med_scheduling_idx` (`scheduling_id` ASC),
  INDEX `fk_module_med_type_exam_idx` (`type_exam_id` ASC),

  CONSTRAINT `fk_module_med_scheduling2`
  FOREIGN KEY (`scheduling_id`)
  REFERENCES `module_med_scheduling` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,

  CONSTRAINT `fk_module_med_type_exam2`
  FOREIGN KEY (`type_exam_id`)
  REFERENCES `module_med_type_exam` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;