RESUMEVIEWERFINAL
IT IS A PROJECT TO
VIEW THE RESUMES FROM MONSTER.
POINTS
IT CAN GET A DETAILED
DESCRIPTION OF ALL THE AVAILABLE RESUMES ON THE DATABASE.
USERS GET LOGIN.
USERS HAVE SEARCHES
MADE IN GURU GRAB.
RESUMES ARE STORED IN
THE SQL DATABASE "RESUME".
THE SQL-DIAGRAM OF
RESUME DATABASE IS PRESENT IN HTML AND DOC FORMAT TO VIEW IN THE FOLDER
"RESUME-DATABASE-DIAGRAM".
RESUMES CAN BE
SEARCHED IN THE FOLLOWING MANNERS
1.CONSULTANT WISE
2.DATE WISE
3.CLIENT WISE
4.POSITION WISE
BY TWEAKING THE SEARCH
PARAMETERS THE RESULTS CAN BE SEEN IN THE TOP GRID (GRID A)
DATABASE AND TABLES
DESIGNATION_LIST
COLUMN_NAME
|
DATA_TYPE
|
LENGTH
|
ID
|
int
|
NULL
|
DNAME
|
nvarchar
|
255
|
STATUS
|
varchar
|
1
|
MONCATEGORYROLE
COLUMN_NAME
|
DATA_TYPE
|
LENGTH
|
CATEGORYID
|
int
|
NULL
|
ROLEID
|
int
|
NULL
|
ROLENM
|
varchar
|
50
|
MONRESUME
COLUMN_NAME
|
DATA_TYPE
|
LENGTH
|
PKID
|
numeric
|
NULL
|
PROCESSID
|
numeric
|
NULL
|
EMAILID
|
varchar
|
75
|
RESUMEHTML
|
text
|
2147483647
|
RESUMETEXT
|
text
|
2147483647
|
PROCESSDATE
|
datetime
|
NULL
|
MONSEARCH
COLUMN_NAME
|
DATA_TYPE
|
LENGTH
|
PKID
|
numeric
|
NULL
|
SEARCHNAME
|
varchar
|
500
|
KEYWORDNAMES
|
varchar
|
500
|
MINEXP
|
varchar
|
5
|
MAXEXP
|
varchar
|
5
|
MINSAL
|
varchar
|
50
|
MAXSAL
|
varchar
|
50
|
INDUSTRYIDS
|
varchar
|
500
|
LOCATIONIDS
|
varchar
|
500
|
CATEGORYIDS
|
varchar
|
500
|
ROLEIDS
|
varchar
|
500
|
DEGREEIDS
|
varchar
|
500
|
DEGREESPECIALIDS
|
varchar
|
500
|
IIMS
|
bit
|
NULL
|
IITS
|
bit
|
NULL
|
TOP_UNIVERSITY
|
bit
|
NULL
|
TOP_BUSINESS
|
bit
|
NULL
|
TOP_ENGG
|
bit
|
NULL
|
RESUMERANGEIDS
|
varchar
|
500
|
COMPANYNAMES
|
varchar
|
500
|
PROCESSED
|
char
|
1
|
EMAIL_ID
|
varchar
|
75
|
SEARCHDATE
|
datetime
|
NULL
|
USERLIST
COLUMN_NAME
|
DATA_TYPE
|
LENGTH
|
PKID
|
numeric
|
NULL
|
EMAILID
|
varchar
|
70
|
USERPASSWORD
|
varchar
|
70
|
PROCESSDATE
|
Date time
|
NULL
|
RESUMENUMER
|
numeric
|
NULL
|
KEYWORD_LIST
COLUMN_NAME
|
DATA_TYPE
|
LENGTH
|
ID
|
numeric
|
NULL
|
KEYWORD
|
varchar
|
500
|
WEIGHT
|
numeric
|
NULL
|
Hemen Parekh
