Constants

12120

Overview of Constants

_constant Structure

CREATE TABLE `_constant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jhId` varchar(255)  DEFAULT NULL,
  `constantKey` varchar(255)  DEFAULT NULL,
  `constantType` varchar(255)  DEFAULT NULL COMMENT 'Constant type; object, array',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'Description',
  `constantValue` text  COMMENT 'Constant content; object, array',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Constant table; soft delete not enabled;'

_constant Table Data

Member Price

constantKey	constantType
memberPrice	integer

homeRecommendType

constantKey	constantType
homeRecommendType	array

[
  {
    "value": "banner",
    "text": "Carousel"
  },
  {
    "value": "navIcon",
    "text": "Navigation Icon"
  },
  {
    "value": "news",
    "text": "News"
  },
  {
    "value": "bulletin",
    "text": "Bulletin"
  },
  {
    "value": "activity",
    "text": "Activity"
  },
  {
    "value": "ad",
    "text": "Advertisement"
  },
  {
    "value": "live",
    "text": "Live"
  },
  {
    "value": "course",
    "text": "Course"
  },
  {
    "value": "link",
    "text": "Custom Link"
  },
  {
    "value": "goods",
    "text": "Goods"
  },
  {
    "value": "hotLive",
    "text": "Hot Live"
  },
  {
    "value": "teacher",
    "text": "Instructor"
  },
  {
    "value": "groupBooking",
    "text": "Group Booking"
  },
  {
    "value": "menu",
    "text": "Menu"
  },
  {
    "value": "material",
    "text": "Material"
  },
  {
    "value": "exam",
    "text": "Exam"
  },
  {
    "value": "data",
    "text": "Document"
  },
  {
    "value": "exercise",
    "text": "Exercise"
  }
]

homeRecommendContentDisplay

constantKey	constantType
homeRecommendContentDisplay	array

[
  {
    "value": "big",
    "text": "Large Image"
  },
  {
    "value": "grid",
    "text": "Grid Image"
  },
  {
    "value": "small",
    "text": "Small Image"
  },
  {
    "value": "row",
    "text": "Left-Right Switch"
  }
]

Order Status

constantKey	constantType
orderStatus	array

[
  {
    "value": "waitpay",
    "text": "Pending Payment"
  },
  {
    "value": "paid",
    "text": "Paid"
  },
  {
    "value": "refunded",
    "text": "Refunded"
  },
  {
    "value": "cancel",
    "text": "Cancelled"
  },
  {
    "value": "waitSend",
    "text": "Pending Shipment"
  },
  {
    "value": "waitReceive",
    "text": "Pending Receipt"
  },
  {
    "value": "waitComment",
    "text": "Pending Review"
  },
  {
    "value": "commented",
    "text": "Reviewed"
  }
]

Refund Status

constantKey	constantType
refundStatus	array

[
  {
    "value": "unrefund",
    "text": "Not Refunded"
  },
  {
    "value": "applying",
    "text": "Applying for Refund"
  },
  {
    "value": "refunded",
    "text": "Refunded"
  }
]

Product Type

constantKey	constantType
productType	array

[
  {
    "value": "product",
    "text": "Product"
  },
  {
    "value": "course",
    "text": "Course"
  },
  {
    "value": "exam",
    "text": "Exam"
  },
  {
    "value": "material",
    "text": "Material"
  }
]

Member Privilege Level

constantKey	constantType
memberPrivilegeLevel	array

[
  {
    "value": "001",
    "text": "001 Member"
  },
  {
    "value": "101",
    "text": "101 Member"
  },
  {
    "value": "201",
    "text": "201 Member"
  }
]

Notice

constantKey	constantType
notice	object

{
  "title": "Version 4.3.7 Released",
  "content": "Come and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\n",
  "imageSrc": "/noticeImage/1647076649263_719911_noticeImage.jpeg",
  "isImageShown": false,
  "isTextShown": true
}

User Status

constantKey	constantType
userStatus	array

[
  {
    "value": "active",
    "text": "Active"
  },
  {
    "value": "banned",
    "text": "Banned"
  }
]

User Type

constantKey	constantType
userType	array

