Class Person
@ManyToMany
public Set<Bank> getBankSet() {
return bankSet;
}
Class Bank
@ManyToMany(mappedBy="bankSet")
public Set<Person> getPersonSet() {
return personSet;
}
CREATE TABLE `bank` (
`id` varchar(32) NOT NULL,
`createDate` datetime DEFAULT NULL,
`modifyDate` datetime DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `person` (
`id` varchar(32) NOT NULL,
`createDate` datetime DEFAULT NULL,
`modifyDate` datetime DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `person_bank` (
`personSet_id` varchar(32) NOT NULL,
`bankSet_id` varchar(32) NOT NULL,
PRIMARY KEY (`personSet_id`,`bankSet_id`),
KEY `FKE699F0E6747D6B54` (`bankSet_id`),
KEY `FKE699F0E6D0B93DC6` (`personSet_id`),
CONSTRAINT `FKE699F0E6D0B93DC6` FOREIGN KEY (`personSet_id`) REFERENCES `person` (`id`),
CONSTRAINT `FKE699F0E6747D6B54` FOREIGN KEY (`bankSet_id`) REFERENCES `bank` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;