Constants

12135

常量总览

_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 = 5 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = '常量表; 软删除未启用;'

_constant 表数据

通知类型

constantKey	constantType
noticeType	array

[
  {
    "text": "公告",
    "value": "公告"
  },
  {
    "text": "任务",
    "value": "任务"
  },
  {
    "text": "审批",
    "value": "审批"
  },
  {
    "text": "日志",
    "value": "日志"
  }
]

任务优先级

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": "grey"
  }
]

任务模板分组

constantKey	constantType
taskTemplateGroup	array

[
  {
    "text": "行政",
    "value": "行政"
  },
  {
    "text": "人事",
    "value": "人事"
  },
  {
    "text": "其他",
    "value": "其他"
  }
]

_constant语句

INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'noticeType', 'array', '通知类型', '[
    {
        "text": "公告",
        "value": "公告"
    },
    {
        "text": "任务",
        "value": "任务"
    },
    {
        "text": "审批",
        "value": "审批"
    },
    {
        "text": "日志",
        "value": "日志"
    }
]', 'update', NULL, NULL, '2023-03-07T15:17:37+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, '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 (3, 'taskStatus', 'array', '任务状态', '[
    {
        "text": "未开始",
        "value": "未开始",
        "color": "blue"
    },
    {
        "text": "进行中",
        "value": "进行中",
        "color": "orange"
    },
    {
        "text": "已完成",
        "value": "已完成",
        "color": "grey"
    }
]', 'update', NULL, NULL, '2023-03-07T15:17:37+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'taskTemplateGroup', 'array', '任务模板分组', '[
    {
        "text": "行政",
        "value": "行政"
    },
    {
        "text": "人事",
        "value": "人事"
    },
    {
        "text": "其他",
        "value": "其他"
    }
]', 'update', NULL, NULL, '2023-03-07T15:17:37+08:00');