ft8E4qyY

1-- MySQL Workbench Synchronization
2-- Generated: 2019-03-07 19:46
3-- Model: New Model
4-- Version: 1.0
5-- Project: Name of the project
6-- Author: milor
7
8SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
9SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
10SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
11
12CREATE TABLE IF NOT EXISTS `bartek`.`pacjent` (
13  `idpacjent` INT(11) NOT NULL AUTO_INCREMENT,
14  `imie` VARCHAR(20) NOT NULL,
15  `nazwisko` VARCHAR(35) NOT NULL,
16  `pesel` VARCHAR(11) NOT NULL,
17  `plec` ENUM("Kobieta", "Mężczyzna") NOT NULL,
18  `data_urodzenia` DATE NOT NULL,
19  `adres` VARCHAR(60) NOT NULL,
20  `telefon` VARCHAR(9) NOT NULL,
21  PRIMARY KEY (`idpacjent`),
22  UNIQUE INDEX `idpacjent_UNIQUE` (`idpacjent` ASC) VISIBLE,
23  UNIQUE INDEX `pesel_UNIQUE` (`pesel` ASC) VISIBLE)
24ENGINE = InnoDB
25DEFAULT CHARACTER SET = utf8;
26
27CREATE TABLE IF NOT EXISTS `bartek`.`lekarz` (
28  `idlekarz` INT(11) NOT NULL AUTO_INCREMENT,
29  `imie` VARCHAR(20) NOT NULL,
30  `nazwisko` VARCHAR(35) NOT NULL,
31  `pesel` VARCHAR(11) NOT NULL,
32  `plec` ENUM("Kobieta", "Mężczyzna") NOT NULL,
33  `data_urodzenia` DATE NOT NULL,
34  `adres` VARCHAR(60) NOT NULL,
35  `telefon` VARCHAR(9) NOT NULL,
36  PRIMARY KEY (`idlekarz`),
37  UNIQUE INDEX `idlekarz_UNIQUE` (`idlekarz` ASC) VISIBLE)
38ENGINE = InnoDB
39DEFAULT CHARACTER SET = utf8;
40
41CREATE TABLE IF NOT EXISTS `bartek`.`wizyty` (
42  `idwizyty` INT(11) NOT NULL AUTO_INCREMENT,
43  `data` DATETIME NOT NULL,
44  `zakres_badan` VARCHAR(256) NOT NULL,
45  `recepta` VARCHAR(128) NOT NULL,
46  `opis` VARCHAR(512) NULL DEFAULT NULL,
47  PRIMARY KEY (`idwizyty`),
48  UNIQUE INDEX `idwizyty_UNIQUE` (`idwizyty` ASC) VISIBLE)
49ENGINE = InnoDB
50DEFAULT CHARACTER SET = utf8;
51
52
53SET SQL_MODE=@OLD_SQL_MODE;
54SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
55SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;