DucpQQnm

1-- -----------------------------------------------------
2-- Table `Proj`.`Rrepresent`
3-- -----------------------------------------------------
4CREATE TABLE IF NOT EXISTS `Proj`.`Rrepresent` (
5  `Client_C.ID` INT NOT NULL,
6  `Lawyer_L.ID` INT NOT NULL,
7  `visit_date` DATE NOT NULL,
8  `visit_time` TIME NOT NULL,
9  INDEX `fk_Client_has_Lawyer_Lawyer1_idx` (`Lawyer_L.ID` ASC),
10  INDEX `fk_Client_has_Lawyer_Client1_idx` (`Client_C.ID` ASC),
11  CONSTRAINT `fk_Client_has_Lawyer_Client1`
12    FOREIGN KEY (`Client_C.ID`)
13    REFERENCES `Proj`.`Client` (`C.ID`)
14    ON DELETE NO ACTION
15    ON UPDATE SET NULL,
16  CONSTRAINT `fk_Client_has_Lawyer_Lawyer1`
17    FOREIGN KEY (`Lawyer_L.ID`)
18    REFERENCES `Proj`.`Lawyer` (`L.ID`)
19    ON DELETE NO ACTION
20    ON UPDATE NO ACTION)
21ENGINE = InnoDB
22	
23CREATE TABLE IF NOT EXISTS `Proj`.`Rrepresent` (
24      `Client_C.ID` INT NOT NULL,
25      `Lawyer_L.ID` INT NOT NULL,
26      `visit_date` DATE NOT NULL,
27      `visit_time` TIME NOT NULL,
28      INDEX `fk_Client_has_Lawyer_Lawyer1_idx` (`Lawyer_L.ID` ASC),
29      INDEX `fk_Client_has_Lawyer_Client1_idx` (`Client_C.ID` ASC),
30      CONSTRAINT `fk_Client_has_Lawyer_Client1`
31        FOREIGN KEY (`Client_C.ID`)
32        REFERENCES `Proj`.`Client` (`C.ID`)
33        ON DELETE NO ACTION
34        ON UPDATE SET NULL,
35      CONSTRAINT `fk_Client_has_Lawyer_Lawyer1`
36        FOREIGN KEY (`Lawyer_L.ID`)
37        REFERENCES `Proj`.`Lawyer` (`L.ID`)
38        ON DELETE NO ACTION
39        ON UPDATE NO ACTION)
40    ENGINE = InnoDB