okayapi_opms_pms_overtimes_approver - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_opms_pms_overtimes_approver：/tablelist/okayapi_opms_pms_overtimes_approver.html


-- MySQL Table okayapi_opms_pms_overtimes_approver
-- From: OkayAPI.com
CREATE TABLE `okayapi_opms_pms_overtimes_approver` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `overtimeid` bigint(20) NULL COMMENT '加班表ID',
    `userid` bigint(20) NULL COMMENT '审批人Userid',
    `summary` varchar(500) NULL COMMENT '说明',
    `okayapi_opms_pms_overtimes_approver_status` tinyint(1) NULL COMMENT '1同意2拒绝',
    `created` int(10) NULL COMMENT '',
    `okayapi_opms_pms_overtimes_approver_changed` int(10) NULL COMMENT '',
    KEY `overtimeid` (`overtimeid`),
    KEY `userid` (`userid`),
    KEY `summary` (`summary`),
    KEY `okayapi_opms_pms_overtimes_approver_status` (`okayapi_opms_pms_overtimes_approver_status`),
    KEY `created` (`created`),
    KEY `okayapi_opms_pms_overtimes_approver_changed` (`okayapi_opms_pms_overtimes_approver_changed`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'OPMS和OA管理-加班审批人表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-6 of 6 results.

Field Name	Field Type	IS NULL	Field Comment
overtimeid	bigint(20)	是	加班表ID
userid	bigint(20)	是	审批人Userid
summary	varchar(500)	是	说明
okayapi_opms_pms_overtimes_approver_status	tinyint(1)	是	1同意2拒绝
created	int(10)	是
okayapi_opms_pms_overtimes_approver_changed	int(10)	是