okayapi_opms_pms_expenses_approver - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_opms_pms_expenses_approver：/tablelist/okayapi_opms_pms_expenses_approver.html


-- MySQL Table okayapi_opms_pms_expenses_approver
-- From: OkayAPI.com
CREATE TABLE `okayapi_opms_pms_expenses_approver` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `expenseid` bigint(20) NULL COMMENT '报销表ID',
    `userid` bigint(20) NULL COMMENT '审批人Userid',
    `summary` varchar(500) NULL COMMENT '说明',
    `okayapi_opms_pms_expenses_approver_status` tinyint(1) NULL COMMENT '1同意2拒绝',
    `created` int(10) NULL COMMENT '',
    `okayapi_opms_pms_expenses_approver_changed` int(10) NULL COMMENT '',
    KEY `expenseid` (`expenseid`),
    KEY `userid` (`userid`),
    KEY `summary` (`summary`),
    KEY `okayapi_opms_pms_expenses_approver_status` (`okayapi_opms_pms_expenses_approver_status`),
    KEY `created` (`created`),
    KEY `okayapi_opms_pms_expenses_approver_changed` (`okayapi_opms_pms_expenses_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
expenseid	bigint(20)	是	报销表ID
userid	bigint(20)	是	审批人Userid
summary	varchar(500)	是	说明
okayapi_opms_pms_expenses_approver_status	tinyint(1)	是	1同意2拒绝
created	int(10)	是
okayapi_opms_pms_expenses_approver_changed	int(10)	是