course-project-codeville/DatabaseREADME at dev · CSE-Courses/course-project-codeville · 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
37
38
39
40
41
42
43
44
45
46
47
Database structure is as follows:

courses= Scraped data from UB about courses

dname | dabbr | classid | title | section | type | days | time | room | location | instructor


friends= Stores relations between users(0 = accepted(friends), 1 = request sent, 2 = request pending)

email | friend_email | status


majors= Scraped data from UB about majors

major | id


personal_details= stores users personal details

first_name | last_name | dob | gender


usercourses= stores users connection with courses

email | classid


useredu= Stores the users educational details

email | major | standing


users= Stores users email,password,verification status and id

email | password | isverified | id | firstlogin


verify= Stores the info needed to verify email

email | token