常量
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');