-
Notifications
You must be signed in to change notification settings - Fork 0
/
ERdiagram.txt
33 lines (25 loc) · 1.51 KB
/
ERdiagram.txt
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
+-------------------+ +---------------------+ +---------------------+
| Users | | Donor Registration | | Blood Requests |
+-------------------+ +---------------------+ +---------------------+
| user_id (PK) |<------| donor_id (PK) | | request_id (PK) |
| email | | name | | email |
| pass | | fname | | message |
+-------------------+ | address | | name |
| city | | contact |
| age | +---------------------+
| bgroup |
| email |
| mno |
+---------------------+
|
|
|
v
+-------------------+ +---------------------+
| Out Stock Blood | | Exchange Blood |
+-------------------+ +---------------------+
| out_stock_id (PK) | | exchange_id (PK) |
| name | | name |
| mno | | mno |
| bname | | bgroup |
+-------------------+ +---------------------+