SQL 20
Ledel Guest on 17th November 2021 06:15:14 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 azziedev_jeremy
  9. -- -----------------------------------------------------
  10.  
  11. -- -----------------------------------------------------
  12. -- Schema azziedev_jeremy
  13. -- -----------------------------------------------------
  14. CREATE SCHEMA IF NOT EXISTS `azziedev_jeremy` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
  15. USE `azziedev_jeremy` ;
  16.  
  17. -- -----------------------------------------------------
  18. -- Table `azziedev_jeremy`.`Employee`
  19. -- -----------------------------------------------------
  20. CREATE TABLE IF NOT EXISTS `azziedev_jeremy`.`Employee` (
  21.   `Fname` VARCHAR(45) NULL DEFAULT NULL,
  22.   `Minit` VARCHAR(45) NULL DEFAULT NULL,
  23.   `Lname` VARCHAR(45) NULL DEFAULT NULL,
  24.   `Ssn` INT(9) NOT NULL,
  25.   `Bdate` DATE NULL DEFAULT NULL,
  26.   `Address` VARCHAR(45) NULL DEFAULT NULL,
  27.   `Sex` VARCHAR(45) NULL DEFAULT NULL,
  28.   `Super_ssn` INT(9) NOT NULL,
  29.   `Dno` VARCHAR(45) NULL DEFAULT NULL,
  30.   PRIMARY KEY (`Ssn`, `Super_ssn`),
  31.   INDEX `Super_ssn_idx` (`Super_ssn` ASC) VISIBLE,
  32.   CONSTRAINT `Super_ssn`
  33.     FOREIGN KEY (`Super_ssn`)
  34.     REFERENCES `azziedev_jeremy`.`Employee` (`Ssn`)
  35.     ON DELETE NO ACTION
  36.     ON UPDATE NO ACTION)
  37. ENGINE = InnoDB
  38. DEFAULT CHARACTER SET = utf8
  39. COLLATE = utf8_unicode_ci;
  40.  
  41.  
  42. -- -----------------------------------------------------
  43. -- Table `azziedev_jeremy`.`DEPARTMENT`
  44. -- -----------------------------------------------------
  45. CREATE TABLE IF NOT EXISTS `azziedev_jeremy`.`DEPARTMENT` (
  46.   `DNAME` VARCHAR(45) NULL DEFAULT NULL,
  47.   `DNUMBER` INT(1) NOT NULL,
  48.   `MGRSSN` INT(9) NULL DEFAULT NULL,
  49.   `MGRSTARTDATE` DATE NULL DEFAULT NULL,
  50.   PRIMARY KEY (`DNUMBER`),
  51.   INDEX `Mgr_ssn_idx` (`MGRSSN` ASC) VISIBLE,
  52.   CONSTRAINT `Mgr_ssn`
  53.     FOREIGN KEY (`MGRSSN`)
  54.     REFERENCES `azziedev_jeremy`.`Employee` (`Ssn`)
  55.     ON DELETE NO ACTION
  56.     ON UPDATE NO ACTION)
  57. ENGINE = InnoDB
  58. DEFAULT CHARACTER SET = utf8
  59. COLLATE = utf8_unicode_ci;
  60.  
  61.  
  62. -- -----------------------------------------------------
  63. -- Table `azziedev_jeremy`.`DEPT_LOCATIONS`
  64. -- -----------------------------------------------------
  65. CREATE TABLE IF NOT EXISTS `azziedev_jeremy`.`DEPT_LOCATIONS` (
  66.   `DNUMBER` INT(1) NOT NULL,
  67.   `DLOCATION` VARCHAR(45) NOT NULL,
  68.   PRIMARY KEY (`DNUMBER`, `DLOCATION`),
  69.   CONSTRAINT `Dnumber`
  70.     FOREIGN KEY (`DNUMBER`)
  71.     REFERENCES `azziedev_jeremy`.`DEPARTMENT` (`DNUMBER`)
  72.     ON DELETE NO ACTION
  73.     ON UPDATE NO ACTION)
  74. ENGINE = InnoDB
  75. DEFAULT CHARACTER SET = utf8
  76. COLLATE = utf8_unicode_ci;
  77.  
  78.  
  79. -- -----------------------------------------------------
  80. -- Table `azziedev_jeremy`.`Dependent`
  81. -- -----------------------------------------------------
  82. CREATE TABLE IF NOT EXISTS `azziedev_jeremy`.`Dependent` (
  83.   `Essn` INT(9) NOT NULL,
  84.   `Dependent_name` VARCHAR(45) NOT NULL,
  85.   `Sex` VARCHAR(45) NULL DEFAULT NULL,
  86.   `Bdate` DATE NULL DEFAULT NULL,
  87.   `Relationship` VARCHAR(45) NULL DEFAULT NULL,
  88.   PRIMARY KEY (`Essn`, `Dependent_name`),
  89.   CONSTRAINT `Essn`
  90.     FOREIGN KEY (`Essn`)
  91.     REFERENCES `azziedev_jeremy`.`Employee` (`Ssn`)
  92.     ON DELETE NO ACTION
  93.     ON UPDATE NO ACTION)
  94. ENGINE = InnoDB
  95. DEFAULT CHARACTER SET = utf8
  96. COLLATE = utf8_unicode_ci;
  97.  
  98.  
  99. -- -----------------------------------------------------
  100. -- Table `azziedev_jeremy`.`Project`
  101. -- -----------------------------------------------------
  102. CREATE TABLE IF NOT EXISTS `azziedev_jeremy`.`Project` (
  103.   `Pname` VARCHAR(45) NULL DEFAULT NULL,
  104.   `Pnumber` INT(2) NOT NULL,
  105.   `Plocation` VARCHAR(45) NOT NULL DEFAULT NULL,
  106.   `Dnum` INT(1) NULL DEFAULT NULL,
  107.   PRIMARY KEY (`Pnumber`, `Plocation`),
  108.   INDEX `Dnumber_idx` (`Dnum` ASC) VISIBLE,
  109.   CONSTRAINT `Dnumber`
  110.     FOREIGN KEY (`Dnum`)
  111.     REFERENCES `azziedev_jeremy`.`DEPARTMENT` (`DNUMBER`)
  112.     ON DELETE NO ACTION
  113.     ON UPDATE NO ACTION,
  114.   CONSTRAINT `Plocation`
  115.     FOREIGN KEY ()
  116.     REFERENCES `azziedev_jeremy`.`DEPT_LOCATIONS` ()
  117.     ON DELETE NO ACTION
  118.     ON UPDATE NO ACTION)
  119. ENGINE = InnoDB
  120. DEFAULT CHARACTER SET = utf8
  121. COLLATE = utf8_unicode_ci;
  122.  
  123.  
  124. -- -----------------------------------------------------
  125. -- Table `azziedev_jeremy`.`Works_On`
  126. -- -----------------------------------------------------
  127. CREATE TABLE IF NOT EXISTS `azziedev_jeremy`.`Works_On` (
  128.   `Essn` INT(9) NOT NULL,
  129.   `Pno` INT(2) NOT NULL,
  130.   `Hours` DECIMAL(1,0) NULL DEFAULT NULL,
  131.   PRIMARY KEY (`Essn`, `Pno`),
  132.   INDEX `Pno_idx` (`Pno` ASC) VISIBLE,
  133.   CONSTRAINT `Essn`
  134.     FOREIGN KEY (`Essn`)
  135.     REFERENCES `azziedev_jeremy`.`Employee` (`Ssn`)
  136.     ON DELETE NO ACTION
  137.     ON UPDATE NO ACTION,
  138.   CONSTRAINT `Pno`
  139.     FOREIGN KEY (`Pno`)
  140.     REFERENCES `azziedev_jeremy`.`Project` (`Pnumber`)
  141.     ON DELETE NO ACTION
  142.     ON UPDATE NO ACTION)
  143. ENGINE = InnoDB
  144. DEFAULT CHARACTER SET = utf8
  145. COLLATE = utf8_unicode_ci;
  146.  
  147.  
  148. SET SQL_MODE=@OLD_SQL_MODE;
  149. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  150. 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