api/src/main/resources/db/migration/V1__create-table-doctors.sql


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

create table doctors(

                        id bigint not null auto_increment,
                        name varchar(100) not null,
                        email varchar(100) not null unique,
                        specialty varchar(100) not null,
                        address_line1 varchar(100) not null,
                        address_line2 varchar(100) not null,
                        postal_code varchar(9) not null,
                        state varchar(100) not null,
                        city varchar(100) not null,

                        primary key(id)

);