江湖数字化平台
登录

常量

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

_constant 表数据

入学年列表

  • constantKey：enrollmentYear

  • constantType：object

  1. [
  2.   {
  3.     "value": "2022-2023",
  4.     "text": "2022-2023学年"
  5.   },
  6.   {
  7.     "value": "2023-2024",
  8.     "text": "2023-2024学年"
  9.   },
  10.   {
  11.     "value": "2024-2025",
  12.     "text": "2024-2025学年"
  13.   },
  14.   {
  15.     "value": "2025-2026",
  16.     "text": "2025-2026学年"
  17.   },
  18.   {
  19.     "value": "2026-2027",
  20.     "text": "2026-2027学年"
  21.   },
  22.   {
  23.     "value": "2027-2028",
  24.     "text": "2027-2028学年"
  25.   },
  26.   {
  27.     "value": "2028-2029",
  28.     "text": "2028-2029学年"
  29.   },
  30.   {
  31.     "value": "2029-2030",
  32.     "text": "2029-2030学年"
  33.   },
  34.   {
  35.     "value": "2030-2031",
  36.     "text": "2030-2031学年"
  37.   }
  38. ]

入学学期列表

  • constantKey：enrollmentSemester

  • constantType：object

  1. [
  2.   {
  3.     "value": "秋季",
  4.     "text": "秋季"
  5.   },
  6.   {
  7.     "value": "春季",
  8.     "text": "春季"
  9.   }
  10. ]

入学学部列表

  • constantKey：enrollmentSegment

  • constantType：object

  1. [
  2.   {
  3.     "value": "小学",
  4.     "text": "小学"
  5.   },
  6.   {
  7.     "value": "初中",
  8.     "text": "初中"
  9.   },
  10.   {
  11.     "value": "高中",
  12.     "text": "高中"
  13.   }
  14. ]

入学年级列表

  • constantKey：enrollmentLevel

  • constantType：object

  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：academicYear

  • constantType：object

  1. [
  2.   {
  3.     "value": "2022",
  4.     "text": "2022学年"
  5.   },
  6.   {
  7.     "value": "2023",
  8.     "text": "2023学年"
  9.   },
  10.   {
  11.     "value": "2024",
  12.     "text": "2024学年"
  13.   },
  14.   {
  15.     "value": "2025",
  16.     "text": "2025学年"
  17.   },
  18.   {
  19.     "value": "2026",
  20.     "text": "2026学年"
  21.   },
  22.   {
  23.     "value": "2027",
  24.     "text": "2027学年"
  25.   },
  26.   {
  27.     "value": "2028",
  28.     "text": "2028学年"
  29.   },
  30.   {
  31.     "value": "2029",
  32.     "text": "2029学年"
  33.   },
  34.   {
  35.     "value": "2030",
  36.     "text": "2030学年"
  37.   }
  38. ]

学期列表

  • constantKey：semester

  • constantType：object

  1. [
  2.   {
  3.     "value": "秋季",
  4.     "text": "秋季"
  5.   },
  6.   {
  7.     "value": "春季",
  8.     "text": "春季"
  9.   }
  10. ]

性别

  • constantKey：gender

  • constantType：object

  1. [
  2.   {
  3.     "value": "男",
  4.     "text": "男"
  5.   },
  6.   {
  7.     "value": "女",
  8.     "text": "女"
  9.   }
  10. ]

学部列表

  • constantKey：segment

  • constantType：object

  1. [
  2.   {
  3.     "value": "小学",
  4.     "text": "小学"
  5.   },
  6.   {
  7.     "value": "初中",
  8.     "text": "初中"
  9.   },
  10.   {
  11.     "value": "高中",
  12.     "text": "高中"
  13.   }
  14. ]

年级列表

  • constantKey：level

  • constantType：object

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