[
  {
    "value": "common",
    "text": "Regular User"
  },
  {
    "value": "xiaochengxu",
    "text": "Mini Program Bot"
  }
]

Gender

constantKey	constantType
gender	array

[
  {
    "value": "male",
    "text": "Male"
  },
  {
    "value": "female",
    "text": "Female"
  }
]

Version

constantKey	constantType
version	object

{
  "testUserIdList": "",
  "version": "4.3.11",
  "title": "Version 4.3.7 Released",
  "note": "New version introduction\n 1. Chat input optimization",
  "apkVersion": "5.0.20",
  "apkLink": "https://duoxing.openjianghu.org/duoxing/upload/10002/1647840662817_956853_D多星MD-4.7.10.apk",
  "apkNote": "",
  "desktopVersion": "4.3.2",
  "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip",
  "desktopNote": "Testing desktop client upgrade"
}

Emotion

constantKey	constantType
emotion	array

[
  {
    "dir": "face01",
    "cover": "face-lbl",
    "ext": "png",
    "cols": 5,
    "total": 86
  },
  {
    "dir": "face02",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face03",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face04",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face05",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 1,
    "total": 7
  },
  {
    "dir": "face06",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 24
  },
  {
    "dir": "face07",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face08",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 23
  },
  {
    "dir": "face09",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face10",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 20
  },
  {
    "dir": "face11",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 13
  },
  {
    "dir": "face12",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face13",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 15
  },
  {
    "dir": "face14",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  }
]

appLinkActionConfig

constantKey	constantType
appLinkActionConfig	array

[
  {
    "regex": ".openjianghu.org/*",
    "action": "internal"
  },
  {
    "regex": "http://192.168./*",
    "action": "internal"
  }
]

constantKey	constantType
share	array

[
  {
    "path": "/upload/image/share/shareImage01.jpg"
  }
]

Order Status

constantKey	constantType
orderStatus	array

[
  {
    "value": "waitpay",
    "text": "Pending Payment"
  },
  {
    "value": "paid",
    "text": "Paid"
  },
  {
    "value": "refunding",
    "text": "Refunding"
  },
  {
    "value": "refunded",
    "text": "Refunded"
  },
  {
    "value": "cancel",
    "text": "Cancelled"
  },
  {
    "value": "waitSend",
    "text": "Pending Shipment"
  },
  {
    "value": "waitReceive",
    "text": "Pending Receipt"
  },
  {
    "value": "waitComment",
    "text": "Pending Review"
  },
  {
    "value": "commented",
    "text": "Reviewed"
  }
]

Refund Status

constantKey	constantType
refundStatus	array

[
  {
    "value": "unrefund",
    "text": "Not Refunded"
  },
  {
    "value": "applying",
    "text": "Refunding"
  },
  {
    "value": "refunded",
    "text": "Refunded"
  }
]

_constant Statements

INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'mgmt', 'memberPrice', 'integer', 'Member Price', '99', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'mgmt', 'homeRecommendType', 'array', NULL, '[{"value": "banner", "text": "Carousel"}, {"value": "navIcon", "text": "Navigation Icon"}, {"value": "news", "text": "News"}, {"value": "bulletin", "text": "Bulletin"}, {"value": "activity", "text": "Activity"}, {"value": "ad", "text": "Advertisement"}, {"value": "live", "text": "Live"}, {"value": "course", "text": "Course"}, {"value": "link", "text": "Custom Link"}, {"value": "goods", "text": "Goods"}, {"value": "hotLive", "text": "Hot Live"}, {"value": "teacher", "text": "Instructor"}, {"value": "groupBooking", "text": "Group Booking"}, {"value": "menu", "text": "Menu"}, {"value": "material", "text": "Material"}, {"value": "exam", "text": "Exam"}, {"value": "data", "text": "Document"}, {"value": "exercise", "text": "Exercise"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'mgmt', 'homeRecommendContentDisplay', 'array', NULL, '[{"value": "big", "text": "Large Image"}, {"value": "grid", "text": "Grid Image"}, {"value": "small", "text": "Small Image"}, {"value": "row", "text": "Left-Right Switch"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'mgmt', 'orderStatus', 'array', 'Order Status', '[{"value":"waitpay","text":"Pending Payment"},{"value":"paid","text":"Paid"},{"value":"refunded","text":"Refunded"},{"value":"cancel","text":"Cancelled"},{"value":"waitSend","text":"Pending Shipment"},{"value":"waitReceive","text":"Pending Receipt"},{"value":"waitComment","text":"Pending Review"},{"value":"commented","text":"Reviewed"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'mgmt', 'refundStatus', 'array', 'Refund Status', '[{"value":"unrefund","text":"Not Refunded"},{"value":"applying","text":"Applying for Refund"},{"value":"refunded","text":"Refunded"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'mgmt', 'productType', 'array', 'Product Type', '[{"value":"product","text":"Product"},{"value":"course","text":"Course"},{"value":"exam","text":"Exam"},{"value":"material","text":"Material"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'mgmt', 'memberPrivilegeLevel', 'array', 'Member Privilege Level', '[{"value":"001","text":"001 Member"},{"value":"101","text":"101 Member"},{"value":"201","text":"201 Member"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'teacher', 'notice', 'object', '', '{"title":"Version 4.3.7 Released","content":"Come and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\n","imageSrc":"/noticeImage/1647076649263_719911_noticeImage.jpeg","isImageShown":false,"isTextShown":true}', 'update', 'admin01', 'admin01', '2022-03-12T17:19:50+08:00');
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'teacher', 'userStatus', 'array', NULL, '[{"value": "active", "text": "Active"}, {"value": "banned", "text": "Banned"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'teacher', 'userType', 'array', NULL, '[{"value": "common", "text": "Regular User"},{"value": "xiaochengxu", "text": "Mini Program Bot"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'teacher', 'gender', 'array', NULL, '[{"value": "male", "text": "Male"}, {"value": "female", "text": "Female"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'teacher', 'version', 'object', NULL, '{"testUserIdList": "","version": "4.3.11", "title": "Version 4.3.7 Released", "note": "New version introduction\n 1. Chat input optimization", "apkVersion": "5.0.20", "apkLink": "https://duoxing.openjianghu.org/duoxing/upload/10002/1647840662817_956853_D多星MD-4.7.10.apk", "apkNote": "", "desktopVersion": "4.3.2", "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip", "desktopNote": "Testing desktop client upgrade" }', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'teacher', 'emotion', 'array', NULL, '[
  {
    "dir":"face01",
    "cover":"face-lbl",
    "ext":"png",
    "cols":5,
    "total":86
  },
  {
    "dir":"face02",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face03",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face04",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face05",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":1,
    "total":7
  },
  {
    "dir":"face06",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":24
  },
  {
    "dir":"face07",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face08",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":23
  },
  {
    "dir":"face09",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face10",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":20
  },
  {
    "dir":"face11",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":13
  },
  {
    "dir":"face12",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face13",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":15
  },
  {
    "dir":"face14",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  }
]
', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'teacher', 'appLinkActionConfig', 'array', NULL, '[{"regex":".openjianghu.org\/*", "action": "internal"}, {"regex":"http:\/\/192.168.\/*", "action": "internal"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'teacher', 'linkList', 'object', 'Link List', '[
    {
    "linkName": "courseCRUD",
    "url": "https://fsapp.eggjs.tech/fs_member-course_v1/page/courseManagement",
        "appId": "fs_member-course_v1",
        "pageId": "courseManagement",
    "params": [
      "courseBatchId",
      "title"
    ]
  }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'teacher', 'articleType', 'array', 'Article Type', '[
    {
            "text": "Article",
            "value": "article"
    },
    {
            "text": "Assignment",
            "value": "assignment"
    },
    {
            "text": "Exam",
            "value": "exam"
    },
    {
            "text": "Material",
            "value": "material"
    },
    {
            "text": "News",
            "value": "news"
    }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'teacher', 'articlePublishStatus', 'array', 'Article Publish Status', '[
    {
        "text": "Visible to Logged-in Users",
        "value": "login"
    },
    {
        "text": "Draft",
        "value": "draft"
    },
    {
        "text": "Recycle Bin",
        "value": "deleted"
    }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'teacher', 'isDelShowStatus', 'array', 'Display Status', '[
    {
            "text": "All",
            "value": null
    },
    {
            "text": "Normal",
            "value": "false"
    },
    {
            "text": "Recycle Bin",
            "value": "true"
    }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'teacher', 'auditStatus', 'array', 'Audit Status', '[
    {
            "text": "All",
            "value": null
    },
    {
            "text": "Pending",
            "value": "pending"
    },
    {
            "text": "Approved",
            "value": "approve"
    },
    {
            "text": "Rejected",
            "value": "reject"
    }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'teacher', 'memberPrivilegeLevel', 'array', 'Member Privilege Level', '[{"value":"001","text":"001 Member"},{"value":"101","text":"101 Member"},{"value":"201","text":"201 Member"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'student', 'notice', 'object', '', '{"title":"Version 4.3.7 Released","content":"Come and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\n","imageSrc":"/noticeImage/1647076649263_719911_noticeImage.jpeg","isImageShown":false,"isTextShown":true}', 'update', 'admin01', 'admin01', '2022-03-12T17:19:50+08:00');
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'student', 'userStatus', 'array', NULL, '[{"value": "active", "text": "Active"}, {"value": "banned", "text": "Banned"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'student', 'userType', 'array', NULL, '[{"value": "common", "text": "Regular User"},{"value": "xiaochengxu", "text": "Mini Program Bot"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (25, 'student', 'gender', 'array', NULL, '[{"value": "male", "text": "Male"}, {"value": "female", "text": "Female"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'student', 'version', 'object', NULL, '{"testUserIdList": "admin01","version": "5.0.22", "title": "Version 5.0.19 Released", "note": "New version introduction\n 1. Web UI Fixes", "apkVersion": "5.1.8", "apkLink": "https://nextcloud.openjianghu.org/index.php/s/SyRaPyt9nFbFryX/download/%E6%97%8B%E9%A3%8E5-5.0.20.apk", "apkNote": "New version introduction\n 1. Web UI Fixes", "desktopVersion": "4.3.2", "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip", "desktopNote": "Testing desktop client upgrade" }', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'student', 'emotion', 'array', NULL, '[
  {
    "dir":"face01",
    "cover":"face-lbl",
    "ext":"png",
    "cols":5,
    "total":86
  },
  {
    "dir":"face02",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face03",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face04",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face05",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":1,
    "total":7
  },
  {
    "dir":"face06",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":24
  },
  {
    "dir":"face07",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face08",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":23
  },
  {
    "dir":"face09",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face10",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":20
  },
  {
    "dir":"face11",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":13
  },
  {
    "dir":"face12",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face13",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":15
  },
  {
    "dir":"face14",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  }
]
', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'student', 'appLinkActionConfig', 'array', NULL, '[{"regex":".openjianghu.org\/*", "action": "internal"}, {"regex":"http:\/\/192.168.\/*", "action": "internal"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'student', 'share', 'array', NULL, '[{"path":"/upload/image/share/shareImage01.jpg"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (30, 'student', 'orderStatus', 'array', 'Order Status', '[{"value":"waitpay","text":"Pending Payment"},{"value":"paid","text":"Paid"},{"value":"refunding","text":"Refunding"},{"value":"refunded","text":"Refunded"},{"value":"cancel","text":"Cancelled"},{"value":"waitSend","text":"Pending Shipment"},{"value":"waitReceive","text":"Pending Receipt"},{"value":"waitComment","text":"Pending Review"},{"value":"commented","text":"Reviewed"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'student', 'refundStatus', 'array', 'Refund Status', '[{"value":"unrefund","text":"Not Refunded"},{"value":"applying","text":"Refunding"},{"value":"refunded","text":"Refunded"}]', 'insert', NULL, NULL, NULL);

# Overview of Constants

## _constant Structure

```sql
CREATE TABLE `_constant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jhId` varchar(255)  DEFAULT NULL,
  `constantKey` varchar(255)  DEFAULT NULL,
  `constantType` varchar(255)  DEFAULT NULL COMMENT 'Constant type; object, array',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'Description',
  `constantValue` text  COMMENT 'Constant content; object, array',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Constant table; soft delete not enabled;'
```

## _constant Table Data

### Member Price

| constantKey | constantType |
| --- | --- |
| memberPrice | integer |

```js
99
```

### homeRecommendType

| constantKey | constantType |
| --- | --- |
| homeRecommendType | array |

```js
[
  {
    "value": "banner",
    "text": "Carousel"
  },
  {
    "value": "navIcon",
    "text": "Navigation Icon"
  },
  {
    "value": "news",
    "text": "News"
  },
  {
    "value": "bulletin",
    "text": "Bulletin"
  },
  {
    "value": "activity",
    "text": "Activity"
  },
  {
    "value": "ad",
    "text": "Advertisement"
  },
  {
    "value": "live",
    "text": "Live"
  },
  {
    "value": "course",
    "text": "Course"
  },
  {
    "value": "link",
    "text": "Custom Link"
  },
  {
    "value": "goods",
    "text": "Goods"
  },
  {
    "value": "hotLive",
    "text": "Hot Live"
  },
  {
    "value": "teacher",
    "text": "Instructor"
  },
  {
    "value": "groupBooking",
    "text": "Group Booking"
  },
  {
    "value": "menu",
    "text": "Menu"
  },
  {
    "value": "material",
    "text": "Material"
  },
  {
    "value": "exam",
    "text": "Exam"
  },
  {
    "value": "data",
    "text": "Document"
  },
  {
    "value": "exercise",
    "text": "Exercise"
  }
]
```

### homeRecommendContentDisplay

| constantKey | constantType |
| --- | --- |
| homeRecommendContentDisplay | array |

```js
[
  {
    "value": "big",
    "text": "Large Image"
  },
  {
    "value": "grid",
    "text": "Grid Image"
  },
  {
    "value": "small",
    "text": "Small Image"
  },
  {
    "value": "row",
    "text": "Left-Right Switch"
  }
]
```

### Order Status

| constantKey | constantType |
| --- | --- |
| orderStatus | array |

```js
[
  {
    "value": "waitpay",
    "text": "Pending Payment"
  },
  {
    "value": "paid",
    "text": "Paid"
  },
  {
    "value": "refunded",
    "text": "Refunded"
  },
  {
    "value": "cancel",
    "text": "Cancelled"
  },
  {
    "value": "waitSend",
    "text": "Pending Shipment"
  },
  {
    "value": "waitReceive",
    "text": "Pending Receipt"
  },
  {
    "value": "waitComment",
    "text": "Pending Review"
  },
  {
    "value": "commented",
    "text": "Reviewed"
  }
]
```

### Refund Status

| constantKey | constantType |
| --- | --- |
| refundStatus | array |

```js
[
  {
    "value": "unrefund",
    "text": "Not Refunded"
  },
  {
    "value": "applying",
    "text": "Applying for Refund"
  },
  {
    "value": "refunded",
    "text": "Refunded"
  }
]
```

### Product Type

| constantKey | constantType |
| --- | --- |
| productType | array |

```js
[
  {
    "value": "product",
    "text": "Product"
  },
  {
    "value": "course",
    "text": "Course"
  },
  {
    "value": "exam",
    "text": "Exam"
  },
  {
    "value": "material",
    "text": "Material"
  }
]
```

### Member Privilege Level

| constantKey | constantType |
| --- | --- |
| memberPrivilegeLevel | array |

```js
[
  {
    "value": "001",
    "text": "001 Member"
  },
  {
    "value": "101",
    "text": "101 Member"
  },
  {
    "value": "201",
    "text": "201 Member"
  }
]
```

### Notice

| constantKey | constantType |
| --- | --- |
| notice | object |

```js
{
  "title": "Version 4.3.7 Released",
  "content": "Come and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\n",
  "imageSrc": "/noticeImage/1647076649263_719911_noticeImage.jpeg",
  "isImageShown": false,
  "isTextShown": true
}
```

### User Status

| constantKey | constantType |
| --- | --- |
| userStatus | array |

```js
[
  {
    "value": "active",
    "text": "Active"
  },
  {
    "value": "banned",
    "text": "Banned"
  }
]
```

### User Type

| constantKey | constantType |
| --- | --- |
| userType | array |

```js
[
  {
    "value": "common",
    "text": "Regular User"
  },
  {
    "value": "xiaochengxu",
    "text": "Mini Program Bot"
  }
]
```

### Gender

| constantKey | constantType |
| --- | --- |
| gender | array |

```js
[
  {
    "value": "male",
    "text": "Male"
  },
  {
    "value": "female",
    "text": "Female"
  }
]
```

### Version

| constantKey | constantType |
| --- | --- |
| version | object |

```js
{
  "testUserIdList": "",
  "version": "4.3.11",
  "title": "Version 4.3.7 Released",
  "note": "New version introduction\n 1. Chat input optimization",
  "apkVersion": "5.0.20",
  "apkLink": "https://duoxing.openjianghu.org/duoxing/upload/10002/1647840662817_956853_D多星MD-4.7.10.apk",
  "apkNote": "",
  "desktopVersion": "4.3.2",
  "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip",
  "desktopNote": "Testing desktop client upgrade"
}
```

### Emotion

| constantKey | constantType |
| --- | --- |
| emotion | array |

```js
[
  {
    "dir": "face01",
    "cover": "face-lbl",
    "ext": "png",
    "cols": 5,
    "total": 86
  },
  {
    "dir": "face02",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face03",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face04",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face05",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 1,
    "total": 7
  },
  {
    "dir": "face06",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 24
  },
  {
    "dir": "face07",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face08",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 23
  },
  {
    "dir": "face09",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face10",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 20
  },
  {
    "dir": "face11",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 13
  },
  {
    "dir": "face12",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face13",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 15
  },
  {
    "dir": "face14",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  }
]
```

### appLinkActionConfig

| constantKey | constantType |
| --- | --- |
| appLinkActionConfig | array |

```js
[
  {
    "regex": ".openjianghu.org/*",
    "action": "internal"
  },
  {
    "regex": "http://192.168./*",
    "action": "internal"
  }
]
```

### Share

| constantKey | constantType |
| --- | --- |
| share | array |

```js
[
  {
    "path": "/upload/image/share/shareImage01.jpg"
  }
]
```

### Order Status

| constantKey | constantType |
| --- | --- |
| orderStatus | array |

```js
[
  {
    "value": "waitpay",
    "text": "Pending Payment"
  },
  {
    "value": "paid",
    "text": "Paid"
  },
  {
    "value": "refunding",
    "text": "Refunding"
  },
  {
    "value": "refunded",
    "text": "Refunded"
  },
  {
    "value": "cancel",
    "text": "Cancelled"
  },
  {
    "value": "waitSend",
    "text": "Pending Shipment"
  },
  {
    "value": "waitReceive",
    "text": "Pending Receipt"
  },
  {
    "value": "waitComment",
    "text": "Pending Review"
  },
  {
    "value": "commented",
    "text": "Reviewed"
  }
]
```

### Refund Status

| constantKey | constantType |
| --- | --- |
| refundStatus | array |

```js
[
  {
    "value": "unrefund",
    "text": "Not Refunded"
  },
  {
    "value": "applying",
    "text": "Refunding"
  },
  {
    "value": "refunded",
    "text": "Refunded"
  }
]
```

## _constant Statements

```sql
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'mgmt', 'memberPrice', 'integer', 'Member Price', '99', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'mgmt', 'homeRecommendType', 'array', NULL, '[{"value": "banner", "text": "Carousel"}, {"value": "navIcon", "text": "Navigation Icon"}, {"value": "news", "text": "News"}, {"value": "bulletin", "text": "Bulletin"}, {"value": "activity", "text": "Activity"}, {"value": "ad", "text": "Advertisement"}, {"value": "live", "text": "Live"}, {"value": "course", "text": "Course"}, {"value": "link", "text": "Custom Link"}, {"value": "goods", "text": "Goods"}, {"value": "hotLive", "text": "Hot Live"}, {"value": "teacher", "text": "Instructor"}, {"value": "groupBooking", "text": "Group Booking"}, {"value": "menu", "text": "Menu"}, {"value": "material", "text": "Material"}, {"value": "exam", "text": "Exam"}, {"value": "data", "text": "Document"}, {"value": "exercise", "text": "Exercise"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'mgmt', 'homeRecommendContentDisplay', 'array', NULL, '[{"value": "big", "text": "Large Image"}, {"value": "grid", "text": "Grid Image"}, {"value": "small", "text": "Small Image"}, {"value": "row", "text": "Left-Right Switch"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'mgmt', 'orderStatus', 'array', 'Order Status', '[{"value":"waitpay","text":"Pending Payment"},{"value":"paid","text":"Paid"},{"value":"refunded","text":"Refunded"},{"value":"cancel","text":"Cancelled"},{"value":"waitSend","text":"Pending Shipment"},{"value":"waitReceive","text":"Pending Receipt"},{"value":"waitComment","text":"Pending Review"},{"value":"commented","text":"Reviewed"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'mgmt', 'refundStatus', 'array', 'Refund Status', '[{"value":"unrefund","text":"Not Refunded"},{"value":"applying","text":"Applying for Refund"},{"value":"refunded","text":"Refunded"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'mgmt', 'productType', 'array', 'Product Type', '[{"value":"product","text":"Product"},{"value":"course","text":"Course"},{"value":"exam","text":"Exam"},{"value":"material","text":"Material"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'mgmt', 'memberPrivilegeLevel', 'array', 'Member Privilege Level', '[{"value":"001","text":"001 Member"},{"value":"101","text":"101 Member"},{"value":"201","text":"201 Member"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'teacher', 'notice', 'object', '', '{"title":"Version 4.3.7 Released","content":"Come and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\n","imageSrc":"/noticeImage/1647076649263_719911_noticeImage.jpeg","isImageShown":false,"isTextShown":true}', 'update', 'admin01', 'admin01', '2022-03-12T17:19:50+08:00');
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'teacher', 'userStatus', 'array', NULL, '[{"value": "active", "text": "Active"}, {"value": "banned", "text": "Banned"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'teacher', 'userType', 'array', NULL, '[{"value": "common", "text": "Regular User"},{"value": "xiaochengxu", "text": "Mini Program Bot"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'teacher', 'gender', 'array', NULL, '[{"value": "male", "text": "Male"}, {"value": "female", "text": "Female"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'teacher', 'version', 'object', NULL, '{"testUserIdList": "","version": "4.3.11", "title": "Version 4.3.7 Released", "note": "New version introduction\n 1. Chat input optimization", "apkVersion": "5.0.20", "apkLink": "https://duoxing.openjianghu.org/duoxing/upload/10002/1647840662817_956853_D多星MD-4.7.10.apk", "apkNote": "", "desktopVersion": "4.3.2", "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip", "desktopNote": "Testing desktop client upgrade" }', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'teacher', 'emotion', 'array', NULL, '[
  {
    "dir":"face01",
    "cover":"face-lbl",
    "ext":"png",
    "cols":5,
    "total":86
  },
  {
    "dir":"face02",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face03",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face04",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face05",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":1,
    "total":7
  },
  {
    "dir":"face06",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":24
  },
  {
    "dir":"face07",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face08",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":23
  },
  {
    "dir":"face09",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face10",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":20
  },
  {
    "dir":"face11",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":13
  },
  {
    "dir":"face12",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face13",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":15
  },
  {
    "dir":"face14",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  }
]
', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'teacher', 'appLinkActionConfig', 'array', NULL, '[{"regex":".openjianghu.org\/*", "action": "internal"}, {"regex":"http:\/\/192.168.\/*", "action": "internal"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'teacher', 'linkList', 'object', 'Link List', '[
	{
    "linkName": "courseCRUD",
    "url": "https://fsapp.eggjs.tech/fs_member-course_v1/page/courseManagement",
		"appId": "fs_member-course_v1",
		"pageId": "courseManagement",
    "params": [
      "courseBatchId",
      "title"
    ]
  }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'teacher', 'articleType', 'array', 'Article Type', '[
	{
			"text": "Article",
			"value": "article"
	},
	{
			"text": "Assignment",
			"value": "assignment"
	},
	{
			"text": "Exam",
			"value": "exam"
	},
	{
			"text": "Material",
			"value": "material"
	},
	{
			"text": "News",
			"value": "news"
	}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'teacher', 'articlePublishStatus', 'array', 'Article Publish Status', '[
    {
        "text": "Visible to Logged-in Users",
        "value": "login"
    },
    {
        "text": "Draft",
        "value": "draft"
    },
    {
        "text": "Recycle Bin",
        "value": "deleted"
    }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'teacher', 'isDelShowStatus', 'array', 'Display Status', '[
	{
			"text": "All",
			"value": null
	},
	{
			"text": "Normal",
			"value": "false"
	},
	{
			"text": "Recycle Bin",
			"value": "true"
	}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'teacher', 'auditStatus', 'array', 'Audit Status', '[
	{
			"text": "All",
			"value": null
	},
	{
			"text": "Pending",
			"value": "pending"
	},
	{
			"text": "Approved",
			"value": "approve"
	},
	{
			"text": "Rejected",
			"value": "reject"
	}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'teacher', 'memberPrivilegeLevel', 'array', 'Member Privilege Level', '[{"value":"001","text":"001 Member"},{"value":"101","text":"101 Member"},{"value":"201","text":"201 Member"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'student', 'notice', 'object', '', '{"title":"Version 4.3.7 Released","content":"Come and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\nCome and use it!\nTest 12123123\n","imageSrc":"/noticeImage/1647076649263_719911_noticeImage.jpeg","isImageShown":false,"isTextShown":true}', 'update', 'admin01', 'admin01', '2022-03-12T17:19:50+08:00');
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'student', 'userStatus', 'array', NULL, '[{"value": "active", "text": "Active"}, {"value": "banned", "text": "Banned"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'student', 'userType', 'array', NULL, '[{"value": "common", "text": "Regular User"},{"value": "xiaochengxu", "text": "Mini Program Bot"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (25, 'student', 'gender', 'array', NULL, '[{"value": "male", "text": "Male"}, {"value": "female", "text": "Female"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'student', 'version', 'object', NULL, '{"testUserIdList": "admin01","version": "5.0.22", "title": "Version 5.0.19 Released", "note": "New version introduction\n 1. Web UI Fixes", "apkVersion": "5.1.8", "apkLink": "https://nextcloud.openjianghu.org/index.php/s/SyRaPyt9nFbFryX/download/%E6%97%8B%E9%A3%8E5-5.0.20.apk", "apkNote": "New version introduction\n 1. Web UI Fixes", "desktopVersion": "4.3.2", "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip", "desktopNote": "Testing desktop client upgrade" }', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'student', 'emotion', 'array', NULL, '[
  {
    "dir":"face01",
    "cover":"face-lbl",
    "ext":"png",
    "cols":5,
    "total":86
  },
  {
    "dir":"face02",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face03",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face04",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face05",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":1,
    "total":7
  },
  {
    "dir":"face06",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":24
  },
  {
    "dir":"face07",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face08",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":23
  },
  {
    "dir":"face09",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face10",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":20
  },
  {
    "dir":"face11",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":13
  },
  {
    "dir":"face12",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face13",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":15
  },
  {
    "dir":"face14",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  }
]
', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'student', 'appLinkActionConfig', 'array', NULL, '[{"regex":".openjianghu.org\/*", "action": "internal"}, {"regex":"http:\/\/192.168.\/*", "action": "internal"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'student', 'share', 'array', NULL, '[{"path":"/upload/image/share/shareImage01.jpg"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (30, 'student', 'orderStatus', 'array', 'Order Status', '[{"value":"waitpay","text":"Pending Payment"},{"value":"paid","text":"Paid"},{"value":"refunding","text":"Refunding"},{"value":"refunded","text":"Refunded"},{"value":"cancel","text":"Cancelled"},{"value":"waitSend","text":"Pending Shipment"},{"value":"waitReceive","text":"Pending Receipt"},{"value":"waitComment","text":"Pending Review"},{"value":"commented","text":"Reviewed"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'student', 'refundStatus', 'array', 'Refund Status', '[{"value":"unrefund","text":"Not Refunded"},{"value":"applying","text":"Refunding"},{"value":"refunded","text":"Refunded"}]', 'insert', NULL, NULL, NULL);
```