江湖数字化平台
登录

常量

12114

常量总览

_constant结构

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

_constant 表数据

null

  • constantKey：commentMap

  • constantType：object

  1. {
  2.   "小学": [
  3.     {
  4.       "1": "成绩差",
  5.       "2": "成绩较差",
  6.       "3": "成绩一般",
  7.       "4": "成绩较好",
  8.       "5": "成绩优秀",
  9.       "type": "成绩"
  10.     },
  11.     {
  12.       "1": "日常表现不佳",
  13.       "2": "日常表现较差",
  14.       "3": "日常表现一般",
  15.       "4": "日常表现良好",
  16.       "5": "日常表现优秀",
  17.       "type": "日常"
  18.     },
  19.     {
  20.       "1": "1",
  21.       "2": "2",
  22.       "3": "3",
  23.       "4": "4",
  24.       "5": "5",
  25.       "type": "纪律"
  26.     }
  27.   ],
  28.   "初中": [
  29.     {
  30.       "1": "成绩差",
  31.       "2": "成绩较差",
  32.       "3": "成绩一般",
  33.       "4": "成绩较好",
  34.       "5": "成绩优秀",
  35.       "type": "成绩"
  36.     },
  37.     {
  38.       "1": "日常表现不佳",
  39.       "2": "日常表现较差",
  40.       "3": "日常表现一般",
  41.       "4": "日常表现良好",
  42.       "5": "日常表现优秀",
  43.       "type": "日常"
  44.     }
  45.   ],
  46.   "高中": [
  47.     {
  48.       "1": "成绩差",
  49.       "2": "成绩较差",
  50.       "3": "成绩一般",
  51.       "4": "成绩较好",
  52.       "5": "成绩优秀",
  53.       "type": "成绩"
  54.     },
  55.     {
  56.       "1": "日常表现不佳",
  57.       "2": "日常表现较差",
  58.       "3": "日常表现一般",
  59.       "4": "日常表现良好",
  60.       "5": "日常表现优秀",
  61.       "type": "日常"
  62.     }
  63.   ]
  64. }

null

  • constantKey：level

  • constantType：array

  1. [
  2.   {
  3.     "value": "01",
  4.     "text": "一年级"
  5.   },
  6.   {
  7.     "value": "02",
  8.     "text": "二年级"
  9.   },
  10.   {
  11.     "value": "03",
  12.     "text": "三年级"
  13.   },
  14.   {
  15.     "value": "04",
  16.     "text": "四年级"
  17.   },
  18.   {
  19.     "value": "05",
  20.     "text": "五年级"
  21.   },
  22.   {
  23.     "value": "06",
  24.     "text": "六年级"
  25.   },
  26.   {
  27.     "value": "07",
  28.     "text": "七年级"
  29.   },
  30.   {
  31.     "value": "08",
  32.     "text": "八年级"
  33.   },
  34.   {
  35.     "value": "09",
  36.     "text": "九年级"
  37.   },
  38.   {
  39.     "value": "10",
  40.     "text": "高一"
  41.   },
  42.   {
  43.     "value": "11",
  44.     "text": "高二"
  45.   },
  46.   {
  47.     "value": "12",
  48.     "text": "高三"
  49.   }
  50. ]

当前年学期

  • constantKey：currentSemester

  • constantType：object

  1. {
  2.   "year": 2023,
  3.   "semester": "春季"
  4. }

学部

  • constantKey：segment

  • constantType：array

  1. [
  2.   {
  3.     "text": "小学",
  4.     "value": "小学",
  5.     "levelList": [
  6.       "01",
  7.       "02",
  8.       "03",
  9.       "04",
  10.       "05",
  11.       "06"
  12.     ]
  13.   },
  14.   {
  15.     "text": "初中",
  16.     "value": "初中",
  17.     "levelList": [
  18.       "07",
  19.       "08",
  20.       "09"
  21.     ]
  22.   },
  23.   {
  24.     "text": "高中",
  25.     "value": "高中",
  26.     "levelList": [
  27.       "10",
  28.       "11",
  29.       "12"
  30.     ]
  31.   }
  32. ]

_constant语句

  1. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'commentMap', 'object', NULL, '{"小学":[{"1":"成绩差","2":"成绩较差","3":"成绩一般","4":"成绩较好","5":"成绩优秀","type":"成绩"},{"1":"日常表现不佳","2":"日常表现较差","3":"日常表现一般","4":"日常表现良好","5":"日常表现优秀","type":"日常"},{"1":"1","2":"2","3":"3","4":"4","5":"5","type":"纪律"}],"初中":[{"1":"成绩差","2":"成绩较差","3":"成绩一般","4":"成绩较好","5":"成绩优秀","type":"成绩"},{"1":"日常表现不佳","2":"日常表现较差","3":"日常表现一般","4":"日常表现良好","5":"日常表现优秀","type":"日常"}],"高中":[{"1":"成绩差","2":"成绩较差","3":"成绩一般","4":"成绩较好","5":"成绩优秀","type":"成绩"},{"1":"日常表现不佳","2":"日常表现较差","3":"日常表现一般","4":"日常表现良好","5":"日常表现优秀","type":"日常"}]}', 'jhUpdate', 'admin', '系统管理员', '2023-06-14T16:18:57+08:00');
  2. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'level', 'array', NULL, '[
  3.     {"value": "01", "text": "一年级"},
  4.     {"value": "02", "text": "二年级"},
  5.     {"value": "03", "text": "三年级"},
  6.     {"value": "04", "text": "四年级"},
  7.     {"value": "05", "text": "五年级"},
  8.     {"value": "06", "text": "六年级"},
  9.     {"value": "07", "text": "七年级"},
  10.     {"value": "08", "text": "八年级"},
  11.     {"value": "09", "text": "九年级"},
  12.     {"value": "10", "text": "高一"},
  13.     {"value": "11", "text": "高二"},
  14.     {"value": "12", "text": "高三"}
  15. ]', 'insert', NULL, NULL, NULL);
  16. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'currentSemester', 'object', '当前年学期', '{"year": 2023, "semester": "春季"}', 'insert', NULL, NULL, NULL);
  17. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'segment', 'array', '学部', '[
  18. {"text": "小学", "value": "小学", "levelList": ["01","02","03","04","05","06"]},
  19. {"text": "初中", "value": "初中", "levelList": ["07","08","09"]},
  20. {"text": "高中", "value": "高中", "levelList": ["10","11","12"]}
  21. ]', 'insert', NULL, NULL, NULL);