+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_72crm_oa_examine_log:/tablelist/okayapi_72crm_oa_examine_log.html


-- MySQL Table okayapi_72crm_oa_examine_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_oa_examine_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `log_id` bigint(11) NULL COMMENT 'ID',
    `record_id` int(11) NULL COMMENT '审批记录ID',
    `examine_step_id` bigint(20) NULL COMMENT '审核步骤ID',
    `examine_status` int(1) NULL COMMENT '审核状态 0 未审核 1 审核通过 2 审核拒绝4 撤回审核',
    `create_user` bigint(20) NULL COMMENT '创建人',
    `create_time` datetime NULL COMMENT '创建时间',
    `examine_user` bigint(20) NULL COMMENT '审核人',
    `examine_time` datetime NULL COMMENT '审核时间',
    `remarks` varchar(255) NULL COMMENT '审核备注',
    `is_recheck` int(1) NULL DEFAULT '0' COMMENT '是否是撤回之前的日志 0或者null为新数据 1:撤回之前的数据',
    `order_id` int(30) NULL COMMENT '排序id',
    KEY `log_id` (`log_id`),
    KEY `record_id` (`record_id`),
    KEY `examine_step_id` (`examine_step_id`),
    KEY `examine_status` (`examine_status`),
    KEY `create_user` (`create_user`),
    KEY `create_time` (`create_time`),
    KEY `examine_user` (`examine_user`),
    KEY `examine_time` (`examine_time`),
    KEY `remarks` (`remarks`),
    KEY `is_recheck` (`is_recheck`),
    KEY `order_id` (`order_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-审核日志表';

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


MySQL database table structure design

Displaying 1-11 of 11 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
log_idbigint(11)ID
record_idint(11)审批记录ID
examine_step_idbigint(20)审核步骤ID
examine_statusint(1)审核状态 0 未审核 1 审核通过 2 审核拒绝4 撤回审核
create_userbigint(20)创建人
create_timedatetime创建时间
examine_userbigint(20)审核人
examine_timedatetime审核时间
remarksvarchar(255)审核备注
is_recheckint(1)0是否是撤回之前的日志 0或者null为新数据 1:撤回之前的数据0
order_idint(30)排序id

Guess You Like

MySQL Table Design okayapi_72crm_admin_config

MySQL Table Design okayapi_72crm_admin_dept

MySQL Table Design okayapi_72crm_admin_examine

MySQL Table Design okayapi_72crm_admin_examine_log

MySQL Table Design okayapi_72crm_admin_examine_record

MySQL Table Design okayapi_72crm_admin_examine_step

MySQL Table Design okayapi_72crm_admin_field_sort

MySQL Table Design okayapi_72crm_admin_fieldv

MySQL Table Design okayapi_72crm_admin_file

MySQL Table Design okayapi_72crm_admin_menu

MySQL Table Design okayapi_72crm_admin_message

MySQL Table Design okayapi_72crm_admin_record

MySQL Table Design okayapi_72crm_admin_role

MySQL Table Design okayapi_72crm_admin_role_menu

MySQL Table Design okayapi_72crm_admin_scene

MySQL Table Design okayapi_72crm_admin_scene_default

MySQL Table Design okayapi_72crm_admin_user

MySQL Table Design okayapi_72crm_admin_user_role

MySQL Table Design okayapi_72crm_crm_achievement

MySQL Table Design okayapi_72crm_crm_action_record

TOP ↑