-
Notifications
You must be signed in to change notification settings - Fork 0
/
stackoverflow.txt
69 lines (58 loc) · 1.18 KB
/
stackoverflow.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
* User:
- Name
- Profile Picture
- Age
- Year Joined
- Reputation
- Id (Primary Key)
//- Followers
//- Location
* Question:
- Question Id (Primary Key)
- User Id (Foreign Key)
- Time
//- UTC time (Also local)
- Content
- Upvotes
- Downvotes
- Tags
* Vote:
- Type (Boolean)
- Id (Primary)
- User Id (Foreign)
- Question Id
- Comment Id
- Answer Id
* Answer:
- Answer Id (Primary Key)
- Question Id (Foreign Key)
- Upvotes
- Downvotes
- User Id (Foreign Key)
- Accepted (Boolean)
* Comments (Only 1 level):
- Comment Id (Primary key)
- Question Id (Foreign Key)
- Answer Id (Foreign Key)
- User Id (Primary Key)
"""* Followers:
- User Id (Primary Key)
- Follower Id (Foreign Key, backref)"""
* Login:
- Using wtforms, flask-login (Own)
//- OAuth Based (Google, Facebook, Twitter) [Maybe?]
- Session Handline done by flask-login package
* Database:
//- Will support migrations (Upgrade, Downgrade)
- Most Probably SQllite/ MySQL (Must)
** Not included in Schema **
* Pagination:
- For post there will be multiple pages
* Index:
- Options (Answered/Unanswered/All)
- Index will show unanswered questions
* Frameworks Used:
- Flask
- Bootstrap
- jQuery
- Others