江湖数字化平台
登录

常量

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

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

入学学期列表

  • constantKey：enrollmentSemester

  • constantType：array

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

入学学部列表

  • constantKey：enrollmentSegment

  • constantType：array

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

入学年级列表

  • constantKey：enrollmentLevel

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

  • constantType：array

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

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

性别

  • constantKey：gender

  • constantType：array

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

学部列表

  • constantKey：segment

  • constantType：array

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

年级列表

  • 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.   {
  19.     "value": "走读",
  20.     "text": "走读"
  21.   }
  22. ]

监护人1关系列表

  • constantKey：guardian1Relationship

  • 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.   {
  19.     "value": "其他",
  20.     "text": "其他"
  21.   }
  22. ]

监护人2关系列表

  • constantKey：guardian2Relationship

  • 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.   {
  19.     "value": "其他",
  20.     "text": "其他"
  21.   }
  22. ]

宿舍楼号

  • constantKey：hostelName

  • 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.   {
  19.     "value": "修竹居",
  20.     "text": "修竹居"
  21.   },
  22.   {
  23.     "value": "兰蕙居A",
  24.     "text": "兰蕙居A"
  25.   },
  26.   {
  27.     "value": "兰蕙居B",
  28.     "text": "兰蕙居B"
  29.   }
  30. ]

床号

  • constantKey：hostelBedId

  • constantType：array

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

是否完成入学信息录入

  • constantKey：completedEnrollmentRecordYesOrNo

  • constantType：array

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

是否完成住宿餐桌信息录入

  • constantKey：completedLogisticsAssignedYesOrNo

  • constantType：array

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

是否完成学费缴费

  • constantKey：completedPaymentYesOrNo

  • constantType：array

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

