-
Notifications
You must be signed in to change notification settings - Fork 1
/
sql_tables
54 lines (39 loc) · 1.66 KB
/
sql_tables
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
-- CREATE DATABASE sample;
SELECT user_id from sample.user;
CREATE TABLE sample.user(
user_id VARCHAR(40) primary key,
user_name varchar(100) not null,
email varchar(100) not null,
last_login varchar(40),
created_at date
);
select * from sample.user;
select * from sample.userdetails;
create table sample.userdetails(
userdet_id int primary key auto_increment,
bio varchar(250) default null,
pic_path varchar(45) default null,
age int default null,
fcm_token varchar(245),
pincode int default null,
usercontact bigint default null,
lattitude float default null,
longitude float default null,
address varchar(45),
gender varchar(45) default null,
blood_group varchar(45) default null,
martial_status varchar(45) default null,
weight int default null,
emergency_contact bigint default null,
past_medication varchar(800),
user_user_id varchar(40) default null,
foreign key (user_user_id) references user (user_id));
CREATE TABLE sample.my_caretakers(
c_id varchar(40) primary key,
patient_name varchar(40) not null,
req_status tinyint default 0,
caretaker_id varchar(40) not null,
patient_id varchar(40) not null,
caretaker_username varchar(40) not null,
created_at date not null);
SELECT * FROM sample.my_caretakers;