班号

  • constantKey：classNum

  • constantType：object

  1. [
  2.   {
  3.     "value": "00",
  4.     "text": "00班"
  5.   },
  6.   {
  7.     "value": "01",
  8.     "text": "01班"
  9.   },
  10.   {
  11.     "value": "02",
  12.     "text": "02班"
  13.   },
  14.   {
  15.     "value": "03",
  16.     "text": "03班"
  17.   },
  18.   {
  19.     "value": "04",
  20.     "text": "04班"
  21.   },
  22.   {
  23.     "value": "05",
  24.     "text": "05班"
  25.   },
  26.   {
  27.     "value": "06",
  28.     "text": "06班"
  29.   },
  30.   {
  31.     "value": "07",
  32.     "text": "07班"
  33.   },
  34.   {
  35.     "value": "08",
  36.     "text": "08班"
  37.   },
  38.   {
  39.     "value": "09",
  40.     "text": "09班"
  41.   },
  42.   {
  43.     "value": "10",
  44.     "text": "10班"
  45.   },
  46.   {
  47.     "value": "11",
  48.     "text": "11班"
  49.   },
  50.   {
  51.     "value": "12",
  52.     "text": "12班"
  53.   },
  54.   {
  55.     "value": "13",
  56.     "text": "13班"
  57.   },
  58.   {
  59.     "value": "14",
  60.     "text": "14班"
  61.   },
  62.   {
  63.     "value": "15",
  64.     "text": "15班"
  65.   },
  66.   {
  67.     "value": "16",
  68.     "text": "16班"
  69.   },
  70.   {
  71.     "value": "17",
  72.     "text": "17班"
  73.   },
  74.   {
  75.     "value": "18",
  76.     "text": "18班"
  77.   },
  78.   {
  79.     "value": "19",
  80.     "text": "19班"
  81.   },
  82.   {
  83.     "value": "20",
  84.     "text": "20班"
  85.   }
  86. ]

班级状态

  • constantKey：classStatus

  • constantType：object

  1. [
  2.   {
  3.     "value": "active",
  4.     "text": "开启"
  5.   },
  6.   {
  7.     "value": "archive",
  8.     "text": "关闭"
  9.   }
  10. ]

学生状态

  • constantKey：studentStatus

  • constantType：object

  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.   {
  19.     "value": "高中毕业",
  20.     "text": "高中毕业"
  21.   },
  22.   {
  23.     "value": "毕业离校",
  24.     "text": "毕业离校"
  25.   },
  26.   {
  27.     "value": "退学",
  28.     "text": "退学"
  29.   },
  30.   {
  31.     "value": "休学",
  32.     "text": "休学"
  33.   },
  34.   {
  35.     "value": "保籍",
  36.     "text": "保籍"
  37.   }
  38. ]

考试类型

  • constantKey：examType

  • constantType：object

  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.   {
  19.     "value": "竞赛",
  20.     "text": "竞赛"
  21.   },
  22.   {
  23.     "value": "模拟",
  24.     "text": "模拟"
  25.   },
  26.   {
  27.     "value": "练习",
  28.     "text": "练习"
  29.   },
  30.   {
  31.     "value": "其他",
  32.     "text": "其他"
  33.   }
  34. ]

考试状态

  • constantKey：examStatus

  • constantType：object

  1. [
  2.   {
  3.     "value": "已结束",
  4.     "text": "已结束"
  5.   },
  6.   {
  7.     "value": "进行中",
  8.     "text": "进行中"
  9.   }
  10. ]

