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 EXIS…