江湖数字化平台
登录

常量

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

_constant 表数据

跟进状态描述

  • constantKey：followUpStatusList

  • constantType：json

  1. ["新记录","电话无效","电话有效","无意向","有意向，已报名","已通知面试时间","已通知面试结果"]

跟进代理人

  • constantKey：followUpUsers

  • constantType：json

  1. [{"followUpByUserId": "L00001", "followUpByUserName": "刘老师"},{"followUpByUserId": "E4J", "followUpByUserName": "赵六"},{"followUpByUserId": "W00002", "followUpByUserName": "张无忌"}]

null

  • constantKey：followUpStage

  • constantType：arrat

  1. ["跟进中", "校长审核"]

科目

  • constantKey：subject

  • constantType：array

  1. [
  2.   {
  3.     "value": "语文",
  4.     "text": "语文",
  5.     "sortOrder": "01",
  6.     "relatedSubject": "无",
  7.     "type": "默认",
  8.     "isDisplay": "是",
  9.     "isExam": "是"
  10.   },
  11.   {
  12.     "value": "数学",
  13.     "text": "数学",
  14.     "sortOrder": "02",
  15.     "relatedSubject": "无",
  16.     "type": "默认",
  17.     "isDisplay": "是",
  18.     "isExam": "是"
  19.   },
  20.   {
  21.     "value": "英语",
  22.     "text": "英语",
  23.     "sortOrder": "03",
  24.     "relatedSubject": "无",
  25.     "type": "默认",
  26.     "isDisplay": "是",
  27.     "isExam": "是"
  28.   },
  29.   {
  30.     "value": "物理",
  31.     "text": "物理",
  32.     "sortOrder": "04",
  33.     "relatedSubject": "无",
  34.     "type": "默认",
  35.     "isDisplay": "是",
  36.     "isExam": "是"
  37.   },
  38.   {
  39.     "value": "化学",
  40.     "text": "化学",
  41.     "sortOrder": "05",
  42.     "relatedSubject": "无",
  43.     "type": "默认",
  44.     "isDisplay": "是",
  45.     "isExam": "是"
  46.   },
  47.   {
  48.     "value": "生物",
  49.     "text": "生物",
  50.     "sortOrder": "06",
  51.     "relatedSubject": "无",
  52.     "type": "默认",
  53.     "isDisplay": "是",
  54.     "isExam": "是"
  55.   },
  56.   {
  57.     "value": "政治",
  58.     "text": "政治",
  59.     "sortOrder": "07",
  60.     "relatedSubject": "无",
  61.     "type": "默认",
  62.     "isDisplay": "是",
  63.     "isExam": "是"
  64.   },
  65.   {
  66.     "value": "历史",
  67.     "text": "历史",
  68.     "sortOrder": "08",
  69.     "relatedSubject": "无",
  70.     "type": "默认",
  71.     "isDisplay": "是",
  72.     "isExam": "是"
  73.   },
  74.   {
  75.     "value": "地理",
  76.     "text": "地理",
  77.     "sortOrder": "09",
  78.     "relatedSubject": "无",
  79.     "type": "默认",
  80.     "isDisplay": "是",
  81.     "isExam": "是"
  82.   },
  83.   {
  84.     "value": "日语",
  85.     "text": "日语",
  86.     "sortOrder": "10",
  87.     "relatedSubject": "无",
  88.     "type": "默认",
  89.     "isDisplay": "是",
  90.     "isExam": "是"
  91.   },
  92.   {
  93.     "value": "地生",
  94.     "text": "地生",
  95.     "sortOrder": "11",
  96.     "relatedSubject": "无",
  97.     "type": "默认",
  98.     "isDisplay": "是",
  99.     "isExam": "是"
  100.   },
  101.   {
  102.     "value": "体育",
  103.     "text": "体育",
  104.     "sortOrder": "12",
  105.     "relatedSubject": "无",
  106.     "type": "默认",
  107.     "isDisplay": "是",
  108.     "isExam": "是"
  109.   },
  110.   {
  111.     "value": "书法",
  112.     "text": "书法",
  113.     "sortOrder": "12",
  114.     "relatedSubject": "无",
  115.     "type": "默认",
  116.     "isDisplay": "是",
  117.     "isExam": "是"
  118.   },
  119.   {
  120.     "value": "理科综合",
  121.     "text": "理科综合",
  122.     "sortOrder": "13",
  123.     "relatedSubject": "无",
  124.     "type": "默认",
  125.     "isDisplay": "是",
  126.     "isExam": "是"
  127.   },
  128.   {
  129.     "value": "文科综合",
  130.     "text": "文科综合",
  131.     "sortOrder": "14",
  132.     "relatedSubject": "无",
  133.     "type": "默认",
  134.     "isDisplay": "是",
  135.     "isExam": "是"
  136.   },
  137.   {
  138.     "value": "信息技术",
  139.     "text": "信息技术",
  140.     "sortOrder": "15",
  141.     "relatedSubject": "无",
  142.     "type": "辅课",
  143.     "isDisplay": "是",
  144.     "isExam": "否"
  145.   },
  146.   {
  147.     "value": "通用技术",
  148.     "text": "通用技术",
  149.     "sortOrder": "16",
  150.     "relatedSubject": "无",
  151.     "type": "辅课",
  152.     "isDisplay": "是",
  153.     "isExam": "否"
  154.   },
  155.   {
  156.     "value": "体育",
  157.     "text": "体育",
  158.     "sortOrder": "17",
  159.     "relatedSubject": "无",
  160.     "type": "辅课",
  161.     "isDisplay": "是",
  162.     "isExam": "否"
  163.   },
  164.   {
  165.     "value": "美术",
  166.     "text": "美术",
  167.     "sortOrder": "18",
  168.     "relatedSubject": "无",
  169.     "type": "辅课",
  170.     "isDisplay": "是",
  171.     "isExam": "否"
  172.   },
  173.   {
  174.     "value": "音乐",
  175.     "text": "音乐",
  176.     "sortOrder": "19",
  177.     "relatedSubject": "无",
  178.     "type": "辅课",
  179.     "isDisplay": "是",
  180.     "isExam": "否"
  181.   },
  182.   {
  183.     "value": "历史与社会",
  184.     "text": "历史与社会",
  185.     "sortOrder": "20",
  186.     "relatedSubject": "无",
  187.     "type": "辅课",
  188.     "isDisplay": "是",
  189.     "isExam": "否"
  190.   },
  191.   {
  192.     "value": "道德与法治",
  193.     "text": "道德与法治",
  194.     "sortOrder": "21",
  195.     "relatedSubject": "无",
  196.     "type": "辅课",
  197.     "isDisplay": "是",
  198.     "isExam": "否"
  199.   },
  200.   {
  201.     "value": "科学",
  202.     "text": "科学",
  203.     "sortOrder": "22",
  204.     "relatedSubject": "无",
  205.     "type": "辅课",
  206.     "isDisplay": "是",
  207.     "isExam": "否"
  208.   },
  209.   {
  210.     "value": "俄语",
  211.     "text": "俄语",
  212.     "sortOrder": "23",
  213.     "relatedSubject": "无",
  214.     "type": "小语种",
  215.     "isDisplay": "是",
  216.     "isExam": "否"
  217.   },
  218.   {
  219.     "value": "韩语",
  220.     "text": "韩语",
  221.     "sortOrder": "24",
  222.     "relatedSubject": "无",
  223.     "type": "小语种",
  224.     "isDisplay": "是",
  225.     "isExam": "否"
  226.   },
  227.   {
  228.     "value": "法语",
  229.     "text": "法语",
  230.     "sortOrder": "25",
  231.     "relatedSubject": "无",
  232.     "type": "小语种",
  233.     "isDisplay": "是",
  234.     "isExam": "否"
  235.   },
  236.   {
  237.     "value": "德语",
  238.     "text": "德语",
  239.     "sortOrder": "26",
  240.     "relatedSubject": "无",
  241.     "type": "小语种",
  242.     "isDisplay": "是",
  243.     "isExam": "否"
  244.   },
  245.   {
  246.     "value": "西班牙语",
  247.     "text": "西班牙语",
  248.     "sortOrder": "27",
  249.     "relatedSubject": "无",
  250.     "type": "小语种",
  251.     "isDisplay": "是",
  252.     "isExam": "否"
  253.   },
  254.   {
  255.     "value": "藏文",
  256.     "text": "藏文",
  257.     "sortOrder": "28",
  258.     "relatedSubject": "无",
  259.     "type": "小语种",
  260.     "isDisplay": "是",
  261.     "isExam": "否"
  262.   },
  263.   {
  264.     "value": "科学基础",
  265.     "text": "科学基础",
  266.     "sortOrder": "29",
  267.     "relatedSubject": "无",
  268.     "type": "自定义",
  269.     "isDisplay": "是",
  270.     "isExam": "否"
  271.   },
  272.   {
  273.     "value": "人文基础",
  274.     "text": "人文基础",
  275.     "sortOrder": "30",
  276.     "relatedSubject": "无",
  277.     "type": "自定义",
  278.     "isDisplay": "是",
  279.     "isExam": "否"
  280.   },
  281.   {
  282.     "value": "生物1",
  283.     "text": "生物1",
  284.     "sortOrder": "31",
  285.     "relatedSubject": "生物",
  286.     "type": "自定义",
  287.     "isDisplay": "是",
  288.     "isExam": "否"
  289.   },
  290.   {
  291.     "value": "化学1",
  292.     "text": "化学1",
  293.     "sortOrder": "32",
  294.     "relatedSubject": "化学",
  295.     "type": "自定义",
  296.     "isDisplay": "是",
  297.     "isExam": "否"
  298.   },
  299.   {
  300.     "value": "生物2",
  301.     "text": "生物2",
  302.     "sortOrder": "33",
  303.     "relatedSubject": "生物",
  304.     "type": "自定义",
  305.     "isDisplay": "是",
  306.     "isExam": "否"
  307.   },
  308.   {
  309.     "value": "化学2",
  310.     "text": "化学2",
  311.     "sortOrder": "34",
  312.     "relatedSubject": "化学",
  313.     "type": "自定义",
  314.     "isDisplay": "是",
  315.     "isExam": "否"
  316.   },
  317.   {
  318.     "value": "数学文科",
  319.     "text": "数学文科",
  320.     "sortOrder": "35",
  321.     "relatedSubject": "数学",
  322.     "type": "自定义",
  323.     "isDisplay": "是",
  324.     "isExam": "否"
  325.   },
  326.   {
  327.     "value": "化学重点班",
  328.     "text": "化学重点班",
  329.     "sortOrder": "36",
  330.     "relatedSubject": "化学",
  331.     "type": "自定义",
  332.     "isDisplay": "是",
  333.     "isExam": "否"
  334.   },
  335.   {
  336.     "value": "物理重点班",
  337.     "text": "物理重点班",
  338.     "sortOrder": "37",
  339.     "relatedSubject": "物理",
  340.     "type": "自定义",
  341.     "isDisplay": "是",
  342.     "isExam": "否"
  343.   }
  344. ]

