Tbl_login

[Link] Column name Data type length Description

1 Login_id integer 10 Primary key
2 username varchar 20 Username of
user
3 password varchar 20 Password of user
4 Role_type varchar 20 Role of user
5 status integer 10 status

Tbl_company
[Link] Column name Data type length Description
1 cid integer 10 Primary key
2 Login_id integer 10 Foreign key from
Tbl_login
3 Company_name varchar 20 Name of
company
4 address varchar 20 Address of
company
5 city varchar 20 Location of
company
6 Pin_code integer 20 Pin code of
company
7 website varchar 20 Company
website
8 email varchar 20 Email id
9 status integer 10 Status
Tbl_jobseeker
[Link] Column name Data type length Description
1 User_id integer 10 Primary key
2 Login_id integer 10 Foreign key from
Tbl_login
3 name varchar 20 Name of
jobseeker
4 gender varchar 20 Gender of
jobseeker
5 DOB varchar 20 Date of birth
6 address varchar 20 Address of
jobseeker
7 city varchar 20 Location of
jobseeker
8 pincode integer 20 Pincode
9 email varchar 20 Email-Id
10 mobile integer 20 Contact number
11 status integer 10 status

Tbl_job
[Link] Column name Data type length Description
1 job_id integer 10 Primary key
2 cid integer 10 Foreign key from
Tbl_company
3 Category_id integer 20 Job category
4 Qualification_id integer 20 Minimum
Qualification
5 Job_title varchar 20 Date of birth
6 salary varchar 20 Address of
jobseeker
7 description varchar 20 Location of
jobseeker
8 Last_date date 20 Expiry date for
applying job
9 status integer 10 status
Tbl_jobseeker
[Link] Column name Data type length Description
1 reg_id integer 10 Primary key
2 Login_id integer 10 Foreign key from
Tbl_login
3 Name varchar 20 Name of
jobseeker
4 Gender varchar 20 Gender of
jobseeker
5 DOB varchar 20 Date of birth
6 Address varchar 20 Address of
jobseeker
7 City varchar 20 Location of
jobseeker
8 Pincode integer 20 Pincode
9 Email varchar 20 Email-Id
10 Mobile integer 20 Contact number
11 Status integer 10 status
Tbl_education
[Link] Column name Data type length Description
1 edu_id integer 10 Primary key
2 reg_id integer 10 Foreign key from
Tbl_jobseeker
3 Branch_id integer 10 Foreign key from
Tbl_branch
4 sem_id integer 10 Foreign key from
Tbl_semester
5 Resume_id integer 10 Foreign key from
Tbl_resume
6 Reg_no varchar 20 Register number
7 Adm_no varchar 20 Admission
number
8 10th float 20 CGPA in 10th
9 12th float 20 CGPA in 12th
10 CGPA float 20 Current CGPA
11 status integer 10 status

Tbl_resume

[Link] Column name Data type length Description

1 Resume_id integer 10 Primary key
2 edu_id integer 10 Foreign key from
Tbl_education
3 resume varchar 20 Resume of
jobseeker
4 status integer 10 status
Tbl_mock_test
[Link] Column name Data type length Description
1 Qn_no integer 10 Primary key
2 cid integer 10 Foreign key from
Tbl_company
3 Question varchar 20 question
4 Choice 1 varchar 20 Choice 1
5 Choice 2 varchar 20 Choice 2
6 Choice 3 varchar 20 Choice 3
7 answer varchar 20 Correct answer
8 status integer 10 status

Tbl_notification
[Link] Column name Data type length Description
1 Notn_id integer 10 Primary key
2 Job_id integer 10 Foreign key from
Tbl_job
3 notification varchar 20 question
4 date date 20 Date
5 status integer 10 status

Tbl_feedback
[Link] Column name Data type length Description
1 feedback_id integer 10 Primary key
2 Reg_id integer 10 Foreign key from
Tbl_jobseeker
3 feedback varchar 20 Feedback from
jobseeker
4 status integer 10 status
Tbl_category
[Link] Column name Data type length Description
1 category_id integer 10 Primary key
2 Category_name varchar 20 Job category
3 status integer 10 status

Tbl_qualification
[Link] Column name Data type length Description
1 qualification_id integer 10 Primary key
2 qualification varchar 20 Job qualification
3 status integer 10 status

Tbl_branch
[Link] Column name Data type length Description
1 Branch_id integer 10 Primary key
2 Branch_name varchar 20 Branch name
3 status integer 10 status

Tbl_semester
[Link] Column name Data type length Description
1 sem_id integer 10 Primary key
2 semester varchar 20 semester
3 status integer 10 status
Tbl_applied_jobs
[Link] Column name Data type length Description
1 apply_id integer 10 Primary key
2 Edu_id integer 10 Foreign key from
Tbl_education
3 Job_id integer 10 Foreign key from
Tbl_job
4 Application_status varchar 10 Approved/rejected
5 comments varchar 20 Comments
6 status integer 10 status

Tbl_placement_papers

[Link] Column name Data type length Description

1 paper_id integer 10 Primary key
2 cid integer 10 Foreign key from
Tbl_company
3 file varchar 20 Placement paper
file
4 status integer 10 status