okayapi_opms_pms_checkworks - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_opms_pms_checkworks：/tablelist/okayapi_opms_pms_checkworks.html


-- MySQL Table okayapi_opms_pms_checkworks
-- From: OkayAPI.com
CREATE TABLE `okayapi_opms_pms_checkworks` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userid` bigint(20) NULL COMMENT '',
    `clock` varchar(8) NULL COMMENT '打卡时间',
    `okayapi_opms_pms_checkworks_type` tinyint(1) NULL COMMENT '1正常2迟到3早退4加班',
    `ip` varchar(20) NULL COMMENT '',
    `created` int(10) NULL COMMENT '时间',
    KEY `userid` (`userid`),
    KEY `clock` (`clock`),
    KEY `okayapi_opms_pms_checkworks_type` (`okayapi_opms_pms_checkworks_type`),
    KEY `ip` (`ip`),
    KEY `created` (`created`),
    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-5 of 5 results.

Field Name	Field Type	IS NULL	Field Comment
userid	bigint(20)	是
clock	varchar(8)	是	打卡时间
okayapi_opms_pms_checkworks_type	tinyint(1)	是	1正常2迟到3早退4加班
ip	varchar(20)	是
created	int(10)	是	时间