Web-Carefree future (51job recruitment)-account, resume-Database Design

Use_51job -- ylb: 1, personal service -- personal information -- (ResumeID (20), -- name GenderYearOfBirthdaychar (4), -- Date of birth-year MonthOfBirthdaychar (2 ), -- Date of birth-month -- 6, DayOfBirthdaychar (2), -- Date of birth-day WorkYearint, -- service life Card

Use _ 51job -- ylb: 1, personal service -- personal information -- (ResumeID (20), -- name Gender YearOfBirthday char (4 ), -- Date of birth-MonthOfBirthday char (2), -- Date of birth-month -- 6, DayOfBirthday char (2), -- Date of birth-date WorkYear int, -- life Card

Use _ 51job -- ylb: 1, personal services --> personal information -- (ResumeID (20), -- name Gender YearOfBirthday char (4 ), -- Date of birth-MonthOfBirthday char (2), -- Date of birth-month -- 6, DayOfBirthday char (2), -- Date of birth-date WorkYear int, -- Duration CardType int, -- ID Type IDNumber varchar (25), -- ID number Location varchar (150), -- Residence [Type] -- 11, Email varchar (80), -- EmailSalary int, -- current annual salary CurrType Current_Situation int, -- job status -- 16, Mobile varchar (20), -- Mobile phone number FPNation char (5), -- company phone number FPCity char (5 ), -- company phone number-area code FPNumber char (20), -- company phone number-switchboard number FPExtension char (10), -- company phone number-extension -- 21, HPNation char (5 ), -- home phone HpCity char (5), -- home phone-area code HPNumber char (20), -- home phone-phone number HuKou varchar (150 ), -- account [Type] ResumeKey char (12), -- Keyword -- 26, --- view more personal information Nationality varchar (150), -- country or region Stature int, -- height Marrige int, -- Marital status: 0: unmarried; 1: Married; 2: Confidential QQID varchar (20), -- QQ ZipCode char (6), -- zip code -- 31, AliTalk varchar (100 ), -- Wangwang IDHomePage (150), -- Address StudentGroup int, -- Work Experience: 0: Yes; 1: No UserID (UserID) -- personal service (FK) -- ylb: 2, personal services --> educational experience -- Edu (EduID (), -- number FromYear char (4), -- time-from year FromMonth char (2 ), -- time-from month ToYear char (4), -- time-to year ToMonth char (2), -- time-to month -- 6, SchoolName varchar (100 ), -- school [Type] SubMajor varchar (100), -- professional MoreMajor varchar (100), -- more professional Degree int, -- education Degree EduDetail ntext, -- professional description -- 11, isOverSeas UserID (UserID) -- personal service (FK) -- ylb: 3, personal service --> Work Experience -- (-- WorkID, FromYear, FromMonth, ToYear, ToMonthWorkID ), -- number FromYear char (4), -- time-from year FromMonth char (2), -- time-from month ToYear char (4 ), -- Time-to-Year-current year ToMonth char (2), -- Time-to-month-current month -- 6, Company varchar (100), -- Company name Industry varchar (150 ), -- industry CompanySize int, -- company size CompanyType int, -- company type Division varchar (50), -- department -- 11, SubFunction varchar (50), -- Position varchar (50 ), -- Responsiblity ReportLine varchar (50) for other positions, -- Report object Subordinate char (5), -- number of subordinates -- 16, Reference varchar (50), -- prove LeaveReson varchar (200 ), -- reason for resignation Achievement varchar (500), -- major performance IsOverSeas UserID (UserID) -- personal service (FK) -- ylb: 4, personal services> job intention -- OtherSelf (JobTerm int, -- job type 0: full-time; 1: part-time; 2: internship; 3: full/part-time JobArea varchar (50 ), -- work location IndustryType varchar (50), -- industry FunType varchar (50), -- function Salary int, -- expected Salary -- 6, EntryTime int, -- arrival time Introduction varchar (500 ), -- self-rating UserID (UserID) -- personal service (FK) -- ylb: 5, personal service --> language capability _ 1 -- Lan (LanID (), -- serial age1 int, -- language class Master int, -- mastery level RWAbility int, -- read/write capability LSAbility int, -- listening and speaking capability -- 6, UserID (UserID) -- personal service (FK) -- ylb: 6, personal services --> language capabilities -- (EnLevel int, -- English level Toefl char (3), -- TOEFLgre char (3), -- GREjpLevel int, -- Japanese level Gmat char (3 ), -- GMAT--6, Ielts char (4), -- IELTSUserID (UserID) -- personal service (FK ))

, Hong Kong server, Hong Kong virtual host, Hong Kong server rent