科目列表

  • constantKey：subjectList

  • constantType：object

  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": "13",
  114.     "relatedSubject": "无",
  115.     "type": "默认",
  116.     "isDisplay": "是",
  117.     "isExam": "是"
  118.   },
  119.   {
  120.     "value": "文科综合",
  121.     "text": "文科综合",
  122.     "sortOrder": "14",
  123.     "relatedSubject": "无",
  124.     "type": "默认",
  125.     "isDisplay": "是",
  126.     "isExam": "是"
  127.   },
  128.   {
  129.     "value": "信息技术",
  130.     "text": "信息技术",
  131.     "sortOrder": "15",
  132.     "relatedSubject": "无",
  133.     "type": "辅课",
  134.     "isDisplay": "是",
  135.     "isExam": "否"
  136.   },
  137.   {
  138.     "value": "通用技术",
  139.     "text": "通用技术",
  140.     "sortOrder": "16",
  141.     "relatedSubject": "无",
  142.     "type": "辅课",
  143.     "isDisplay": "是",
  144.     "isExam": "否"
  145.   },
  146.   {
  147.     "value": "体育",
  148.     "text": "体育",
  149.     "sortOrder": "17",
  150.     "relatedSubject": "无",
  151.     "type": "辅课",
  152.     "isDisplay": "是",
  153.     "isExam": "否"
  154.   },
  155.   {
  156.     "value": "美术",
  157.     "text": "美术",
  158.     "sortOrder": "18",
  159.     "relatedSubject": "无",
  160.     "type": "辅课",
  161.     "isDisplay": "是",
  162.     "isExam": "否"
  163.   },
  164.   {
  165.     "value": "音乐",
  166.     "text": "音乐",
  167.     "sortOrder": "19",
  168.     "relatedSubject": "无",
  169.     "type": "辅课",
  170.     "isDisplay": "是",
  171.     "isExam": "否"
  172.   },
  173.   {
  174.     "value": "历史与社会",
  175.     "text": "历史与社会",
  176.     "sortOrder": "20",
  177.     "relatedSubject": "无",
  178.     "type": "辅课",
  179.     "isDisplay": "是",
  180.     "isExam": "否"
  181.   },
  182.   {
  183.     "value": "道德与法治",
  184.     "text": "道德与法治",
  185.     "sortOrder": "21",
  186.     "relatedSubject": "无",
  187.     "type": "辅课",
  188.     "isDisplay": "是",
  189.     "isExam": "否"
  190.   },
  191.   {
  192.     "value": "科学",
  193.     "text": "科学",
  194.     "sortOrder": "22",
  195.     "relatedSubject": "无",
  196.     "type": "辅课",
  197.     "isDisplay": "是",
  198.     "isExam": "否"
  199.   },
  200.   {
  201.     "value": "俄语",
  202.     "text": "俄语",
  203.     "sortOrder": "23",
  204.     "relatedSubject": "无",
  205.     "type": "小语种",
  206.     "isDisplay": "是",
  207.     "isExam": "否"
  208.   },
  209.   {
  210.     "value": "韩语",
  211.     "text": "韩语",
  212.     "sortOrder": "24",
  213.     "relatedSubject": "无",
  214.     "type": "小语种",
  215.     "isDisplay": "是",
  216.     "isExam": "否"
  217.   },
  218.   {
  219.     "value": "法语",
  220.     "text": "法语",
  221.     "sortOrder": "25",
  222.     "relatedSubject": "无",
  223.     "type": "小语种",
  224.     "isDisplay": "是",
  225.     "isExam": "否"
  226.   },
  227.   {
  228.     "value": "德语",
  229.     "text": "德语",
  230.     "sortOrder": "26",
  231.     "relatedSubject": "无",
  232.     "type": "小语种",
  233.     "isDisplay": "是",
  234.     "isExam": "否"
  235.   },
  236.   {
  237.     "value": "西班牙语",
  238.     "text": "西班牙语",
  239.     "sortOrder": "27",
  240.     "relatedSubject": "无",
  241.     "type": "小语种",
  242.     "isDisplay": "是",
  243.     "isExam": "否"
  244.   },
  245.   {
  246.     "value": "藏文",
  247.     "text": "藏文",
  248.     "sortOrder": "28",
  249.     "relatedSubject": "无",
  250.     "type": "小语种",
  251.     "isDisplay": "是",
  252.     "isExam": "否"
  253.   },
  254.   {
  255.     "value": "科学基础",
  256.     "text": "科学基础",
  257.     "sortOrder": "29",
  258.     "relatedSubject": "无",
  259.     "type": "自定义",
  260.     "isDisplay": "是",
  261.     "isExam": "否"
  262.   },
  263.   {
  264.     "value": "人文基础",
  265.     "text": "人文基础",
  266.     "sortOrder": "30",
  267.     "relatedSubject": "无",
  268.     "type": "自定义",
  269.     "isDisplay": "是",
  270.     "isExam": "否"
  271.   },
  272.   {
  273.     "value": "生物1",
  274.     "text": "生物1",
  275.     "sortOrder": "31",
  276.     "relatedSubject": "生物",
  277.     "type": "自定义",
  278.     "isDisplay": "是",
  279.     "isExam": "否"
  280.   },
  281.   {
  282.     "value": "化学1",
  283.     "text": "化学1",
  284.     "sortOrder": "32",
  285.     "relatedSubject": "化学",
  286.     "type": "自定义",
  287.     "isDisplay": "是",
  288.     "isExam": "否"
  289.   },
  290.   {
  291.     "value": "生物2",
  292.     "text": "生物2",
  293.     "sortOrder": "33",
  294.     "relatedSubject": "生物",
  295.     "type": "自定义",
  296.     "isDisplay": "是",
  297.     "isExam": "否"
  298.   },
  299.   {
  300.     "value": "化学2",
  301.     "text": "化学2",
  302.     "sortOrder": "34",
  303.     "relatedSubject": "化学",
  304.     "type": "自定义",
  305.     "isDisplay": "是",
  306.     "isExam": "否"
  307.   },
  308.   {
  309.     "value": "数学文科",
  310.     "text": "数学文科",
  311.     "sortOrder": "35",
  312.     "relatedSubject": "数学",
  313.     "type": "自定义",
  314.     "isDisplay": "是",
  315.     "isExam": "否"
  316.   },
  317.   {
  318.     "value": "化学重点班",
  319.     "text": "化学重点班",
  320.     "sortOrder": "36",
  321.     "relatedSubject": "化学",
  322.     "type": "自定义",
  323.     "isDisplay": "是",
  324.     "isExam": "否"
  325.   },
  326.   {
  327.     "value": "物理重点班",
  328.     "text": "物理重点班",
  329.     "sortOrder": "37",
  330.     "relatedSubject": "物理",
  331.     "type": "自定义",
  332.     "isDisplay": "是",
  333.     "isExam": "否"
  334.   }
  335. ]

