RESUME VIEWER FINAL

25 June 2007

RESUMEVIEWERFINAL

PROJECT DESCRIPTION

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