0wvEPgZ9

1-- -----------------------------------------------------
2-- Table `jupitercollege`.`faculty`
3-- -----------------------------------------------------
4CREATE TABLE IF NOT EXISTS `jupitercollege`.`faculty` (
5  `id` INT NOT NULL AUTO_INCREMENT,
6  `name` VARCHAR(45) NOT NULL,
7  `dept` VARCHAR(10) NOT NULL,
8  `email` VARCHAR(45) NOT NULL,
9  PRIMARY KEY (`id`),
10  UNIQUE INDEX `email_UNIQUE` (`email` ASC))
11ENGINE = InnoDB;
12
13
14-- -----------------------------------------------------
15-- Table `jupitercollege`.`grad_program`
16-- -----------------------------------------------------
17CREATE TABLE IF NOT EXISTS `jupitercollege`.`grad_program` (
18  `id` INT NOT NULL AUTO_INCREMENT,
19  `name` VARCHAR(45) NOT NULL,
20  `dept` VARCHAR(10) NOT NULL,
21  `phone` VARCHAR(12) NULL DEFAULT 'UNKNOWN',
22  `email` VARCHAR(45) NULL DEFAULT 'UNKNOWN',
23  `director_id` INT NOT NULL,
24  PRIMARY KEY (`id`),
25  INDEX `director_id_idx` (`director_id` ASC),
26  UNIQUE INDEX `email_UNIQUE` (`email` ASC),
27  UNIQUE INDEX `name_UNIQUE` (`name` ASC),
28  CONSTRAINT `director_id`
29    FOREIGN KEY (`director_id`)
30    REFERENCES `jupitercollege`.`faculty` (`id`)
31    ON DELETE SET NULL
32    ON UPDATE NO ACTION)
33ENGINE = InnoDB;