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";
}