+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jeewms_jform_employee_entry:/tablelist/okayapi_jeewms_jform_employee_entry.html


-- MySQL Table okayapi_jeewms_jform_employee_entry
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_employee_entry` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `create_name` varchar(50) NULL COMMENT '创建人名称',
    `create_by` varchar(50) NULL COMMENT '创建人登录名称',
    `create_date` datetime NULL COMMENT '填表日期',
    `update_name` varchar(50) NULL COMMENT '更新人名称',
    `update_by` varchar(50) NULL COMMENT '更新人登录名称',
    `update_date` datetime NULL COMMENT '更新日期',
    `sys_org_code` varchar(50) NULL COMMENT '所属部门',
    `sys_company_code` varchar(50) NULL COMMENT '所属公司',
    `employee_name` varchar(32) NULL COMMENT '姓名',
    `employee_depart` varchar(50) NULL COMMENT '部门',
    `employee_job` varchar(32) NULL COMMENT '职务',
    `employee_birthday` datetime NULL COMMENT '生日',
    `employee_origin` varchar(50) NULL COMMENT '籍贯',
    `employee_degree` varchar(32) NULL COMMENT '学历',
    `employee_identification` varchar(50) NULL COMMENT '身份证',
    `employee_entry_date` datetime NULL COMMENT '入职日期',
    `employee_code` varchar(32) NULL COMMENT '工号',
    `employee_phone` varchar(32) NULL COMMENT '手机',
    `employee_mail` varchar(150) NULL COMMENT '邮箱',
    `employee_msn` varchar(32) NULL COMMENT 'MSN',
    `hr_pic` varchar(2) NULL COMMENT '照片',
    `hr_archives` varchar(2) NULL COMMENT '档案表',
    `hr_identification` varchar(2) NULL COMMENT '身份证',
    `hr_degree` varchar(2) NULL COMMENT '学位证',
    `hr_other` varchar(2) NULL COMMENT '其他证件',
    `hr_tel` varchar(2) NULL COMMENT '分配电话',
    `hr_op_user` varchar(32) NULL COMMENT '经办人',
    `hr_op_date` datetime NULL COMMENT '日期',
    `depart_opinion` varchar(200) NULL COMMENT '部门意见',
    `depart_op_user` varchar(32) NULL COMMENT '经办人',
    `depart_op_date` datetime NULL COMMENT '日期',
    `manager_opinion` varchar(200) NULL COMMENT '总经理意见',
    `manager_op_user` varchar(32) NULL COMMENT '经办人',
    `manager_op_date` datetime NULL COMMENT '日期',
    `employee_opinion` varchar(200) NULL COMMENT '新员工意见',
    `employee_op_user` varchar(32) NULL COMMENT '经办人',
    `employee_op_date` datetime NULL COMMENT '日期',
    KEY `create_name` (`create_name`),
    KEY `create_by` (`create_by`),
    KEY `create_date` (`create_date`),
    KEY `update_name` (`update_name`),
    KEY `update_by` (`update_by`),
    KEY `update_date` (`update_date`),
    KEY `sys_org_code` (`sys_org_code`),
    KEY `sys_company_code` (`sys_company_code`),
    KEY `employee_name` (`employee_name`),
    KEY `employee_depart` (`employee_depart`),
    KEY `employee_job` (`employee_job`),
    KEY `employee_birthday` (`employee_birthday`),
    KEY `employee_origin` (`employee_origin`),
    KEY `employee_degree` (`employee_degree`),
    KEY `employee_identification` (`employee_identification`),
    KEY `employee_entry_date` (`employee_entry_date`),
    KEY `employee_code` (`employee_code`),
    KEY `employee_phone` (`employee_phone`),
    KEY `employee_mail` (`employee_mail`),
    KEY `employee_msn` (`employee_msn`),
    KEY `hr_pic` (`hr_pic`),
    KEY `hr_archives` (`hr_archives`),
    KEY `hr_identification` (`hr_identification`),
    KEY `hr_degree` (`hr_degree`),
    KEY `hr_other` (`hr_other`),
    KEY `hr_tel` (`hr_tel`),
    KEY `hr_op_user` (`hr_op_user`),
    KEY `hr_op_date` (`hr_op_date`),
    KEY `depart_opinion` (`depart_opinion`),
    KEY `depart_op_user` (`depart_op_user`),
    KEY `depart_op_date` (`depart_op_date`),
    KEY `manager_opinion` (`manager_opinion`),
    KEY `manager_op_user` (`manager_op_user`),
    KEY `manager_op_date` (`manager_op_date`),
    KEY `employee_opinion` (`employee_opinion`),
    KEY `employee_op_user` (`employee_op_user`),
    KEY `employee_op_date` (`employee_op_date`),
    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-37 of 37 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
create_namevarchar(50)创建人名称
create_byvarchar(50)创建人登录名称
create_datedatetime填表日期
update_namevarchar(50)更新人名称
update_byvarchar(50)更新人登录名称
update_datedatetime更新日期
sys_org_codevarchar(50)所属部门
sys_company_codevarchar(50)所属公司
employee_namevarchar(32)姓名
employee_departvarchar(50)部门
employee_jobvarchar(32)职务
employee_birthdaydatetime生日
employee_originvarchar(50)籍贯
employee_degreevarchar(32)学历
employee_identificationvarchar(50)身份证
employee_entry_datedatetime入职日期
employee_codevarchar(32)工号
employee_phonevarchar(32)手机
employee_mailvarchar(150)邮箱
employee_msnvarchar(32)MSN
hr_picvarchar(2)照片
hr_archivesvarchar(2)档案表
hr_identificationvarchar(2)身份证
hr_degreevarchar(2)学位证
hr_othervarchar(2)其他证件
hr_telvarchar(2)分配电话
hr_op_uservarchar(32)经办人
hr_op_datedatetime日期
depart_opinionvarchar(200)部门意见
depart_op_uservarchar(32)经办人
depart_op_datedatetime日期
manager_opinionvarchar(200)总经理意见
manager_op_uservarchar(32)经办人
manager_op_datedatetime日期
employee_opinionvarchar(200)新员工意见
employee_op_uservarchar(32)经办人
employee_op_datedatetime日期

Guess You Like

MySQL Table Design okayapi_jeewms_ba_act_type

MySQL Table Design okayapi_jeewms_ba_area

MySQL Table Design okayapi_jeewms_ba_barea

MySQL Table Design okayapi_jeewms_ba_bin_type

MySQL Table Design okayapi_jeewms_ba_buss_type

MySQL Table Design okayapi_jeewms_ba_city

MySQL Table Design okayapi_jeewms_ba_city_type

MySQL Table Design okayapi_jeewms_ba_classfl

MySQL Table Design okayapi_jeewms_ba_com_deg

MySQL Table Design okayapi_jeewms_ba_com_type

MySQL Table Design okayapi_jeewms_ba_comp

MySQL Table Design okayapi_jeewms_ba_cont_spec

MySQL Table Design okayapi_jeewms_ba_cont_type

MySQL Table Design okayapi_jeewms_ba_cost

MySQL Table Design okayapi_jeewms_ba_cost_conf

MySQL Table Design okayapi_jeewms_ba_cost_type

MySQL Table Design okayapi_jeewms_ba_cus_sta

MySQL Table Design okayapi_jeewms_ba_deg_type

MySQL Table Design okayapi_jeewms_ba_del_mode

MySQL Table Design okayapi_jeewms_ba_edu_sta

TOP ↑