-- MySQL Script generated by MySQL Workbench
-- Mon Nov 20 14:42:38 2017
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema doctorSystem
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema doctorSystem
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `doctorSystem` DEFAULT CHARACTER SET utf8 ;
USE `doctorSystem` ;

-- -----------------------------------------------------
-- Table `doctorSystem`.`doctorData`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `doctorSystem`.`doctorData` (
  `doctorID` INT NOT NULL AUTO_INCREMENT,
  `doctorName` VARCHAR(250) NOT NULL,
  `doctorSurename` VARCHAR(250) NOT NULL,
  `doctorNumber` VARCHAR(250) NOT NULL,
  `doctorSpeciality` VARCHAR(250) NOT NULL,
  PRIMARY KEY (`doctorID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `doctorSystem`.`patientData`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `doctorSystem`.`patientData` (
  `patientID` INT NOT NULL AUTO_INCREMENT,
  `patientName` VARCHAR(250) NOT NULL,
  `patientSurename` VARCHAR(250) NOT NULL,
  `patientDisease` VARCHAR(250) NOT NULL,
  PRIMARY KEY (`patientID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `doctorSystem`.`appointmentsData`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `doctorSystem`.`appointmentsData` (
  `appointmentsID` INT NOT NULL AUTO_INCREMENT,
  `appointmentsDoctor` VARCHAR(250) NOT NULL,
  `appointmentsPatient` VARCHAR(250) NOT NULL,
  `appointmentsDate` DATE NOT NULL,
  `appointmentsHours` TIME NOT NULL,
  PRIMARY KEY (`appointmentsID`))
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;