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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
create_name | varchar(50) | 是 | 创建人名称 | |||
create_by | varchar(50) | 是 | 创建人登录名称 | |||
create_date | datetime | 是 | 填表日期 | |||
update_name | varchar(50) | 是 | 更新人名称 | |||
update_by | varchar(50) | 是 | 更新人登录名称 | |||
update_date | datetime | 是 | 更新日期 | |||
sys_org_code | varchar(50) | 是 | 所属部门 | |||
sys_company_code | varchar(50) | 是 | 所属公司 | |||
employee_name | varchar(32) | 是 | 姓名 | |||
employee_depart | varchar(50) | 是 | 部门 | |||
employee_job | varchar(32) | 是 | 职务 | |||
employee_birthday | datetime | 是 | 生日 | |||
employee_origin | varchar(50) | 是 | 籍贯 | |||
employee_degree | varchar(32) | 是 | 学历 | |||
employee_identification | varchar(50) | 是 | 身份证 | |||
employee_entry_date | datetime | 是 | 入职日期 | |||
employee_code | varchar(32) | 是 | 工号 | |||
employee_phone | varchar(32) | 是 | 手机 | |||
employee_mail | varchar(150) | 是 | 邮箱 | |||
employee_msn | varchar(32) | 是 | MSN | |||
hr_pic | varchar(2) | 是 | 照片 | |||
hr_archives | varchar(2) | 是 | 档案表 | |||
hr_identification | varchar(2) | 是 | 身份证 | |||
hr_degree | varchar(2) | 是 | 学位证 | |||
hr_other | varchar(2) | 是 | 其他证件 | |||
hr_tel | varchar(2) | 是 | 分配电话 | |||
hr_op_user | varchar(32) | 是 | 经办人 | |||
hr_op_date | datetime | 是 | 日期 | |||
depart_opinion | varchar(200) | 是 | 部门意见 | |||
depart_op_user | varchar(32) | 是 | 经办人 | |||
depart_op_date | datetime | 是 | 日期 | |||
manager_opinion | varchar(200) | 是 | 总经理意见 | |||
manager_op_user | varchar(32) | 是 | 经办人 | |||
manager_op_date | datetime | 是 | 日期 | |||
employee_opinion | varchar(200) | 是 | 新员工意见 | |||
employee_op_user | varchar(32) | 是 | 经办人 | |||
employee_op_date | datetime | 是 | 日期 |