api/src/main/resources/db/migration/V7__create-table-appointments.sql


1
2
3
4
5
6
7
8
9
10
11
12

create table appointments
(
    id    bigint not null auto_increment,
    doctor_id bigint not null,
    patient_id bigint not null,
    date datetime not null,

    primary key (id),
    constraint fk_appointments_doctor_id foreign key(doctor_id) references doctors(id),
    constraint fk_appointments_patient_id foreign key(patient_id) references patients(id)

);