Список использованных источников
Нестеров, С. А. Базы данных: учебник и практикум для вузов / С. А. Нестеров. — Москва: Издательство Юрайт, 2022. — 230 с. — (Высшее образование). — ISBN 978-5-534-00874-6. — Текст : электронный // Образовательная платформа Юрайт [сайт]. — URL: https://urait.ru/bcode/489693 (дата обращения: 23.05.2022).
Осипов Д. Л. Технологии проектирования баз данных. – М.: ДМК Пресс, 2019. – 498 с.: ил.
Интерактивный учебник по SQL. URL: http://www.sql-tutorial.ru/ (дата обращения 23.05.2022).
Упражнения по SQL. URL: https://www.sql-ex.ru/?Lang=0 (дата обращения 23.05.2022).
Автор YouTube канала «htmllab». Курс MySQL 8 – YouTube. URL: https://youtube.com/playlist?list=PLOQDek48BpZFeW02dfJM77FY4Fp5ilJ6n (дата обращения 23.05.2022).
-- MySQL Script generated by MySQL Workbench -- Tue May 24 17:03:58 2022 -- 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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
-- ----------------------------------------------------- -- Schema hospital -- -----------------------------------------------------
-- ----------------------------------------------------- -- Schema hospital -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `hospital` DEFAULT CHARACTER SET utf8 ; USE `hospital` ;
-- ----------------------------------------------------- -- Table `hospital`.`doctors` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `hospital`.`doctors` ( `id_doc` INT NOT NULL AUTO_INCREMENT, `firstname` VARCHAR(45) NOT NULL, `surname` VARCHAR(45) NOT NULL, `middlename` VARCHAR(45) NULL, `position` VARCHAR(45) NOT NULL, `workexperience` VARCHAR(45) NULL, `scientifictitle` VARCHAR(100) NULL, `address` VARCHAR(255) NULL, PRIMARY KEY (`id_doc`)) ENGINE = InnoDB;
-- ----------------------------------------------------- -- Table `hospital`.`patients` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `hospital`.`patients` ( `id_pat` INT NOT NULL AUTO_INCREMENT, `firstname` VARCHAR(45) NOT NULL, `surname` VARCHAR(45) NOT NULL, `middlename` VARCHAR(45) NULL, `address` VARCHAR(255) NULL, `city` VARCHAR(100) NULL, `age` INT NULL, `gender` VARCHAR(1) NULL, PRIMARY KEY (`id_pat`)) ENGINE = InnoDB;
-- ----------------------------------------------------- -- Table `hospital`.`operations` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `hospital`.`operations` ( `id_op` INT NOT NULL, `id_doc` INT NOT NULL, `id_pat` INT NOT NULL, `op_description` VARCHAR(255) NULL, `op_date` DATE NULL, `op_result` VARCHAR(255) NULL, PRIMARY KEY (`id_op`), INDEX `fk_operations_doctors1_idx` (`id_doc` ASC) VISIBLE, INDEX `fk_operations_patients1_idx` (`id_pat` ASC) VISIBLE, CONSTRAINT `fk_operations_doctors1` FOREIGN KEY (`id_doc`) REFERENCES `hospital`.`doctors` (`id_doc`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_operations_patients1` FOREIGN KEY (`id_pat`) REFERENCES `hospital`.`patients` (`id_pat`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
-- ----------------------------------------------------- -- Table `hospital`.`medical_history` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `hospital`.`medical_history` ( `id_hist` INT NOT NULL, `id_pat` INT NOT NULL, `id_doc` INT NOT NULL, `diagnosis` VARCHAR(255) NOT NULL, `disease_date` DATE NULL, `cure_date` DATE NULL, `treatment_type` VARCHAR(255) NULL, `id_op` INT NULL, PRIMARY KEY (`id_hist`), INDEX `fk_medical_history_patients_idx` (`id_pat` ASC) VISIBLE, INDEX `fk_medical_history_doctors1_idx` (`id_doc` ASC) VISIBLE, INDEX `fk_medical_history_operations1_idx` (`id_op` ASC) VISIBLE, CONSTRAINT `fk_medical_history_patients` FOREIGN KEY (`id_pat`) REFERENCES `hospital`.`patients` (`id_pat`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_medical_history_doctors1` FOREIGN KEY (`id_doc`) REFERENCES `hospital`.`doctors` (`id_doc`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_medical_history_operations1` FOREIGN KEY (`id_op`) REFERENCES `hospital`.`operations` (`id_op`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
-- ----------------------------------------------------- -- Table `hospital`.`treatment_list` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `hospital`.`treatment_list` ( `id_treatm` INT NOT NULL, `id_hist` INT NOT NULL, `treatm_date` DATE NOT NULL, `medicines` VARCHAR(255) NULL, `temp` DECIMAL(2,1) NULL, `pressure` VARCHAR(7) NULL, `pat_condition` VARCHAR(255) NULL, PRIMARY KEY (`id_treatm`), INDEX `fk_treatment_list_medical_history1_idx` (`id_hist` ASC) VISIBLE, CONSTRAINT `fk_treatment_list_medical_history1` FOREIGN KEY (`id_hist`) REFERENCES `hospital`.`medical_history` (`id_hist`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |