package com.product.patch.config;
|
|
/**
|
* Copyright © 6c
|
*
|
* @Date: 2022-04-02 17:02
|
* @Author: 6c
|
* @Description:
|
*/
|
public class CmnConst {
|
private CmnConst() {}
|
|
public static final String TABLE_TYPE = "table_type";// 1-表，2-视图
|
public static final String OPERATE_TYPE = "operate_type";// 1-字段，2-索引
|
public static final String TABLE_NAME = "table_name";// 表名
|
public static final String NAME = "name";// 对象的名称，可能是字段名称，也可能是索引名称
|
public static final String DATA = "data";
|
|
// 数据库
|
public static final String DATABASE = "information_schema";
|
// 数据库字段
|
public static final String DATABASE_COLUMN = "TABLE_SCHEMA";
|
// 表名字段
|
public static final String TABLE_NAME_COLUMN = "TABLE_NAME";
|
// 表
|
public static final String TABLE = "TABLES";
|
// 表类型名字段
|
public static final String TABLE_TYPE_COLUMN = "TABLE_TYPE";
|
// 表类型-数据表
|
public static final String TABLE_TYPE_TABLE = "BASE TABLE";
|
// 表引擎
|
public static final String TABLE_ENGINE_COLUMN = "ENGINE";
|
// 表自增量
|
public static final String TABLE_AUTO_INCREMENT_COLUMN = "AUTO_INCREMENT";
|
// 表校验编码
|
public static final String TABLE_COLLATE_COLUMN = "TABLE_COLLATION";
|
// 表创建选项
|
public static final String TABLE_CREATE_OPTIONS_COLUMN = "CREATE_OPTIONS";
|
// 表注释
|
public static final String TABLE_COMMENT_COLUMN = "TABLE_COMMENT";
|
// 字段
|
public static final String COLUMNS = "COLUMNS";
|
// 字段名字段
|
public static final String COLUMNS_NAME_COLUMN = "COLUMN_NAME";
|
// 字段类型字段
|
public static final String COLUMNS_TYPE_COLUMN = "COLUMN_KEY";
|
// 字段类型-主键
|
public static final String COLUMNS_TYPE_PRIMARY_KEY = "PRI";
|
// 字段数据类型
|
public static final String COLUMNS_DATA_TYPE_COLUMN = "DATA_TYPE";
|
// 字段类型
|
public static final String COLUMNS_COLUMN_TYPE_COLUMN = "COLUMN_TYPE";
|
// 字段字符集
|
public static final String COLUMNS_CHARACTER_SET_NAME_COLUMN = "CHARACTER_SET_NAME";
|
// 字段是否为空
|
public static final String COLUMNS_IS_NULLABLE_COLUMN = "IS_NULLABLE";
|
// 字段默认值
|
public static final String COLUMNS_DEFAULT_COLUMN = "COLUMN_DEFAULT";
|
// 字段额外设置
|
public static final String COLUMNS_EXTRA_COLUMN = "EXTRA";
|
// 字段自增
|
public static final String COLUMNS_AUTO_INCREMENT = "auto_increment";
|
// 字段时间精度
|
public static final String COLUMNS_DATETIME_PRECISION_COLUMN = "DATETIME_PRECISION";
|
// 字段注释
|
public static final String COLUMNS_COMMENT_COLUMN = "COLUMN_COMMENT";
|
// 索引
|
public static final String INDEX = "STATISTICS";
|
// 索引-字段-索引名称
|
public static final String INDEX_NAME_COLUMN = "INDEX_NAME";
|
// 索引-字段内容-索引名称-主键
|
public static final String INDEX_NAME_PRIMARY = "PRIMARY";
|
// 约束
|
public static final String TABLE_CONSTRAINTS = "TABLE_CONSTRAINTS";
|
// 约束的键列
|
public static final String KEY_COLUMN_USAGE = "KEY_COLUMN_USAGE";
|
// 视图psf
|
public static final String VIEWS = "VIEWS";
|
// 视图-sql
|
public static final String VIEWS_DEFINITION_COLUMN = "VIEW_DEFINITION";
|
// 视图-安全类型
|
public static final String VIEWS_SECURITY_TYPE = "SECURITY_TYPE";
|
|
// 表
|
public static final String TABLE_PRODUCT_SYS_CLIENTS = "product_sys_clients";
|
public static final String TABLE_PRODUCT_SYS_ORG_LEVELS = "product_sys_org_levels";
|
public static final String TABLE_PRODUCT_SYS_PATCH_KEY = "product_sys_patch_key";
|
public static final String TABLE_PRODUCT_SYS_FUNCTIONS = "product_sys_functions";
|
public static final String TABLE_PRODUCT_SYS_BUTTONS = "product_sys_function_buttons";
|
public static final String TABLE_PRODUCT_SYS_MVC_PAGE = "product_sys_mvc_page";
|
public static final String TABLE_PRODUCT_SYS_LINK = "product_sys_link";
|
public static final String TABLE_PRODUCT_SYS_FLOW_MODEL = "product_sys_flow_model";
|
public static final String TABLE_PRODUCT_SYS_FLOW_NODE = "product_sys_flow_node";
|
public static final String TABLE_PRODUCT_SYS_FLOW_LINK = "product_sys_flow_link";
|
public static final String TABLE_PRODUCT_SYS_PROCESSOR = "product_sys_flow_processor";
|
|
// 通用字段
|
public static final String FIELD_UUID = "uuid";
|
public static final String FIELD_CLIENT_UUID = "client_uuid";
|
public static final String FIELD_ORG_LEVEL_UUID = "org_level_uuid";
|
|
// 字段
|
public static final String FIELD_PUBLIC_KEY = "public_key";
|
public static final String FIELD_PIRVATE_KEY = "private_key";
|
|
public static final String DEFAULT_OPERATOR = "admin";
|
public static final String DATE_FORMAT_1 = "yyyy-MM-dd";
|
|
// 参数
|
public static final String PARAM_DEPLOY_DATE = "deploy_date";
|
public static final String PARAM_OPERATOR = "operator";
|
public static final String PARAM_TABLE_REPORT = "table_report";
|
public static final String PARAM_TABLE_STRUCTURE = "table_structure";
|
public static final String PARAM_FUNCTION = "function";
|
public static final String PARAM_FLOW = "flow";
|
}
|
