HiringModuleCI/Schema_Modelling at master · HackersSpirit/HiringModuleCI · 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
48
49
Database Modeling For Recruit

User Model :
  //id autoincr
  username
  email
  password
  team (choice field) FK teamname

Groups Model:
  //id autoincr
  teamname

Interviewer Model:
  //id autoincr
  UserObj


Candidate Model:
  //id autoincr
  Name
  Resume ( filefield )

Interview Model:
  //id autoincr
  CandidateObj
  Interview_DT (date-time)
  InterviewerObj
  Decision boolean default false
  Another_round? boolean false default

Question Model:
  //id autoincr
  QuestionText
  team

Feedback Model:
  id bigint(20) NOT NULL auto_increment Primary Key,
  ques_id int references Question(id),
  cand_id int references candidates(id),
  user_id int references users(username),
  CommentText varchar(200),
  rating int NOT NULL default 1

Report Model:
  //id autoincr
  CandidateObj
  array of related InterviewModel as history
  final_Decision