Campus Recruit
Campus Recruit
Campus Recruit
Level 0
Level 1
(Level 1.1)
(Level 1.2)
(Level 1.3)
Table Design
Login
Column name Datatype/Column size Description
id Integer Primary key, not null
username Varchar(200) Not null
password Varchar(200) Not null
usertype Varchar(200) Not null
User
Column name Datatype/Column size Description
id Integer Primary key, not null
LOGIN Integer Foreign key, not null
name Varchar(200) Not null
dob Varchar(200) Not null
age Integer Not null
house_name Varchar(200) Not null
place Varchar(200) Not null
post Varchar(200) Not null
pin Varchar(200) Not null
district Varchar(200) Not null
email Varchar(200) Not null
phoneno BigInt Not null
gender Varchar(200) Not null
Portfolio management
Column name Datatype/Column size Description
id Integer Primary key, not null
USER Integer Foreign key, not null
file Varchar(200) Not null
filetype Varchar(200) Not null
date Varchar(200) Not null
Company
Column name Datatype/Column size Description
id Integer Primary key, not null
LOGIN Integer Foreign key, not null
companyname Varchar(200) Not null
details Varchar(200) Not null
latitude Varchar(200) Not null
longtitude Varchar(200) Not null
email Varchar(200) Not null
Phoneno BigInt Not null
Skill_qualification
Column name Datatype/Column size Description
id Integer Primary key, not null
type Varchar(200) Not null
qualification_or_skill Varchar(200) Not null
user_qualification
Column name Datatype/Column size Description
id Integer Primary key, not null
college_school Varchar(200) Not null
SKILL_QUALIFICATION Integer Foreign key, not null
USER Integer Foreign key, not null
percentage Varchar(200) Not null
Experience
Column name Datatype/Column size Description
id Integer Primary key, not null
USER Integer Foreign key, not null
company Varchar(200) Not null
post Varchar(200) Not null
date Varchar(200) Not null
about Varchar(200) Not null
hobby_about_post_language
Column name Datatype/Column size Description
id Integer Primary key, not null
USER Integer Foreign key, not null
hobby_about_post Varchar(200) Not null
type Varchar(200) Not null
Skill
Column name Datatype/Column size Description
id Integer Primary key, not null
USER Integer Foreign key, not null
USER_QUALIFICATION Integer Foreign key, not null
name Varchar(200) Not null
board Varchar(200) Not null
percentage Varchar(200) Not null
year Varchar(200) Not null
Vacancy
Column name Datatype/Column size Description
id Integer Primary key, not null
COMPANY Integer Foreign key, not null
experience Varchar(200) Not null
language Varchar(200) Not null
Locate Varchar(200) Not null
salary_package Integer Not null
age_limit Integer Not null
details Varchar(200) Not null
last date Varchar(200) Not null
Candidate
Column name Datatype/Column size Description
id Integer Primary key, not null
USER Integer Foreign key, not null
VACANCY Integer Foreign key, not null
date Varchar(200) Not null
interview_date Varchar(200) Not null
interview_link Varchar(200) Not null
status Varchar(200) Not null
Rating
Column name Datatype/Column size Description
id Integer Primary key, not null
USER Integer Foreign key, not null
COMPANY Integer Foreign key, not null
rating Varchar(200) Not null
date Varchar(200) Not null
News management
Column name Datatype/Column size Description
id Integer Primary key, not null
date Varchar(200) Not null
details Varchar(200) Not null
heading Varchar(200) Not null
Vacancy_qualification
Column name Datatype/Column size Description
id Integer Primary key, not null
SKILL_QUALIFICATION Integer Foreign key, not null
VACANCY Integer Foreign key, not null