+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_vhr_employee:/tablelist/okayapi_vhr_employee.html


-- MySQL Table okayapi_vhr_employee
-- From: OkayAPI.com
CREATE TABLE `okayapi_vhr_employee` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(10) NULL COMMENT '员工姓名',
    `gender` char(4) NULL COMMENT '性别',
    `birthday` date NULL COMMENT '出生日期',
    `idCard` char(18) NULL COMMENT '身份证号',
    `wedlock` enum('已婚','未婚','离异') NULL COMMENT '婚姻状况',
    `nationId` int(8) NULL COMMENT '民族',
    `nativePlace` varchar(20) NULL COMMENT '籍贯',
    `politicId` int(8) NULL COMMENT '政治面貌',
    `email` varchar(20) NULL COMMENT '邮箱',
    `phone` varchar(11) NULL COMMENT '电话号码',
    `address` varchar(64) NULL COMMENT '联系地址',
    `departmentId` int(11) NULL COMMENT '所属部门',
    `jobLevelId` int(11) NULL COMMENT '职称ID',
    `posId` int(11) NULL COMMENT '职位ID',
    `engageForm` varchar(8) NULL COMMENT '聘用形式',
    `tiptopDegree` enum('博士','硕士','本科','大专','高中','初中','小学','其他') NULL COMMENT '最高学历',
    `specialty` varchar(32) NULL COMMENT '所属专业',
    `school` varchar(32) NULL COMMENT '毕业院校',
    `beginDate` date NULL COMMENT '入职日期',
    `workState` enum('在职','离职') NULL DEFAULT '在职' COMMENT '在职状态',
    `workID` char(8) NULL COMMENT '工号',
    `contractTerm` double NULL COMMENT '合同期限',
    `conversionTime` date NULL COMMENT '转正日期',
    `notWorkDate` date NULL COMMENT '离职日期',
    `beginContract` date NULL COMMENT '合同起始日期',
    `endContract` date NULL COMMENT '合同终止日期',
    `workAge` int(11) NULL COMMENT '工龄',
    KEY `name` (`name`),
    KEY `gender` (`gender`),
    KEY `birthday` (`birthday`),
    KEY `idCard` (`idCard`),
    KEY `wedlock` (`wedlock`),
    KEY `nationId` (`nationId`),
    KEY `nativePlace` (`nativePlace`),
    KEY `politicId` (`politicId`),
    KEY `email` (`email`),
    KEY `phone` (`phone`),
    KEY `address` (`address`),
    KEY `departmentId` (`departmentId`),
    KEY `jobLevelId` (`jobLevelId`),
    KEY `posId` (`posId`),
    KEY `engageForm` (`engageForm`),
    KEY `tiptopDegree` (`tiptopDegree`),
    KEY `specialty` (`specialty`),
    KEY `school` (`school`),
    KEY `beginDate` (`beginDate`),
    KEY `workState` (`workState`),
    KEY `workID` (`workID`),
    KEY `contractTerm` (`contractTerm`),
    KEY `conversionTime` (`conversionTime`),
    KEY `notWorkDate` (`notWorkDate`),
    KEY `beginContract` (`beginContract`),
    KEY `endContract` (`endContract`),
    KEY `workAge` (`workAge`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '人力资源-员工';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-27 of 27 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
namevarchar(10)员工姓名
genderchar(4)性别
birthdaydate出生日期
idCardchar(18)身份证号
wedlockenum('已婚','未婚','离异')婚姻状况
nationIdint(8)民族Normal Index
nativePlacevarchar(20)籍贯
politicIdint(8)政治面貌Normal Index
emailvarchar(20)邮箱
phonevarchar(11)电话号码
addressvarchar(64)联系地址
departmentIdint(11)所属部门Normal Index
jobLevelIdint(11)职称IDNormal Index
posIdint(11)职位IDNormal Index
engageFormvarchar(8)聘用形式
tiptopDegreeenum('博士','硕士','本科','大专','高中','初中','小学','其他')最高学历
specialtyvarchar(32)所属专业
schoolvarchar(32)毕业院校
beginDatedate入职日期
workStateenum('在职','离职')在职在职状态在职
workIDchar(8)工号Normal Index
contractTermdouble合同期限
conversionTimedate转正日期
notWorkDatedate离职日期
beginContractdate合同起始日期
endContractdate合同终止日期
workAgeint(11)工龄

Guess You Like

MySQL Table Design okayapi_vhr_adjustsalary

MySQL Table Design okayapi_vhr_appraise

MySQL Table Design okayapi_vhr_department

MySQL Table Design okayapi_vhr_employeeec

MySQL Table Design okayapi_vhr_employeeremove

MySQL Table Design okayapi_vhr_employeetrain

MySQL Table Design okayapi_vhr_empsalary

MySQL Table Design okayapi_vhr_hr

MySQL Table Design okayapi_vhr_hr_role

MySQL Table Design okayapi_vhr_joblevel

MySQL Table Design okayapi_vhr_menu

MySQL Table Design okayapi_vhr_menu_role

MySQL Table Design okayapi_vhr_msgcontent

MySQL Table Design okayapi_vhr_nation

MySQL Table Design okayapi_vhr_oplog

MySQL Table Design okayapi_vhr_politicsstatus

MySQL Table Design okayapi_vhr_position

MySQL Table Design okayapi_vhr_role

MySQL Table Design okayapi_vhr_salary

MySQL Table Design okayapi_vhr_sysmsg

TOP ↑