学部

  • constantKey：segment

  • constantType：array

  1. [
  2.   "小学",
  3.   "初中",
  4.   "高中"
  5. ]

学期

  • constantKey：semester

  • constantType：array

  1. [
  2.   "2024春季",
  3.   "2023秋季"
  4. ]

年级列表

  • 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：afterSchoolCareType

  • constantType：array

  1. [
  2.   {
  3.     "value": "日托",
  4.     "text": "日托"
  5.   },
  6.   {
  7.     "value": "周托",
  8.     "text": "周托"
  9.   },
  10.   {
  11.     "value": "半月托",
  12.     "text": "半月托"
  13.   },
  14.   {
  15.     "value": "月托",
  16.     "text": "月托"
  17.   }
  18. ]

_constant语句

  1. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'followUpStatusList', 'json', '跟进状态描述', '["新记录","电话无效","电话有效","无意向","有意向，已报名","已通知面试时间","已通知面试结果"]', 'insert', NULL, NULL, NULL);
  2. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'followUpUsers', 'json', '跟进代理人', '[{"followUpByUserId": "L00001", "followUpByUserName": "刘老师"},{"followUpByUserId": "E4J", "followUpByUserName": "赵六"},{"followUpByUserId": "W00002", "followUpByUserName": "张无忌"}]', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'followUpStage', 'arrat', NULL, '["跟进中", "校长审核"]', 'insert', NULL, NULL, NULL);
  4. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'subject', 'array', '科目', '[
  5.   {"value":"语文","text":"语文","sortOrder":"01","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  6.   {"value":"数学","text":"数学","sortOrder":"02","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  7.   {"value":"英语","text":"英语","sortOrder":"03","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  8.   {"value":"物理","text":"物理","sortOrder":"04","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  9.   {"value":"化学","text":"化学","sortOrder":"05","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  10.   {"value":"生物","text":"生物","sortOrder":"06","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  11.   {"value":"政治","text":"政治","sortOrder":"07","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  12.   {"value":"历史","text":"历史","sortOrder":"08","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  13.   {"value":"地理","text":"地理","sortOrder":"09","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  14.   {"value":"日语","text":"日语","sortOrder":"10","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  15.   {"value":"地生","text":"地生","sortOrder":"11","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  16.   {"value":"体育","text":"体育","sortOrder":"12","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  17.   {"value":"书法","text":"书法","sortOrder":"12","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  18.   {"value":"理科综合","text":"理科综合","sortOrder":"13","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  19.   {"value":"文科综合","text":"文科综合","sortOrder":"14","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  20.   {"value":"信息技术","text":"信息技术","sortOrder":"15","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  21.   {"value":"通用技术","text":"通用技术","sortOrder":"16","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  22.   {"value":"体育","text":"体育","sortOrder":"17","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  23.   {"value":"美术","text":"美术","sortOrder":"18","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  24.   {"value":"音乐","text":"音乐","sortOrder":"19","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  25.   {"value":"历史与社会","text":"历史与社会","sortOrder":"20","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  26.   {"value":"道德与法治","text":"道德与法治","sortOrder":"21","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  27.   {"value":"科学","text":"科学","sortOrder":"22","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  28.   {"value":"俄语","text":"俄语","sortOrder":"23","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  29.   {"value":"韩语","text":"韩语","sortOrder":"24","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  30.   {"value":"法语","text":"法语","sortOrder":"25","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  31.   {"value":"德语","text":"德语","sortOrder":"26","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  32.   {"value":"西班牙语","text":"西班牙语","sortOrder":"27","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  33.   {"value":"藏文","text":"藏文","sortOrder":"28","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  34.   {"value":"科学基础","text":"科学基础","sortOrder":"29","relatedSubject":"无","type":"自定义","isDisplay":"是","isExam":"否"},
  35.   {"value":"人文基础","text":"人文基础","sortOrder":"30","relatedSubject":"无","type":"自定义","isDisplay":"是","isExam":"否"},
  36.   {"value":"生物1","text":"生物1","sortOrder":"31","relatedSubject":"生物","type":"自定义","isDisplay":"是","isExam":"否"},
  37.   {"value":"化学1","text":"化学1","sortOrder":"32","relatedSubject":"化学","type":"自定义","isDisplay":"是","isExam":"否"},
  38.   {"value":"生物2","text":"生物2","sortOrder":"33","relatedSubject":"生物","type":"自定义","isDisplay":"是","isExam":"否"},
  39.   {"value":"化学2","text":"化学2","sortOrder":"34","relatedSubject":"化学","type":"自定义","isDisplay":"是","isExam":"否"},
  40.   {"value":"数学文科","text":"数学文科","sortOrder":"35","relatedSubject":"数学","type":"自定义","isDisplay":"是","isExam":"否"},
  41.   {"value":"化学重点班","text":"化学重点班","sortOrder":"36","relatedSubject":"化学","type":"自定义","isDisplay":"是","isExam":"否"},
  42.   {"value":"物理重点班","text":"物理重点班","sortOrder":"37","relatedSubject":"物理","type":"自定义","isDisplay":"是","isExam":"否"}
  43. ]', 'insert', NULL, NULL, NULL);
  44. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'segment', 'array', '学部', '["小学", "初中", "高中"]', 'insert', NULL, NULL, NULL);
  45. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'semester', 'array', '学期', '["2024春季", "2023秋季"]', 'insert', NULL, NULL, NULL);
  46. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'level', 'array', '年级列表', '[{"value":"01","text":"一年级"},{"value": "02","text": "二年级"},{"value":"03","text":"三年级"},{"value": "04","text": "四年级"},{"value": "05","text": "五年级"},{"value": "06","text": "六年级"},{"value": "07","text": "七年级"},{"value": "08","text": "八年级"},{"value": "09","text": "九年级"},{"value": "10","text": "高一"},{"value": "11","text": "高二"},{"value": "12","text": "高三"}]', 'insert', NULL, NULL, NULL);
  47. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'afterSchoolCareType', 'array', '入托模式', '[
  48.           { "value": "日托", "text": "日托" }, 
  49.           { "value": "周托", "text": "周托" }, 
  50.           { "value": "半月托", "text": "半月托" }, 
  51.           { "value": "月托", "text": "月托" }
  52.         ]', 'insert', NULL, NULL, NULL);