+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jeewms_jform_employee_leave:/tablelist/okayapi_jeewms_jform_employee_leave.html


-- MySQL Table okayapi_jeewms_jform_employee_leave
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_employee_leave` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_jeewms_jform_employee_leave_name` varchar(100) NULL COMMENT '名称',
    `apply_date` datetime NULL COMMENT '申请日期',
    `duty` varchar(100) NULL COMMENT '职务',
    `leave_category` varchar(100) NULL COMMENT '请假类别',
    `leave_reason` varchar(100) NULL COMMENT '请假原因',
    `leave_start_date` datetime NULL COMMENT '请假开始时间',
    `leave_end_date` datetime NULL COMMENT '请假结束时间',
    `total` int(5) NULL COMMENT '共计',
    `contact_way` varchar(20) NULL COMMENT '紧急联系方式',
    `duty_deputy` varchar(100) NULL COMMENT '批定职务代理人',
    `leader_approval` varchar(50) NULL COMMENT '直接主管审批',
    `dept_principal_approval` varchar(50) NULL COMMENT '部门负责人审批',
    `hr_principal_approval` varchar(50) NULL COMMENT 'HR负责人审批',
    `hr_records` varchar(50) NULL COMMENT '行政部备案',
    `department` varchar(50) NULL COMMENT '部门',
    KEY `okayapi_jeewms_jform_employee_leave_name` (`okayapi_jeewms_jform_employee_leave_name`),
    KEY `apply_date` (`apply_date`),
    KEY `duty` (`duty`),
    KEY `leave_category` (`leave_category`),
    KEY `leave_reason` (`leave_reason`),
    KEY `leave_start_date` (`leave_start_date`),
    KEY `leave_end_date` (`leave_end_date`),
    KEY `total` (`total`),
    KEY `contact_way` (`contact_way`),
    KEY `duty_deputy` (`duty_deputy`),
    KEY `leader_approval` (`leader_approval`),
    KEY `dept_principal_approval` (`dept_principal_approval`),
    KEY `hr_principal_approval` (`hr_principal_approval`),
    KEY `hr_records` (`hr_records`),
    KEY `department` (`department`),
    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-15 of 15 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_jeewms_jform_employee_leave_namevarchar(100)名称
apply_datedatetime申请日期
dutyvarchar(100)职务
leave_categoryvarchar(100)请假类别
leave_reasonvarchar(100)请假原因
leave_start_datedatetime请假开始时间
leave_end_datedatetime请假结束时间
totalint(5)共计
contact_wayvarchar(20)紧急联系方式
duty_deputyvarchar(100)批定职务代理人
leader_approvalvarchar(50)直接主管审批
dept_principal_approvalvarchar(50)部门负责人审批
hr_principal_approvalvarchar(50)HR负责人审批
hr_recordsvarchar(50)行政部备案
departmentvarchar(50)部门

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 ↑