OmegaAi/BackEnd/OmegaSource/Model/Database/DatabaseField.cs

using Common;
using Mapster;
using Util;


namespace Model
{
    /// <summary>
    /// 数据字段 database_field
    /// </summary>
    [SugarTable("database_field", "数据字段")]
    [Tenant("0")]
    public class DatabaseField
    {
        /// <summary>
        /// ID
        /// </summary>
        [SugarColumn(ColumnDescription = "ID", IsPrimaryKey = true, IsIdentity = true, ColumnName = "id")]
        public int id { get; set; }


        /// <summary>
        /// 版本号
        /// </summary>
        [SugarColumn(ColumnDescription = "版本号", ColumnName = "version")]
        public int version { get; set; }


        /// <summary>
        /// 删除标记
        /// </summary>
        [SugarColumn(ColumnDescription = "删除标记", ColumnName = "del_flag")]
        public int delFlag { get; set; }


        /// <summary>
        /// 创建时间
        /// </summary>
        [SugarColumn(ColumnDescription = "创建时间", ColumnName = "create_time")]
        public DateTime? createTime { get; set; }


        /// <summary>
        /// 更新时间
        /// </summary>
        [SugarColumn(ColumnDescription = "更新时间", ColumnName = "update_time")]
        public DateTime? updateTime { get; set; }


        /// <summary>
        /// 创建人
        /// </summary>
        [SugarColumn(ColumnDescription = "创建人", Length = 32, ColumnName = "create_by")]
        public string? createBy { get; set; }


        /// <summary>
        /// 更新人
        /// </summary>
        [SugarColumn(ColumnDescription = "更新人", Length = 32, ColumnName = "update_by")]
        public string? updateBy { get; set; }


        /// <summary>
        /// 数据库
        /// </summary>
        [SugarColumn(ColumnDescription = "数据库", ColumnName = "database_id")]
        public int databaseId { get; set; }


        /// <summary>
        /// 数据表
        /// </summary>
        [SugarColumn(ColumnDescription = "数据表", ColumnName = "table_id")]
        public int tableId { get; set; }


        /// <summary>
        /// 选项卡
        /// </summary>
        [SugarColumn(ColumnDescription = "选项卡", ColumnName = "tab_id")]
        public int tabId { get; set; }


        /// <summary>
        /// 字段标题
        /// </summary>
        [SugarColumn(ColumnDescription = "字段标题", Length = 50, ColumnName = "field_title")]
        public string? fieldTitle { get; set; }


        /// <summary>
        /// 字段名
        /// </summary>
        [SugarColumn(ColumnDescription = "字段名", Length = 50, ColumnName = "field_name")]
        public string? fieldName { get; set; }
        [SugarColumn(IsIgnore = true)]
        public string? fieldNameUpper 
        {
            get
            {
                return PublicFunction.transferName(fieldName);
            }
        }


        /// <summary>
        /// 字段类型
        /// </summary>
        [SugarColumn(ColumnDescription = "字段类型", Length = 20, ColumnName = "field_type")]
        public string? fieldType { get; set; }
        [SugarColumn(IsIgnore = true)]
        public bool notNull 
        {
            get
            {
                if (Function.CheckNull(fieldType).Contains("int") || fieldType == "bit" || fieldType == "numeric")
                {
                    return true;
                }
                return false;
            }
        }


        /// <summary>
        /// 字段长度
        /// </summary>
        [SugarColumn(ColumnDescription = "字段长度", Length = 10, ColumnName = "field_length")]
        public string? fieldLength { get; set; }


        /// <summary>
        /// 字段默认值
        /// </summary>
        [SugarColumn(ColumnDescription = "字段默认值", Length = 50, ColumnName = "field_default_value")]
        public string? fieldDefaultValue { get; set; }


        /// <summary>
        /// 字段说明
        /// </summary>
        [SugarColumn(ColumnDescription = "字段说明", Length = 255, ColumnName = "field_detail")]
        public string? fieldDetail { get; set; }