考试成绩录入状态

  • constantKey：examResultStatus

  • constantType：object

  1. [
  2.   {
  3.     "value": "未录入",
  4.     "text": "未录入"
  5.   },
  6.   {
  7.     "value": "已录入",
  8.     "text": "已录入"
  9.   },
  10.   {
  11.     "value": "已审核",
  12.     "text": "已审核"
  13.   }
  14. ]

学年列表V2

  • constantKey：academicYearV2

  • constantType：object

  1. [
  2.   {
  3.     "value": "2020-2021",
  4.     "text": "2020-2021学年",
  5.     "startYear": "2020",
  6.     "endYear": "2021"
  7.   },
  8.   {
  9.     "value": "2021-2022",
  10.     "text": "2021-2022学年",
  11.     "startYear": "2021",
  12.     "endYear": "2022"
  13.   },
  14.   {
  15.     "value": "2022-2023",
  16.     "text": "2022-2023学年",
  17.     "startYear": "2022",
  18.     "endYear": "2023"
  19.   },
  20.   {
  21.     "value": "2023-2024",
  22.     "text": "2023-2024学年",
  23.     "startYear": "2023",
  24.     "endYear": "2024"
  25.   },
  26.   {
  27.     "value": "2024-2025",
  28.     "text": "2024-2025学年",
  29.     "startYear": "2024",
  30.     "endYear": "2025"
  31.   },
  32.   {
  33.     "value": "2025-2026",
  34.     "text": "2025-2026学年",
  35.     "startYear": "2025",
  36.     "endYear": "2026"
  37.   },
  38.   {
  39.     "value": "2026-2027",
  40.     "text": "2026-2027学年",
  41.     "startYear": "2026",
  42.     "endYear": "2027"
  43.   },
  44.   {
  45.     "value": "2027-2028",
  46.     "text": "2027-2028学年",
  47.     "startYear": "2027",
  48.     "endYear": "2028"
  49.   },
  50.   {
  51.     "value": "2028-2029",
  52.     "text": "2028-2029学年",
  53.     "startYear": "2028",
  54.     "endYear": "2029"
  55.   },
  56.   {
  57.     "value": "2029-2030",
  58.     "text": "2029-2030学年",
  59.     "startYear": "2029",
  60.     "endYear": "2030"
  61.   },
  62.   {
  63.     "value": "2030-2031",
  64.     "text": "2030-2031学年",
  65.     "startYear": "2030",
  66.     "endYear": "2031"
  67.   }
  68. ]

