-
Notifications
You must be signed in to change notification settings - Fork 1
/
models.txt
45 lines (41 loc) · 1.26 KB
/
models.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
CREATE TABLE `users` (
`uid` int(11) NOT NULL,
`f_name` varchar(255) NOT NULL,
`l_name` varchar(255) DEFAULT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`interests` varchar(255) DEFAULT NULL,
`profession` varchar(255) DEFAULT NULL
)
CREATE TABLE `resources` (
`rid` int(11) NOT NULL,
`type` varchar(255) DEFAULT NULL,
`category` varchar(155) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`rlink` text DEFAULT NULL,
`eta_in_hrs` int(11) DEFAULT NULL,
`counter` int(11) DEFAULT NULL,
`isPublic` tinyint(1) DEFAULT 1
)
CREATE TABLE `roadmap` (
`rmid` int(11) NOT NULL,
`uid` int(11) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`category` varchar(255) DEFAULT NULL,
`motivation` text DEFAULT NULL,
`endgoal` text DEFAULT NULL,
`start_date` datetime DEFAULT current_timestamp(),
`deadline` datetime DEFAULT NULL,
`completion_date` datetime DEFAULT NULL,
`achievement_proof` text DEFAULT NULL,
`isPublic` tinyint(1) DEFAULT 0
)
CREATE TABLE `roadmap_checkpoints` (
`rmid` int(11) NOT NULL,
`uid` int(11) DEFAULT NULL,
`rid` int(11) NOT NULL,
`sequence` int(11) NOT NULL,
`completion_date` datetime DEFAULT NULL,
`completion_proof` text DEFAULT NULL,
`share_linkedin` tinyint(1) DEFAULT 0
)