Constants

12126

Overview of Constants

_constant Structure

CREATE TABLE `_constant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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 'Content of the constant; 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 = 66 DEFAULT CHARSET = utf8mb4 COMMENT = 'Constants table;'

Data in _constant Table

notice

| constantKey | constantType |
|