        /// <summary>
        /// 编辑类型
        /// </summary>
        [SugarColumn(ColumnDescription = "编辑类型", Length = 20, ColumnName = "edit_type")]
        public string? editType { get; set; }


        /// <summary>
        /// 验证属性
        /// </summary>
        [SugarColumn(ColumnDescription = "验证属性", Length = 255, ColumnName = "validate_attribute")]
        public string? validateAttribute { get; set; }


        /// <summary>
        /// 主键
        /// </summary>
        [SugarColumn(ColumnDescription = "主键", ColumnName = "primary_key")]
        public bool primaryKey { get; set; }


        /// <summary>
        /// 自动增长
        /// </summary>
        [SugarColumn(ColumnDescription = "自动增长", ColumnName = "auto_increment")]
        public bool autoIncrement { get; set; }


        /// <summary>
        /// 分表字段
        /// </summary>
        [SugarColumn(ColumnDescription = "分表字段", ColumnName = "split_flag")]
        public bool splitFlag { get; set; }


        /// <summary>
        /// 列表显示
        /// </summary>
        [SugarColumn(ColumnDescription = "列表显示", ColumnName = "show_list")]
        public bool showList { get; set; }


        /// <summary>
        /// 查询条件
        /// </summary>
        [SugarColumn(ColumnDescription = "查询条件", ColumnName = "show_query")]
        public bool showQuery { get; set; }


        /// <summary>
        /// 是否编辑
        /// </summary>
        [SugarColumn(ColumnDescription = "是否编辑", ColumnName = "show_edit")]
        public bool showEdit { get; set; }


        /// <summary>
        /// 检查重复
        /// </summary>
        [SugarColumn(ColumnDescription = "检查重复", ColumnName = "check_repeat")]
        public bool checkRepeat { get; set; }


        /// <summary>
        /// 导出标记
        /// </summary>
        [SugarColumn(ColumnDescription = "导出标记", ColumnName = "export_flag")]
        public bool exportFlag { get; set; }


        /// <summary>
        /// 导入标记
        /// </summary>
        [SugarColumn(ColumnDescription = "导入标记", ColumnName = "import_flag")]
        public bool importFlag { get; set; }


        /// <summary>
        /// 列表编辑
        /// </summary>
        [SugarColumn(ColumnDescription = "列表编辑", ColumnName = "list_edit_flag")]
        public bool listEditFlag { get; set; }


        /// <summary>
        /// 列表编辑提示文字
        /// </summary>
        [SugarColumn(ColumnDescription = "列表编辑提示文字", Length = 50, ColumnName = "list_edit_placeholder")]
        public string? listEditPlaceholder { get; set; }


        /// <summary>
        /// 统计条件字段
        /// </summary>
        [SugarColumn(ColumnDescription = "统计条件字段", ColumnName = "stat_condition")]
        public bool statCondition { get; set; }


        /// <summary>
        /// 统计数据字段
        /// </summary>
        [SugarColumn(ColumnDescription = "统计数据字段", ColumnName = "stat_data")]
        public bool statData { get; set; }


        /// <summary>
        /// 关联数据表
        /// </summary>
        [SugarColumn(ColumnDescription = "关联数据表", ColumnName = "link_table_id")]
        public int linkTableId { get; set; }


        /// <summary>
        /// 关联数据字段
        /// </summary>
        [SugarColumn(ColumnDescription = "关联数据字段", ColumnName = "link_field_id")]
        public int linkFieldId { get; set; }


        /// <summary>
        /// 关联数据源ID
        /// </summary>
        [SugarColumn(ColumnDescription = "关联数据源ID", ColumnName = "api_id")]
        public int apiId { get; set; }


        /// <summary>
        /// 索引
        /// </summary>
        [SugarColumn(ColumnDescription = "索引", ColumnName = "index_flag")]
        public bool indexFlag { get; set; }



    }
}