Подскажите правильно ли я соединил между собой 1 13 19 как на картинке
id_pri -1
id_cam-13
id_per - 19
create table prisoner (
id_pri int(10),
...
-> id_camers int(10),
-> id_crimes int(10),
-> id_vis int(10),
-> PRIMARY KEY (id_pri))
create table camers (
id_cam int(10) AUTO_INCREMENT,
...
id_pri int(10),
id_personal int(10) PRIMARY KEY,
foreign key(id_pri) references prisoner (id_pri));
foreign key(id_camers) references prisoner (`id_camers`));
create table personal (
id_per int(10) AUTO_INCREMENT PRIMARY KEY,
...
foreign key(id_cam) references camers (id_cam));
