2p5DEESy

1"parents" table (id, name)
2"kids" table (id, name, parents_id)
3	
4CREATE TABLE IF NOT EXISTS `db`.`parents` (
5  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
6  `name` VARCHAR(45) NOT NULL,
7  `uuid` VARCHAR(45) NOT NULL,
8  PRIMARY KEY (`id`),
9  UNIQUE INDEX `uuid_UNIQUE` (`uuid` ASC),
10  UNIQUE INDEX `name_UNIQUE` (`name` ASC))
11ENGINE = InnoDB;
12
13
14-- -----------------------------------------------------
15-- Table `db`.`kids`
16-- -----------------------------------------------------
17DROP TABLE IF EXISTS `db`.`kids` ;
18
19CREATE TABLE IF NOT EXISTS `db`.`kids` (
20  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
21  `name` VARCHAR(450) NOT NULL,
22  `parents_id` INT UNSIGNED NOT NULL,
23  PRIMARY KEY (`id`, `parents_id`),
24  UNIQUE INDEX `name_UNIQUE` (`name` ASC),
25  INDEX `fk_kids_parents_idx` (`parents_id` ASC),
26  CONSTRAINT `fk_kids_parents`
27    FOREIGN KEY (`parents_id`)
28    REFERENCES `db`.`parents` (`id`)
29    ON DELETE CASCADE
30    ON UPDATE NO ACTION)
31ENGINE = InnoDB;