+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_ry_sys_job:/tablelist/okayapi_ry_sys_job.html


-- MySQL Table okayapi_ry_sys_job
-- From: OkayAPI.com
CREATE TABLE `okayapi_ry_sys_job` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `job_id` bigint(20) NULL COMMENT '任务ID',
    `job_name` varchar(64) NULL COMMENT '任务名称',
    `job_group` varchar(64) NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
    `invoke_target` varchar(500) NULL COMMENT '调用目标字符串',
    `cron_expression` varchar(255) NULL COMMENT 'cron执行表达式',
    `misfire_policy` varchar(20) NULL DEFAULT '3' COMMENT '计划执行错误策略(1立即执行 2执行一次 3放弃执行)',
    `okayapi_ry_sys_job_concurrent` char(1) NULL DEFAULT '1' COMMENT '是否并发执行(0允许 1禁止)',
    `okayapi_ry_sys_job_status` char(1) NULL DEFAULT '0' COMMENT '状态(0正常 1暂停)',
    `create_by` varchar(64) NULL COMMENT '创建者',
    `create_time` datetime NULL COMMENT '创建时间',
    `update_by` varchar(64) NULL COMMENT '更新者',
    `remark` varchar(500) NULL COMMENT '备注信息',
    KEY `job_id` (`job_id`),
    KEY `job_name` (`job_name`),
    KEY `job_group` (`job_group`),
    KEY `invoke_target` (`invoke_target`),
    KEY `cron_expression` (`cron_expression`),
    KEY `misfire_policy` (`misfire_policy`),
    KEY `okayapi_ry_sys_job_concurrent` (`okayapi_ry_sys_job_concurrent`),
    KEY `okayapi_ry_sys_job_status` (`okayapi_ry_sys_job_status`),
    KEY `create_by` (`create_by`),
    KEY `create_time` (`create_time`),
    KEY `update_by` (`update_by`),
    KEY `remark` (`remark`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'RuoYi后台管理系统-定时任务调度表';

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


MySQL database table structure design

Displaying 1-12 of 12 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
job_idbigint(20)任务ID
job_namevarchar(64)任务名称
job_groupvarchar(64)DEFAULT任务组名DEFAULT
invoke_targetvarchar(500)调用目标字符串
cron_expressionvarchar(255)cron执行表达式
misfire_policyvarchar(20)3计划执行错误策略(1立即执行 2执行一次 3放弃执行)3
okayapi_ry_sys_job_concurrentchar(1)1是否并发执行(0允许 1禁止)1
okayapi_ry_sys_job_statuschar(1)0状态(0正常 1暂停)0
create_byvarchar(64)创建者
create_timedatetime创建时间
update_byvarchar(64)更新者
remarkvarchar(500)备注信息

Guess You Like

MySQL Table Design okayapi_ry_sys_dept

MySQL Table Design okayapi_ry_sys_user

MySQL Table Design okayapi_ry_sys_post

MySQL Table Design okayapi_ry_sys_role

MySQL Table Design okayapi_ry_sys_menu

MySQL Table Design okayapi_ry_sys_user_role

MySQL Table Design okayapi_ry_sys_role_menu

MySQL Table Design okayapi_ry_sys_role_dept

MySQL Table Design okayapi_ry_sys_user_post

MySQL Table Design okayapi_ry_sys_oper_log

MySQL Table Design okayapi_ry_sys_dict_type

MySQL Table Design okayapi_ry_sys_dict_data

MySQL Table Design okayapi_ry_sys_config

MySQL Table Design okayapi_ry_sys_logininfor

MySQL Table Design okayapi_ry_sys_user_online

MySQL Table Design okayapi_ry_sys_job_log

MySQL Table Design okayapi_ry_sys_notice

MySQL Table Design okayapi_ry_gen_table

MySQL Table Design okayapi_ry_gen_table_column

TOP ↑