常量

12114

常量总览

_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 COMMENT = '常量表; 软删除未启用;'

_constant 表数据

当前学期

• constantKey：currentSemester

• constantType：object

{
  "semester": "春季",
  "year": 2024
}

_constant语句

INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'currentSemester', 'object', '当前学期', '{"semester":"春季","year":2024}', 'update', NULL, NULL, '2023-07-23T13:29:43+08:00');