-
Notifications
You must be signed in to change notification settings - Fork 1
/
Database design.txt
82 lines (62 loc) · 1.2 KB
/
Database design.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
70
71
72
73
74
75
76
77
78
79
80
81
82
Menus: About, Contact, Categories, Home,
Tables:
-User
->name
->email
->role
->phone
->photo
->password
-Setting
->fb_url
->twitter_url
->instagram_url
->footer_description
->address
->phone
->email
-Category
->name
-Post
->user_id
->title
->description
->image
->category_id
-Tag
->name
-post_tag
->post_id
->tag_id
-Comment
->user_id
->post_id
->comment_description
-Reply
->user_id
->comment_id
->reply_description
-About
->history_title
->history_description
->history_image
->mv_title
->mv_description
->mv_photo
-Team
->name
->position
->photo
->bio
-Message
->name
->email
->subject
->msg
--------------
User 1 ----- *Post
User 1 ----- *comment
User 1 ----- *reply
post 1 ----- *comment
post * ----- *tag
comment 1 ----- *reply