班号

  • constantKey：number

  • constantType：array

  1. [
  2.   {
  3.     "value": "00",
  4.     "text": "待分班"
  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：array

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

入学班级

  • constantKey：enrollmentClassId

  • constantType：array

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

开学日期

  • constantKey：schoolStartDate

  • constantType：string

  1. 2022-09-01

学生状态

  • constantKey：studentStatus

  • 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.   {
  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：completedEnrollmentYesOrNo

  • constantType：array

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

是否完成批准退学

  • constantKey：completedQuitYesOrNo

  • constantType：array

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

班级类型

  • constantKey：classType

  • constantType：array

  1. [
  2.   {
  3.     "value": "formal",
  4.     "text": "正式班"
  5.   },
  6.   {
  7.     "value": "transition",
  8.     "text": "过渡班"
  9.   }
  10. ]

申请类型

  • constantKey：requestType

  • constantType：array

  1. [
  2.   {
  3.     "value": "申请退学",
  4.     "text": "申请退学"
  5.   },
  6.   {
  7.     "value": "申请保籍",
  8.     "text": "申请保籍"
  9.   },
  10.   {
  11.     "value": "申请休学",
  12.     "text": "申请休学"
  13.   }
  14. ]

是否完成退宿

  • constantKey：completedQuitAssignedYesOrNo

  • constantType：array

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

是否完成退费

  • constantKey：completedQuitPaymentYesOrNo

  • constantType：array

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

当前学年学期

  • constantKey：currentSemester

  • constantType：object

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

_constant语句

  1. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'enrollmentYear', 'array', '入学年列表', '[{"value":"2019-2020","text":"2019-2020学年"},{"value":"2020-2021","text":"2020-2021学年"},{"value":"2021-2022","text":"2021-2022学年"},{"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', 'array', '入学学期列表', '[{"value":"秋季","text":"秋季"},{"value": "春季","text": "春季"}]', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'enrollmentSegment', 'array', '入学学部列表', '[{"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', '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);
  5. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'academicYear', 'array', '学年列表', '[{"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', 'array', '学期列表', '[{"value":"秋季","text":"秋季"},{"value": "春季","text": "春季"}]', 'insert', NULL, NULL, NULL);
  7. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'gender', 'array', '性别', '[{"value":"男","text":"男"},{"value": "女","text": "女"}]', 'insert', NULL, NULL, NULL);
  8. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'segment', 'array', '学部列表', '[{"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', '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);
  10. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'afterSchoolCareType', 'array', '就读方式', '[{"value":"日托","text":"日托"},{"value": "周托","text": "周托"},{"value": "半月托","text": "半月托"},{"value": "月托","text": "月托"},{"value": "走读","text": "走读"}]', 'insert', NULL, NULL, NULL);
  11. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'guardian1Relationship', 'array', '监护人1关系列表', '[{"value":"父亲","text":"父亲"},{"value": "母亲","text": "母亲"},{"value": "祖父母或外祖父母","text": "祖父母或外祖父母"},{"value": "兄弟姐妹","text": "兄弟姐妹"},{"value": "其他","text": "其他"}]', 'insert', NULL, NULL, NULL);
  12. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'guardian2Relationship', 'array', '监护人2关系列表', '[{"value":"父亲","text":"父亲"},{"value": "母亲","text": "母亲"},{"value": "祖父母或外祖父母","text": "祖父母或外祖父母"},{"value": "兄弟姐妹","text": "兄弟姐妹"},{"value": "其他","text": "其他"}]', 'insert', NULL, NULL, NULL);
  13. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'hostelName', 'array', '宿舍楼号', '[{"value":"清朗居","text":"清朗居"},{"value": "景和居","text": "景和居"},{"value": "静志居","text": "静志居"},{"value": "茂松居","text": "茂松居"},{"value": "修竹居","text": "修竹居"},{"value": "兰蕙居A","text": "兰蕙居A"},{"value": "兰蕙居B","text": "兰蕙居B"}]', 'insert', NULL, NULL, NULL);
  14. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'hostelBedId', 'array', '床号', '[{"value":"01","text":"1号"},{"value": "02","text": "2号"},{"value": "03","text": "3号"},{"value": "04","text": "4号"},{"value": "05","text": "5号"},{"value": "06","text": "6号"},{"value": "07","text": "7号"},{"value": "08","text": "8号"}]', 'insert', NULL, NULL, NULL);
  15. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'completedEnrollmentRecordYesOrNo', 'array', '是否完成入学信息录入', '[{"value":"完成","text":"完成"},{"value": "未完成","text": "未完成"}]', 'insert', NULL, NULL, NULL);
  16. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'completedLogisticsAssignedYesOrNo', 'array', '是否完成住宿餐桌信息录入', '[{"value":"完成","text":"完成"},{"value": "未完成","text": "未完成"}]', 'insert', NULL, NULL, NULL);
  17. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'completedPaymentYesOrNo', 'array', '是否完成学费缴费', '[{"value":"完成","text":"完成"},{"value": "未完成","text": "未完成"}]', 'insert', NULL, NULL, NULL);
  18. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'number', 'array', '班号', '[{"value":"00","text":"待分班"},{"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);
  19. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'classStatus', 'array', '班级状态', '[{"value":"active","text":"开启"},{"value": "archive","text": "关闭"}]', 'insert', NULL, NULL, NULL);
  20. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'enrollmentClassId', 'array', '入学班级', '[{"value":"01-00","text":"一年级班"},{"value": "02-00","text": "二年级班"},{"value":"03-00","text":"三年级班"},{"value": "04-00","text": "四年级班"},{"value": "05-00","text": "五年级班"},{"value": "06-00","text": "六年级班"},{"value": "07-00","text": "七年级班"},{"value": "08-00","text": "八年级班"},{"value": "09-00","text": "九年级班"},{"value": "10-00","text": "高一班"},{"value": "11-00","text": "高二班"},{"value": "12-00","text": "高三班"}]', 'insert', NULL, NULL, NULL);
  21. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'schoolStartDate', 'string', '开学日期', '2022-09-01', 'insert', NULL, NULL, NULL);
  22. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'studentStatus', 'array', '学生状态', '[{"value":"新生","text":"新生"},{"value": "在校","text": "在校"},{"value": "小学毕业","text": "小学毕业"},{"value": "初中毕业","text": "初中毕业"},{"value": "高中毕业","text": "高中毕业"},{"value": "退学","text": "退学"},{"value": "休学","text": "休学"},{"value": "保籍","text": "保籍"}]', 'insert', NULL, NULL, NULL);
  23. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'completedEnrollmentYesOrNo', 'array', '是否完成批准入学', '[{"value":"完成","text":"完成"},{"value": "未完成","text": "未完成"}]', 'insert', NULL, NULL, NULL);
  24. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'completedQuitYesOrNo', 'array', '是否完成批准退学', '[{"value":"完成","text":"完成"},{"value": "未完成","text": "未完成"}]', 'insert', NULL, NULL, NULL);
  25. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (25, 'classType', 'array', '班级类型', '[{"value":"formal","text":"正式班"},{"value": "transition","text": "过渡班"}]', 'insert', NULL, NULL, NULL);
  26. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'requestType', 'array', '申请类型', '[{"value":"申请退学","text":"申请退学"},{"value": "申请保籍","text": "申请保籍"},{"value": "申请休学","text": "申请休学"}]', 'insert', NULL, NULL, NULL);
  27. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'completedQuitAssignedYesOrNo', 'array', '是否完成退宿', '[{"value":"完成","text":"完成"},{"value": "未完成","text": "未完成"}]', 'insert', NULL, NULL, NULL);
  28. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'completedQuitPaymentYesOrNo', 'array', '是否完成退费', '[{"value":"完成","text":"完成"},{"value": "未完成","text": "未完成"}]', 'insert', NULL, NULL, NULL);
  29. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'currentSemester', 'object', '当前学年学期', '{"year": 2023, "semester": "春季"}', 'insert', NULL, NULL, NULL);