This is an example for a
Bidirectional relationship between Java entities in a REST web service with the
Jackson API.
1- Assume we have a bidirectional relationship between two entities Parent and Child.
2- Using MySQL workbench to generate the SQL schema file for this two tables.
DROP SCHEMA IF EXISTS `bidirectional_schema` ;
CREATE SCHEMA IF NOT EXISTS `bidirectional_schema` DEFAULT CHARACTER SET utf8 ;
USE `bidirectional_schema` ;
-- -----------------------------------------------------
-- Table `bidirectional_schema`.`PARENT`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `bidirectional_schema`.`PARENT` ;
CREATE TABLE IF NOT EXISTS `bidirectional_schema`.`PARENT` (
`PARENT_ID` INT NOT NULL ,
`PARENT_CONTENT` VARCHAR(45) NULL ,
PRIMARY KEY (`PARENT_ID`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `bidirectional_schema`.`CHILD`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `bidirectional_schema`.`CHILD` ;
CREATE TABLE IF NOT EXISTS `bidirectional_schema`.`CHILD` (
`CHILD_ID` INT NOT NULL ,
`CHILD_CONTENT` VARCHAR(45) NULL ,
`PARENT_PARENT_ID` INT NOT NULL ,
PRIMARY KEY (`CHILD_ID`) ,
INDEX `fk_CHILD_PARENT_idx` (`PARENT_PARENT_ID` ASC) ,
CONSTRAINT `fk_CHILD_PARENT`
FOREIGN KEY (`PARENT_PARENT_ID` )
REFERENCES `bidirectional_schema`.`PARENT` (`PARENT_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
