SQL 39
David Guest on 17th November 2021 08:20:43 AM
  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` VARCHAR(45) NULL DEFAULT NULL,
  33.   PRIMARY KEY (`SSN`),
  34.   INDEX `SUPERSSN_idx` (`SUPERSSN` ASC),
  35.   CONSTRAINT `SUPERSSN`
  36.     FOREIGN KEY (`SUPERSSN`)
  37.     REFERENCES `azziedev_davidtowsondb`.`EMPLOYEE` (`SSN`)
  38.     ON DELETE NO ACTION
  39.     ON UPDATE NO ACTION)
  40. ENGINE = InnoDB
  41. DEFAULT CHARACTER SET = utf8
  42. COLLATE = utf8_unicode_ci;
  43.  
  44.  
  45. -- -----------------------------------------------------
  46. -- Table `azziedev_davidtowsondb`.`DEPARTMENT`
  47. -- -----------------------------------------------------
  48. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`DEPARTMENT` (
  49.   `DNAME` VARCHAR(45) NULL DEFAULT NULL,
  50.   `DNUMBER` INT(1) NOT NULL,
  51.   `MGRSSN` INT(9) NULL DEFAULT NULL,
  52.   `MGRSTARTDATE` DATE NULL DEFAULT NULL,
  53.   PRIMARY KEY (`DNUMBER`),
  54.   INDEX `MGRSSN_idx` (`MGRSSN` ASC),
  55.   CONSTRAINT `MGRSSN`
  56.     FOREIGN KEY (`MGRSSN`)
  57.     REFERENCES `azziedev_davidtowsondb`.`EMPLOYEE` (`SSN`)
  58.     ON DELETE NO ACTION
  59.     ON UPDATE NO ACTION)
  60. ENGINE = InnoDB
  61. DEFAULT CHARACTER SET = utf8
  62. COLLATE = utf8_unicode_ci;
  63.  
  64.  
  65. -- -----------------------------------------------------
  66. -- Table `azziedev_davidtowsondb`.`DEPENDENT`
  67. -- -----------------------------------------------------
  68. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`DEPENDENT` (
  69.   `ESSN` INT(9) NOT NULL,
  70.   `DEPENDENT_NAME` VARCHAR(45) NULL DEFAULT NULL,
  71.   `SEX` VARCHAR(45) NULL DEFAULT NULL,
  72.   `BDATE` DATE NULL DEFAULT NULL,
  73.   `RELATIONSHIP` VARCHAR(45) NULL DEFAULT NULL,
  74.   PRIMARY KEY (`ESSN`),
  75.   CONSTRAINT `ESSN`
  76.     FOREIGN KEY (`ESSN`)
  77.     REFERENCES `azziedev_davidtowsondb`.`EMPLOYEE` (`SSN`)
  78.     ON DELETE NO ACTION
  79.     ON UPDATE NO ACTION)
  80. ENGINE = InnoDB
  81. DEFAULT CHARACTER SET = utf8
  82. COLLATE = utf8_unicode_ci;
  83.  
  84.  
  85. -- -----------------------------------------------------
  86. -- Table `azziedev_davidtowsondb`.`DEPT_LOCATIONS`
  87. -- -----------------------------------------------------
  88. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`DEPT_LOCATIONS` (
  89.   `DNUMBER` INT(1) NOT NULL,
  90.   `DLOCATION` VARCHAR(45) NOT NULL,
  91.   INDEX `DEPT_idx` (`DNUMBER` ASC),
  92.   CONSTRAINT `DEPT`
  93.     FOREIGN KEY (`DNUMBER`)
  94.     REFERENCES `azziedev_davidtowsondb`.`DEPARTMENT` (`DNUMBER`)
  95.     ON DELETE NO ACTION
  96.     ON UPDATE NO ACTION)
  97. ENGINE = InnoDB
  98. DEFAULT CHARACTER SET = utf8
  99. COLLATE = utf8_unicode_ci;
  100.  
  101.  
  102. -- -----------------------------------------------------
  103. -- Table `azziedev_davidtowsondb`.`PROJECT`
  104. -- -----------------------------------------------------
  105. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`PROJECT` (
  106.   `PNAME` VARCHAR(45) NULL DEFAULT NULL,
  107.   `PNUMBER` INT(2) NOT NULL,
  108.   `PLOCATION` VARCHAR(45) NULL,
  109.   `DNUM` INT(1) NULL DEFAULT NULL,
  110.   PRIMARY KEY (`PNUMBER`),
  111.   INDEX `DNUM_idx` (`DNUM` ASC),
  112.   CONSTRAINT `DNUM`
  113.     FOREIGN KEY (`DNUM`)
  114.     REFERENCES `azziedev_davidtowsondb`.`DEPARTMENT` (`DNUMBER`)
  115.     ON DELETE NO ACTION
  116.     ON UPDATE NO ACTION)
  117. ENGINE = InnoDB
  118. DEFAULT CHARACTER SET = utf8
  119. COLLATE = utf8_unicode_ci;
  120.  
  121.  
  122. -- -----------------------------------------------------
  123. -- Table `azziedev_davidtowsondb`.`WORKS_ON`
  124. -- -----------------------------------------------------
  125. CREATE TABLE IF NOT EXISTS `azziedev_davidtowsondb`.`WORKS_ON` (
  126.   `ESSN` INT(9) NOT NULL,
  127.   `PNO` INT(2) NOT NULL,
  128.   `HOURS` DECIMAL(1,0) NULL DEFAULT NULL,
  129.   PRIMARY KEY (`ESSN`, `PNO`),
  130.   INDEX `PNO_idx` (`PNO` ASC),
  131.   CONSTRAINT `ESSN`
  132.     FOREIGN KEY (`ESSN`)
  133.     REFERENCES `azziedev_davidtowsondb`.`EMPLOYEE` (`SSN`)
  134.     ON DELETE NO ACTION
  135.     ON UPDATE NO ACTION,
  136.   CONSTRAINT `PNO`
  137.     FOREIGN KEY (`PNO`)
  138.     REFERENCES `azziedev_davidtowsondb`.`PROJECT` (`PNUMBER`)
  139.     ON DELETE NO ACTION
  140.     ON UPDATE NO ACTION)
  141. ENGINE = InnoDB
  142. DEFAULT CHARACTER SET = utf8
  143. COLLATE = utf8_unicode_ci;
  144.  
  145.  
  146. SET SQL_MODE=@OLD_SQL_MODE;
  147. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  148. 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