spYysAj1

1-- MySQL Script generated by MySQL Workbench
2-- Mon Nov 20 14:42:38 2017
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema doctorSystem
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema doctorSystem
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `doctorSystem` DEFAULT CHARACTER SET utf8 ;
18USE `doctorSystem` ;
19
20-- -----------------------------------------------------
21-- Table `doctorSystem`.`doctorData`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `doctorSystem`.`doctorData` (
24  `doctorID` INT NOT NULL AUTO_INCREMENT,
25  `doctorName` VARCHAR(250) NOT NULL,
26  `doctorSurename` VARCHAR(250) NOT NULL,
27  `doctorNumber` VARCHAR(250) NOT NULL,
28  `doctorSpeciality` VARCHAR(250) NOT NULL,
29  PRIMARY KEY (`doctorID`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `doctorSystem`.`patientData`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `doctorSystem`.`patientData` (
37  `patientID` INT NOT NULL AUTO_INCREMENT,
38  `patientName` VARCHAR(250) NOT NULL,
39  `patientSurename` VARCHAR(250) NOT NULL,
40  `patientDisease` VARCHAR(250) NOT NULL,
41  PRIMARY KEY (`patientID`))
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `doctorSystem`.`appointmentsData`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `doctorSystem`.`appointmentsData` (
49  `appointmentsID` INT NOT NULL AUTO_INCREMENT,
50  `appointmentsDoctor` VARCHAR(250) NOT NULL,
51  `appointmentsPatient` VARCHAR(250) NOT NULL,
52  `appointmentsDate` DATE NOT NULL,
53  `appointmentsHours` TIME NOT NULL,
54  PRIMARY KEY (`appointmentsID`))
55ENGINE = InnoDB;
56
57
58SET SQL_MODE=@OLD_SQL_MODE;
59SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
60SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;