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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_jeewms_jform_employee_leave_name | varchar(100) | 是 | 名称 | |||
apply_date | datetime | 是 | 申请日期 | |||
duty | varchar(100) | 是 | 职务 | |||
leave_category | varchar(100) | 是 | 请假类别 | |||
leave_reason | varchar(100) | 是 | 请假原因 | |||
leave_start_date | datetime | 是 | 请假开始时间 | |||
leave_end_date | datetime | 是 | 请假结束时间 | |||
total | int(5) | 是 | 共计 | |||
contact_way | varchar(20) | 是 | 紧急联系方式 | |||
duty_deputy | varchar(100) | 是 | 批定职务代理人 | |||
leader_approval | varchar(50) | 是 | 直接主管审批 | |||
dept_principal_approval | varchar(50) | 是 | 部门负责人审批 | |||
hr_principal_approval | varchar(50) | 是 | HR负责人审批 | |||
hr_records | varchar(50) | 是 | 行政部备案 | |||
department | varchar(50) | 是 | 部门 |