Constants

12138

常量总览

_constant结构

CREATE TABLE `_constant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `constantKey` varchar(255)  DEFAULT NULL,
  `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  `constantValue` text  COMMENT '常量内容; object, array',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = '常量表; 软删除未启用;'

_constant 表数据

任务优先级

constantKey	constantType
taskLevel	array

[
  {
    "text": "无",
    "value": "无",
    "color": "grey"
  },
  {
    "text": "低",
    "value": "低",
    "color": "green"
  },
  {
    "text": "中",
    "value": "中",
    "color": "orange"
  },
  {
    "text": "高",
    "value": "高",
    "color": "red"
  }
]

任务状态

constantKey	constantType
taskStatus	array

[
  {
    "text": "未开始",
    "value": "未开始",
    "color": "blue"
  },
  {
    "text": "进行中",
    "value": "进行中",
    "color": "orange"
  },
  {
    "text": "已完成",
    "value": "已完成",
    "color": "green"
  }
]

_constant语句

INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'taskLevel', 'array', '任务优先级', '[
    {
        "text": "无",
        "value": "无",
        "color": "grey"
    },
    {
        "text": "低",
        "value": "低",
        "color": "green"
    },
    {
        "text": "中",
        "value": "中",
        "color": "orange"
    },
    {
        "text": "高",
        "value": "高",
        "color": "red"
    }
]', 'update', NULL, NULL, '2023-03-07T15:17:37+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'taskStatus', 'array', '任务状态', '[
    {
        "text": "未开始",
        "value": "未开始",
        "color": "blue"
    },
    {
        "text": "进行中",
        "value": "进行中",
        "color": "orange"
    },
    {
        "text": "已完成",
        "value": "已完成",
        "color": "green"
    }
]', 'update', NULL, NULL, '2023-03-07T15:17:37+08:00');