blob: a0cc01c1f4334dccc8a83da8065a1ef1d0474c21 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
create table patients(
id bigint not null auto_increment,
name varchar(100) not null,
email varchar(100) not null unique,
phone varchar(20) not null,
ssn varchar(11) not null unique,
address_line1 varchar(100) not null,
address_line2 varchar(100) not null,
postal_code varchar(9) not null,
state char(100) not null,
city varchar(100) not null,
primary key(id)
);
|
