y28mELwd

1-- -----------------------------------------------------
2    -- Table `mydb`.`Employee`
3    -- -----------------------------------------------------
4    CREATE TABLE IF NOT EXISTS `mydb`.`Employee` (
5      `EmployeeID` INT NOT NULL,
6      `Employee_LastName` VARCHAR(45) NOT NULL,
7      `Employee_FirstName` VARCHAR(45) NOT NULL,
8      `Status` VARCHAR(45) NOT NULL,
9      `Rank_Rate` VARCHAR(45) NOT NULL,
10      `Recall_Number` VARCHAR(45) NOT NULL,
11      `Recall_Address` VARCHAR(45) NOT NULL,
12      `Work_Email` VARCHAR(45) NOT NULL,
13      `Personal_Email` VARCHAR(45) NULL,
14      `Gender` VARCHAR(45) NOT NULL,
15      `Race` VARCHAR(45) NOT NULL,
16      `Number_of_Dependents` VARCHAR(45) NULL,
17      `Department_Department_Name` VARCHAR(45) NOT NULL,
18      `Building_Building_Name` VARCHAR(45) NOT NULL,
19      PRIMARY KEY (`EmployeeID`),
20      INDEX `fk_Employee_Department_idx` (`Department_Department_Name` ASC) VISIBLE,
21      INDEX `fk_Employee_Building1_idx` (`Building_Building_Name` ASC) VISIBLE,
22      CONSTRAINT `fk_Employee_Department`
23        FOREIGN KEY (`Department_Department_Name`)
24        REFERENCES `mydb`.`Department` (`Department_Name`)
25        ON DELETE NO ACTION
26        ON UPDATE NO ACTION,
27      CONSTRAINT `fk_Employee_Building1`
28        FOREIGN KEY (`Building_Building_Name`)
29        REFERENCES `mydb`.`Building` (`Building_Name`)
30        ON DELETE NO ACTION
31        ON UPDATE NO ACTION)
32    ENGINE = InnoDB