类图
2020-01-06 11:37:48 0 举报
招聘系统设计类图
作者其他创作
大纲/内容
1 1..n
1 0..n
0..n 1
Employer
EmployerId:IntEmployerName:Char(50)IDCard:Char(18)Company:Char(100)Age:IntPhone;varchar(50)Email:varchar(254)Is_active:TinyIntDate_joined:Datetime
0..n 1
1 0..n
1 1
Position
PositionId:IntPositionName:Char(100)Company:Char(100)Emplyer:Char(50)Salary:Varchar(254)Phone:Varchar(50)Email:Varchar(254)Description:LongtextPubdate:Datetime
Curriculum_vitae
Curriculum_vitaeId:IntEmployeeId:IntCurriculum_vitaeId:IntName:Char(50)Sex:Char(2)Age:IntAdress:Char(254)
CV_education_expeicence
Curriculum_vitaeId:IntEducation_experienceId:IntBegin_time:DatetimeEnd_time:DatetimeSchool:Char(100)Major:Char(100)Background:Char(4)Description:Longtext
1 1..n
CV_work_expeicence
Curriculum_vitaeId:IntWork_experienceId:IntBegin_time:DatetimeEnd_time:DatetimeCompany:Char(100)Job:Char(100)Apartment:Char(100)CompanyScale:Char(80)Description:Longtext
Application_status
EmployeeId:IntPositionId:Intstatus:varchar(50)Interview_time:DatetimeInterview_address:Varchar(254)Interview_score:float
Employee
EmployeeId:IntEmployeeName:Char(50)IDCard:Char(18)Age:IntPhone;varchar(50)Email:varchar(254)Is_active:TinyIntDate_joined:Datetime
Position_requirement
PositionId:IntRequirementId:IntDescription:Longtext
Position_welfare
PositionId:IntWelfareId:IntDescription:Longtext
0 条评论
下一页