2021-gpu-is-mine
2021-gpu-is-mine copied to clipboard
Flyway의 제약조건을 명시적으로 수정한다.
alter table gpu_board
add constraint FKmlaxkpi5wl3aj52p17vp85i3a foreign key (gpu_server_id) references gpu_server (id);
alter table gpu_server
add constraint FK1rhos9cjtoor5ie1u6ltaveds foreign key (lab_id) references lab (id);
alter table job
add constraint FKg8a9jo8un6ps9dqlqb7ijxc2d foreign key (gpu_board_id) references gpu_board (id);
alter table job
add constraint FKdt0g2w772iceic8f57vwd590s foreign key (member_id) references member (id);
alter table member
add constraint FKbxh2eojsjc94cmeo0fn5uvnwu foreign key (lab_id) references lab (id);
alter table gpu_server
add constraint UKixn8qpho3d70myk9flqim3ugv unique key (name,lab_id);
alter table lab
add constraint UK_j9qsyhoxrgtbt56xq53bvggjw unique key (name);
alter table member
add constraint UK_mbmcqelty0fbrvxp1q58dn57t unique key (email);
현재의 제약 조건은 그 의미가 명확하게 들어나지 않아, 이슈 핸들링하는데 어려움이 있습니다
.