OrgPulse/database.sql at main · Sthuthi11/OrgPulse · GitHub

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
CREATE TABLE registration (
    username VARCHAR(20) PRIMARY KEY,
    password varchar(20),
    email varchar(50),
    type varchar(20)
);
CREATE TABLE login_details (
    username VARCHAR(20) PRIMARY KEY,
    password varchar(20),
    login_time datetime,
usertype varchar(20),
    FOREIGN KEY (username) REFERENCES registration(username) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE TABLE patients (
    username VARCHAR(20) PRIMARY KEY,
    place	varchar(100),
	blood_group	varchar(10),
	contact	varchar(20)	,
	organ	varchar(10),
	age	int(3),
	usertype	varchar(20)	,
    FOREIGN KEY (username) REFERENCES registration(username) ON DELETE CASCADE ON UPDATE CASCADE

);

CREATE TABLE donor (
    username VARCHAR(20) PRIMARY KEY,
    place	varchar(100),
	blood_group	varchar(10),
	contact	varchar(20)	,
	organ	varchar(10),
	age	int(3),
	usertype	varchar(20)	,
    FOREIGN KEY (username) REFERENCES registration(username) ON DELETE CASCADE ON UPDATE CASCADE
);