学科方向

  • constantKey：learningTrack

  • constantType：object

  1. null

当前学期

  • constantKey：currentSemester

  • constantType：object

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

_constant语句

  1. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'enrollmentYear', 'object', '入学年列表', '[{"value":"2022-2023","text":"2022-2023学年"},{"value": "2023-2024","text": "2023-2024学年"},{"value":"2024-2025","text":"2024-2025学年"},{"value": "2025-2026","text": "2025-2026学年"},{"value": "2026-2027","text": "2026-2027学年"},{"value": "2027-2028","text": "2027-2028学年"},{"value": "2028-2029","text": "2028-2029学年"},{"value": "2029-2030","text": "2029-2030学年"},{"value": "2030-2031","text": "2030-2031学年"}]', 'insert', NULL, NULL, NULL);
  2. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'enrollmentSemester', 'object', '入学学期列表', '[{"value":"秋季","text":"秋季"},{"value": "春季","text": "春季"}]', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'enrollmentSegment', 'object', '入学学部列表', '[{"value":"小学","text":"小学"},{"value": "初中","text": "初中"},{"value": "高中","text": "高中"}]', 'insert', NULL, NULL, NULL);
  4. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'enrollmentLevel', 'object', '入学年级列表', '[{"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);
  5. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'academicYear', 'object', '学年列表', '[{"value":"2022","text":"2022学年"},{"value": "2023","text": "2023学年"},{"value":"2024","text":"2024学年"},{"value": "2025","text": "2025学年"},{"value": "2026","text": "2026学年"},{"value": "2027","text": "2027学年"},{"value": "2028","text": "2028学年"},{"value": "2029","text": "2029学年"},{"value": "2030","text": "2030学年"}]', 'insert', NULL, NULL, NULL);
  6. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'semester', 'object', '学期列表', '[{"value":"秋季","text":"秋季"},{"value": "春季","text": "春季"}]', 'insert', NULL, NULL, NULL);
  7. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'gender', 'object', '性别', '[{"value":"男","text":"男"},{"value": "女","text": "女"}]', 'insert', NULL, NULL, NULL);
  8. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'segment', 'object', '学部列表', '[{"value":"小学","text":"小学"},{"value": "初中","text": "初中"},{"value": "高中","text": "高中"}]', 'insert', NULL, NULL, NULL);
  9. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'level', 'object', '年级列表', '[
  10.     {"value":"01","text":"一年级","segment":"小学"},
  11.     {"value":"02","text":"二年级","segment":"小学"},
  12.     {"value":"03","text":"三年级","segment":"小学"},
  13.     {"value": "04","text": "四年级","segment":"小学"},
  14.     {"value": "05","text": "五年级","segment":"小学"},
  15.     {"value": "06","text": "六年级","segment":"小学"},
  16.     {"value": "07","text": "七年级","segment":"初中"},
  17.     {"value": "08","text": "八年级","segment":"初中"},
  18.     {"value": "09","text": "九年级","segment":"初中"},
  19.     {"value": "10","text": "高一","segment":"高中"},
  20.     {"value": "11","text": "高二","segment":"高中"},
  21.     {"value": "12","text": "高三","segment":"高中"}
  22. ]', 'insert', NULL, NULL, NULL);
  23. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'classNum', 'object', '班号', '[{"value":"00","text":"00班"},{"value":"01","text":"01班"},{"value": "02","text": "02班"},{"value":"03","text":"03班"},{"value": "04","text": "04班"},{"value": "05","text": "05班"},{"value": "06","text": "06班"},{"value": "07","text": "07班"},{"value": "08","text": "08班"},{"value": "09","text": "09班"},{"value": "10","text": "10班"},{"value": "11","text": "11班"},{"value": "12","text": "12班"},{"value":"13","text":"13班"},{"value": "14","text": "14班"},{"value":"15","text":"15班"},{"value": "16","text": "16班"},{"value": "17","text": "17班"},{"value": "18","text": "18班"},{"value": "19","text": "19班"},{"value": "20","text": "20班"}]', 'insert', NULL, NULL, NULL);
  24. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'classStatus', 'object', '班级状态', '[{"value":"active","text":"开启"},{"value": "archive","text": "关闭"}]', 'insert', NULL, NULL, NULL);
  25. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'studentStatus', 'object', '学生状态', '[{"value":"新生","text":"新生"},{"value": "在校","text": "在校"},{"value": "小学毕业","text": "小学毕业"},{"value": "初中毕业","text": "初中毕业"},{"value": "高中毕业","text": "高中毕业"},{"value": "毕业离校","text": "毕业离校"},{"value": "退学","text": "退学"},{"value": "休学","text": "休学"},{"value": "保籍","text": "保籍"}]', 'insert', NULL, NULL, NULL);
  26. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'examType', 'object', '考试类型', '[{"value":"周测","text":"周测"},{"value":"月考","text":"月考"},{"value":"期中","text":"期中"},{"value":"期末","text":"期末"},{"value":"竞赛","text":"竞赛"},{"value":"模拟","text":"模拟"},{"value":"练习","text":"练习"},{"value":"其他","text":"其他"}]', 'insert', NULL, NULL, NULL);
  27. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'examStatus', 'object', '考试状态', '[{"value":"已结束","text":"已结束"},{"value":"进行中","text":"进行中"}]', 'insert', NULL, NULL, NULL);
  28. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (25, 'subjectList', 'object', '科目列表', '[
  29.   {"value":"语文","text":"语文","sortOrder":"01","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  30.   {"value":"数学","text":"数学","sortOrder":"02","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  31.   {"value":"英语","text":"英语","sortOrder":"03","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  32.   {"value":"物理","text":"物理","sortOrder":"04","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  33.   {"value":"化学","text":"化学","sortOrder":"05","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  34.   {"value":"生物","text":"生物","sortOrder":"06","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  35.   {"value":"政治","text":"政治","sortOrder":"07","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  36.   {"value":"历史","text":"历史","sortOrder":"08","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  37.   {"value":"地理","text":"地理","sortOrder":"09","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  38.   {"value":"日语","text":"日语","sortOrder":"10","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  39.   {"value":"地生","text":"地生","sortOrder":"11","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  40.   {"value":"体育","text":"体育","sortOrder":"12","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  41.   {"value":"理科综合","text":"理科综合","sortOrder":"13","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  42.   {"value":"文科综合","text":"文科综合","sortOrder":"14","relatedSubject":"无","type":"默认","isDisplay":"是","isExam":"是"},
  43.   {"value":"信息技术","text":"信息技术","sortOrder":"15","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  44.   {"value":"通用技术","text":"通用技术","sortOrder":"16","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  45.   {"value":"体育","text":"体育","sortOrder":"17","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  46.   {"value":"美术","text":"美术","sortOrder":"18","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  47.   {"value":"音乐","text":"音乐","sortOrder":"19","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  48.   {"value":"历史与社会","text":"历史与社会","sortOrder":"20","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  49.   {"value":"道德与法治","text":"道德与法治","sortOrder":"21","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  50.   {"value":"科学","text":"科学","sortOrder":"22","relatedSubject":"无","type":"辅课","isDisplay":"是","isExam":"否"},
  51.   {"value":"俄语","text":"俄语","sortOrder":"23","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  52.   {"value":"韩语","text":"韩语","sortOrder":"24","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  53.   {"value":"法语","text":"法语","sortOrder":"25","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  54.   {"value":"德语","text":"德语","sortOrder":"26","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  55.   {"value":"西班牙语","text":"西班牙语","sortOrder":"27","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  56.   {"value":"藏文","text":"藏文","sortOrder":"28","relatedSubject":"无","type":"小语种","isDisplay":"是","isExam":"否"},
  57.   {"value":"科学基础","text":"科学基础","sortOrder":"29","relatedSubject":"无","type":"自定义","isDisplay":"是","isExam":"否"},
  58.   {"value":"人文基础","text":"人文基础","sortOrder":"30","relatedSubject":"无","type":"自定义","isDisplay":"是","isExam":"否"},
  59.   {"value":"生物1","text":"生物1","sortOrder":"31","relatedSubject":"生物","type":"自定义","isDisplay":"是","isExam":"否"},
  60.   {"value":"化学1","text":"化学1","sortOrder":"32","relatedSubject":"化学","type":"自定义","isDisplay":"是","isExam":"否"},
  61.   {"value":"生物2","text":"生物2","sortOrder":"33","relatedSubject":"生物","type":"自定义","isDisplay":"是","isExam":"否"},
  62.   {"value":"化学2","text":"化学2","sortOrder":"34","relatedSubject":"化学","type":"自定义","isDisplay":"是","isExam":"否"},
  63.   {"value":"数学文科","text":"数学文科","sortOrder":"35","relatedSubject":"数学","type":"自定义","isDisplay":"是","isExam":"否"},
  64.   {"value":"化学重点班","text":"化学重点班","sortOrder":"36","relatedSubject":"化学","type":"自定义","isDisplay":"是","isExam":"否"},
  65.   {"value":"物理重点班","text":"物理重点班","sortOrder":"37","relatedSubject":"物理","type":"自定义","isDisplay":"是","isExam":"否"}
  66. ]', 'insert', NULL, NULL, NULL);
  67. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'examResultStatus', 'object', '考试成绩录入状态', '[{"value":"未录入","text":"未录入"},{"value":"已录入","text":"已录入"},{"value":"已审核","text":"已审核"}]', 'insert', NULL, NULL, NULL);
  68. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'academicYearV2', 'object', '学年列表V2', '[
  69.   { "value": "2020-2021","text": "2020-2021学年","startYear": "2020","endYear": "2021" },
  70.   { "value": "2021-2022","text": "2021-2022学年","startYear": "2021","endYear": "2022" },
  71.   { "value": "2022-2023","text": "2022-2023学年","startYear": "2022","endYear": "2023" },
  72.   { "value": "2023-2024","text": "2023-2024学年","startYear": "2023","endYear": "2024" },
  73.   { "value": "2024-2025","text": "2024-2025学年","startYear": "2024","endYear": "2025" },
  74.   { "value": "2025-2026","text": "2025-2026学年","startYear": "2025","endYear": "2026" },
  75.   { "value": "2026-2027","text": "2026-2027学年","startYear": "2026","endYear": "2027" },
  76.   { "value": "2027-2028","text": "2027-2028学年","startYear": "2027","endYear": "2028" },
  77.   { "value": "2028-2029","text": "2028-2029学年","startYear": "2028","endYear": "2029" },
  78.   { "value": "2029-2030","text": "2029-2030学年","startYear": "2029","endYear": "2030" },
  79.   { "value": "2030-2031","text": "2030-2031学年","startYear": "2030","endYear": "2031" }
  80. ]', 'insert', NULL, NULL, NULL);
  81. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'learningTrack', 'object', '学科方向', NULL, 'insert', NULL, NULL, NULL);
  82. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'currentSemester', 'object', '当前学期', '{"year": 2024, "semester": "春季"}', 'insert', '', '', '');