-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.txt
73 lines (43 loc) · 1.46 KB
/
db.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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
clients
=======
phone|name|email|id_o_b|last_donation_date |city_id | blood_type_id| password |pin_code (one client - many blood_type)
blood_types cities governates categories
========== ====== ====== ======
name name|governate_id name
posts
=====
title|image|content|category_id
donation_requests
=================
patient_name | patient_phone | patient_age | bags_num | hospital_address| hospital_name | notes |longitude |latitude (decimal 10,8)
blood_type_id |city_id | client_id
notifications (one to one)
============
content ,title , donation_request_id
contacts
========
name , email , phone , subject , message
settings
========
notification_settings_text , about_app , phone , email , fb_link , tw_link , insta_link , whatsapp_link
client_post
===========
client_id |post_id |is_fav
client_notification
===================
client_id | notification_id | is_read
blood_type_client (notification setting)
==================
client_id | blood_type_id
client_governorate: (notification setting)
===================
client_id | governorate_id
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
login
register
cities
governorates
/edit-profile
/notification-setting
/posts-with filter(category) - search