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