2021-gpu-is-mine icon indicating copy to clipboard operation
2021-gpu-is-mine copied to clipboard

Flyway의 제약조건을 명시적으로 수정한다.

Open wannte opened this issue 3 years ago • 0 comments

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);

현재의 제약 조건은 그 의미가 명확하게 들어나지 않아, 이슈 핸들링하는데 어려움이 있습니다 Screenshot from 2021-10-22 02-51-36 .

wannte avatar Oct 22 '21 04:10 wannte