Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class Person {
- String name;
- String surname;
- List<String> phones;
- }
- Tables:
- `phone`
- (
- `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
- `owner` INT UNSIGNED NOT NULL,
- `number` VARCHAR(50) NOT NULL,
- CONSTRAINT `PK_phone` PRIMARY KEY (`id`)
- )
- `person`
- (
- `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
- `surname` VARCHAR(150) NOT NULL,
- `name` VARCHAR(150) NOT NULL,
- CONSTRAINT `PK_phonebook` PRIMARY KEY (`id`)
- )
- ALTER TABLE `phone`
- ADD CONSTRAINT `FK_phone_person`
- FOREIGN KEY (`owner`) REFERENCES `person` (`id`) ON DELETE Cascade ON UPDATE Cascade
- ;
- SET FOREIGN_KEY_CHECKS=1 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement