+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jeewms_jform_employee_resignation:/tablelist/okayapi_jeewms_jform_employee_resignation.html


-- MySQL Table okayapi_jeewms_jform_employee_resignation
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_employee_resignation` (
    `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 '所属公司',
    `okayapi_jeewms_jform_employee_resignation_name` varchar(32) NULL COMMENT '姓名',
    `okayapi_jeewms_jform_employee_resignation_code` varchar(32) NULL COMMENT '员工编号',
    `job` varchar(32) NULL COMMENT '职务',
    `join_time` datetime NULL COMMENT '入职时间',
    `out_type` varchar(32) NULL COMMENT '离职方式',
    `apply_out_time` datetime NULL COMMENT '申请离职日期',
    `out_time` datetime NULL COMMENT '正式离职日期',
    `id_card` varchar(32) NULL COMMENT '身份证编号',
    `out_content` varchar(200) NULL COMMENT '离职须知',
    `out_reason` varchar(100) NULL COMMENT '离职原因',
    `interview_record` varchar(100) NULL COMMENT '面谈记录',
    `office_change` varchar(100) NULL COMMENT '办公物品移交',
    `hr_check` varchar(32) NULL COMMENT '人力资源部审核',
    `should_send_salary` double(32,0) NULL COMMENT '应发薪资',
    `should_deduct_pay` double(32,0) NULL COMMENT '应扣薪资',
    `pay` double(32,0) NULL COMMENT '实发薪资',
    `get_time` datetime NULL COMMENT '领取日期',
    `boss_check` varchar(32) NULL COMMENT '总经理审批',
    `description` varchar(32) 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 `okayapi_jeewms_jform_employee_resignation_name` (`okayapi_jeewms_jform_employee_resignation_name`),
    KEY `okayapi_jeewms_jform_employee_resignation_code` (`okayapi_jeewms_jform_employee_resignation_code`),
    KEY `job` (`job`),
    KEY `join_time` (`join_time`),
    KEY `out_type` (`out_type`),
    KEY `apply_out_time` (`apply_out_time`),
    KEY `out_time` (`out_time`),
    KEY `id_card` (`id_card`),
    KEY `out_content` (`out_content`),
    KEY `out_reason` (`out_reason`),
    KEY `interview_record` (`interview_record`),
    KEY `office_change` (`office_change`),
    KEY `hr_check` (`hr_check`),
    KEY `should_send_salary` (`should_send_salary`),
    KEY `should_deduct_pay` (`should_deduct_pay`),
    KEY `pay` (`pay`),
    KEY `get_time` (`get_time`),
    KEY `boss_check` (`boss_check`),
    KEY `description` (`description`),
    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
create_namevarchar(50)创建人名称
create_byvarchar(50)创建人登录名称
create_datedatetime创建日期
update_namevarchar(50)更新人名称
update_byvarchar(50)更新人登录名称
update_datedatetime更新日期
sys_org_codevarchar(50)所属部门
sys_company_codevarchar(50)所属公司
okayapi_jeewms_jform_employee_resignation_namevarchar(32)姓名
okayapi_jeewms_jform_employee_resignation_codevarchar(32)员工编号
jobvarchar(32)职务
join_timedatetime入职时间
out_typevarchar(32)离职方式
apply_out_timedatetime申请离职日期
out_timedatetime正式离职日期
id_cardvarchar(32)身份证编号
out_contentvarchar(200)离职须知
out_reasonvarchar(100)离职原因
interview_recordvarchar(100)面谈记录
office_changevarchar(100)办公物品移交
hr_checkvarchar(32)人力资源部审核
should_send_salarydouble(32,0)应发薪资
should_deduct_paydouble(32,0)应扣薪资
paydouble(32,0)实发薪资
get_timedatetime领取日期
boss_checkvarchar(32)总经理审批
descriptionvarchar(32)说明

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 ↑