SQL 14
David Guest on 17th November 2021 09:22:25 PM
  1. -- MySQL Workbench Forward Engineering
  2.  
  3. SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
  4. SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
  5. 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';
  6.  
  7. -- -----------------------------------------------------
  8. -- Schema mydb
  9. -- -----------------------------------------------------
  10. -- -----------------------------------------------------
  11. -- Schema azziedev_davidtowsondb
  12. -- -----------------------------------------------------
  13.  
  14. -- -----------------------------------------------------
  15. -- Schema azziedev_davidtowsondb
  16. -- -----------------------------------------------------
  17. CREATE SCHEMA IF NOT EXISTS `azziedev_davidtowsondb` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
  18. USE `azziedev_davidtowsondb` ;
  19.  
  20. -- -----------------------------------------------------
  21. -- Table `azziedev_davidtowsondb`.`EMPLOYEE`
  22. -- -----------------------------------------------------
  23. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`EMPLOYEE` (
  24.   `FNAME` VARCHAR(45) NULL DEFAULT NULL,
  25.   `MINIT` VARCHAR(45) NULL DEFAULT NULL,
  26.   `LNAME` VARCHAR(45) NULL DEFAULT NULL,
  27.   `SSN` INT(9) NOT NULL,
  28.   `BDATE` DATE NULL DEFAULT NULL,
  29.   `ADDRESS` VARCHAR(45) NULL DEFAULT NULL,
  30.   `SEX` VARCHAR(45) NULL DEFAULT NULL,
  31.   `SUPERSSN` INT(9) NULL DEFAULT NULL,
  32.   `DNO` INT(1) NULL DEFAULT NULL,
  33.   PRIMARY KEY (`SSN`),
  34.   INDEX `SUPERSSN_idx` (`SUPERSSN` ASC),
  35.   INDEX `DNO_idx` (`DNO` ASC),
  36.   CONSTRAINT `SUPERSSN`
  37.     FOREIGN KEY (`SUPERSSN`)
  38.     REFERENCES `azziedev_davidtowsondb`.`EMPLOYEE` (`SSN`)
  39.     ON DELETE NO ACTION
  40.     ON UPDATE NO ACTION,
  41.   CONSTRAINT `DNO`
  42.     FOREIGN KEY (`DNO`)
  43.     REFERENCES `azziedev_davidtowsondb`.`DEPARTMENT` (`DNUMBER`)
  44.     ON DELETE NO ACTION
  45.     ON UPDATE NO ACTION)
  46. ENGINE = InnoDB
  47. DEFAULT CHARACTER SET = utf8
  48. COLLATE = utf8_unicode_ci;
  49.  
  50.  
  51. -- -----------------------------------------------------
  52. -- Table `azziedev_davidtowsondb`.`DEPARTMENT`
  53. -- -----------------------------------------------------
  54. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`DEPARTMENT` (
  55.   `DNAME` VARCHAR(45) NULL DEFAULT NULL,
  56.   `DNUMBER` INT(1) NOT NULL,
  57.   `MGRSSN` INT(9) NULL DEFAULT NULL,
  58.   `MGRSTARTDATE` DATE NULL DEFAULT NULL,
  59.   PRIMARY KEY (`DNUMBER`),
  60.   INDEX `MGRSSN_idx` (`MGRSSN` ASC),
  61.   CONSTRAINT `MGRSSN`
  62.     FOREIGN KEY (`MGRSSN`)
  63.     REFERENCES `azziedev_davidtowsondb`.`EMPLOYEE` (`SSN`)
  64.     ON DELETE NO ACTION
  65.     ON UPDATE NO ACTION)
  66. ENGINE = InnoDB
  67. DEFAULT CHARACTER SET = utf8
  68. COLLATE = utf8_unicode_ci;
  69.  
  70.  
  71. -- -----------------------------------------------------
  72. -- Table `azziedev_davidtowsondb`.`DEPENDENT`
  73. -- -----------------------------------------------------
  74. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`DEPENDENT` (
  75.   `ESSN` INT(9) NOT NULL,
  76.   `DEPENDENT_NAME` VARCHAR(45) NOT NULL,
  77.   `SEX` VARCHAR(45) NULL DEFAULT NULL,
  78.   `BDATE` DATE NULL DEFAULT NULL,
  79.   `RELATIONSHIP` VARCHAR(45) NULL DEFAULT NULL,
  80.   PRIMARY KEY (`ESSN`, `DEPENDENT_NAME`),
  81.   CONSTRAINT `ESSN`
  82.     FOREIGN KEY (`ESSN`)
  83.     REFERENCES `azziedev_davidtowsondb`.`EMPLOYEE` (`SSN`)
  84.     ON DELETE NO ACTION
  85.     ON UPDATE NO ACTION)
  86. ENGINE = InnoDB
  87. DEFAULT CHARACTER SET = utf8
  88. COLLATE = utf8_unicode_ci;
  89.  
  90.  
  91. -- -----------------------------------------------------
  92. -- Table `azziedev_davidtowsondb`.`DEPT_LOCATIONS`
  93. -- -----------------------------------------------------
  94. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`DEPT_LOCATIONS` (
  95.   `DNUMBER` INT(1) NOT NULL,
  96.   `DLOCATION` VARCHAR(45) NOT NULL,
  97.   INDEX `DEPT_idx` (`DNUMBER` ASC),
  98.   PRIMARY KEY (`DNUMBER`, `DLOCATION`),
  99.   CONSTRAINT `DEPT`
  100.     FOREIGN KEY (`DNUMBER`)
  101.     REFERENCES `azziedev_davidtowsondb`.`DEPARTMENT` (`DNUMBER`)
  102.     ON DELETE NO ACTION
  103.     ON UPDATE NO ACTION)
  104. ENGINE = InnoDB
  105. DEFAULT CHARACTER SET = utf8
  106. COLLATE = utf8_unicode_ci;
  107.  
  108.  
  109. -- -----------------------------------------------------
  110. -- Table `azziedev_davidtowsondb`.`PROJECT`
  111. -- -----------------------------------------------------
  112. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`PROJECT` (
  113.   `PNAME` VARCHAR(45) NULL DEFAULT NULL,
  114.   `PNUMBER` INT(2) NOT NULL,
  115.   `PLOCATION` VARCHAR(45) NULL,
  116.   `DNUM` INT(1) NULL DEFAULT NULL,
  117.   PRIMARY KEY (`PNUMBER`),
  118.   INDEX `DNUM_idx` (`DNUM` ASC),
  119.   CONSTRAINT `DNUM`
  120.     FOREIGN KEY (`DNUM`)
  121.     REFERENCES `azziedev_davidtowsondb`.`DEPARTMENT` (`DNUMBER`)
  122.     ON DELETE NO ACTION
  123.     ON UPDATE NO ACTION)
  124. ENGINE = InnoDB
  125. DEFAULT CHARACTER SET = utf8
  126. COLLATE = utf8_unicode_ci;
  127.  
  128.  
  129. -- -----------------------------------------------------
  130. -- Table `azziedev_davidtowsondb`.`WORKS_ON`
  131. -- -----------------------------------------------------
  132. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`WORKS_ON` (
  133.   `ESSN` INT(9) NOT NULL,
  134.   `PNO` INT(2) NOT NULL,
  135.   `HOURS` DECIMAL(1,0) NULL DEFAULT NULL,
  136.   PRIMARY KEY (`ESSN`, `PNO`),
  137.   INDEX `PNOw_idx` (`PNO` ASC),
  138.   CONSTRAINT `ESSNw`
  139.     FOREIGN KEY (`ESSN`)
  140.     REFERENCES `azziedev_davidtowsondb`.`EMPLOYEE` (`SSN`)
  141.     ON DELETE NO ACTION
  142.     ON UPDATE NO ACTION,
  143.   CONSTRAINT `PNOw`
  144.     FOREIGN KEY (`PNO`)
  145.     REFERENCES `azziedev_davidtowsondb`.`PROJECT` (`PNUMBER`)
  146.     ON DELETE NO ACTION
  147.     ON UPDATE NO ACTION)
  148. ENGINE = InnoDB
  149. DEFAULT CHARACTER SET = utf8
  150. COLLATE = utf8_unicode_ci;
  151.  
  152.  
  153. SET SQL_MODE=@OLD_SQL_MODE;
  154. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  155. SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Paste is for source code and general debugging text.

Login or Register to edit, delete and keep track of your pastes and more.

Raw Paste

Login or Register to edit or fork this paste. It's free.

Copyright © 2026 Paste. All rights reserved.
Powered by Paste