DatabaseField.cs 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274
  1. using Mapster;
  2. using Util;
  3. namespace Model
  4. {
  5. /// <summary>
  6. /// 数据字段 database_field
  7. /// </summary>
  8. [SugarTable("database_field", "数据字段")]
  9. [Tenant("0")]
  10. public class DatabaseField
  11. {
  12. /// <summary>
  13. /// ID
  14. /// </summary>
  15. [SugarColumn(ColumnDescription = "ID", IsPrimaryKey = true, IsIdentity = true, ColumnName = "id")]
  16. public int id { get; set; }
  17. /// <summary>
  18. /// 版本号
  19. /// </summary>
  20. [SugarColumn(ColumnDescription = "版本号", ColumnName = "version")]
  21. public int version { get; set; }
  22. /// <summary>
  23. /// 删除标记
  24. /// </summary>
  25. [SugarColumn(ColumnDescription = "删除标记", ColumnName = "del_flag")]
  26. public int delFlag { get; set; }
  27. /// <summary>
  28. /// 创建时间
  29. /// </summary>
  30. [SugarColumn(ColumnDescription = "创建时间", ColumnName = "create_time")]
  31. public DateTime? createTime { get; set; }
  32. /// <summary>
  33. /// 更新时间
  34. /// </summary>
  35. [SugarColumn(ColumnDescription = "更新时间", ColumnName = "update_time")]
  36. public DateTime? updateTime { get; set; }
  37. /// <summary>
  38. /// 创建人
  39. /// </summary>
  40. [SugarColumn(ColumnDescription = "创建人", Length = 32, ColumnName = "create_by")]
  41. public string? createBy { get; set; }
  42. /// <summary>
  43. /// 更新人
  44. /// </summary>
  45. [SugarColumn(ColumnDescription = "更新人", Length = 32, ColumnName = "update_by")]
  46. public string? updateBy { get; set; }
  47. /// <summary>
  48. /// 数据库
  49. /// </summary>
  50. [SugarColumn(ColumnDescription = "数据库", ColumnName = "database_id")]
  51. public int databaseId { get; set; }
  52. /// <summary>
  53. /// 数据表
  54. /// </summary>
  55. [SugarColumn(ColumnDescription = "数据表", ColumnName = "table_id")]
  56. public int tableId { get; set; }
  57. /// <summary>
  58. /// 选项卡
  59. /// </summary>
  60. [SugarColumn(ColumnDescription = "选项卡", ColumnName = "tab_id")]
  61. public int tabId { get; set; }
  62. /// <summary>
  63. /// 字段标题
  64. /// </summary>
  65. [SugarColumn(ColumnDescription = "字段标题", Length = 50, ColumnName = "field_title")]
  66. public string? fieldTitle { get; set; }
  67. /// <summary>
  68. /// 字段名
  69. /// </summary>
  70. [SugarColumn(ColumnDescription = "字段名", Length = 50, ColumnName = "field_name")]
  71. public string? fieldName { get; set; }
  72. [SugarColumn(IsIgnore = true)]
  73. public string? fieldNameUpper
  74. {
  75. get
  76. {
  77. return PublicFunction.transferName(fieldName);
  78. }
  79. }
  80. /// <summary>
  81. /// 字段类型
  82. /// </summary>
  83. [SugarColumn(ColumnDescription = "字段类型", Length = 20, ColumnName = "field_type")]
  84. public string? fieldType { get; set; }
  85. [SugarColumn(IsIgnore = true)]
  86. public bool notNull
  87. {
  88. get
  89. {
  90. if (fieldType == "int" || fieldType == "bigint" || fieldType == "bit" || fieldType == "numeric")
  91. {
  92. return true;
  93. }
  94. return false;
  95. }
  96. }
  97. /// <summary>
  98. /// 字段长度
  99. /// </summary>
  100. [SugarColumn(ColumnDescription = "字段长度", Length = 10, ColumnName = "field_length")]
  101. public string? fieldLength { get; set; }
  102. /// <summary>
  103. /// 字段默认值
  104. /// </summary>
  105. [SugarColumn(ColumnDescription = "字段默认值", Length = 50, ColumnName = "field_default_value")]
  106. public string? fieldDefaultValue { get; set; }
  107. /// <summary>
  108. /// 字段说明
  109. /// </summary>
  110. [SugarColumn(ColumnDescription = "字段说明", Length = 255, ColumnName = "field_detail")]
  111. public string? fieldDetail { get; set; }
  112. /// <summary>
  113. /// 编辑类型
  114. /// </summary>
  115. [SugarColumn(ColumnDescription = "编辑类型", Length = 20, ColumnName = "edit_type")]
  116. public string? editType { get; set; }
  117. /// <summary>
  118. /// 验证属性
  119. /// </summary>
  120. [SugarColumn(ColumnDescription = "验证属性", Length = 255, ColumnName = "validate_attribute")]
  121. public string? validateAttribute { get; set; }
  122. /// <summary>
  123. /// 主键
  124. /// </summary>
  125. [SugarColumn(ColumnDescription = "主键", ColumnName = "primary_key")]
  126. public bool primaryKey { get; set; }
  127. /// <summary>
  128. /// 自动增长
  129. /// </summary>
  130. [SugarColumn(ColumnDescription = "自动增长", ColumnName = "auto_increment")]
  131. public bool autoIncrement { get; set; }
  132. /// <summary>
  133. /// 分表字段
  134. /// </summary>
  135. [SugarColumn(ColumnDescription = "分表字段", ColumnName = "split_flag")]
  136. public bool splitFlag { get; set; }
  137. /// <summary>
  138. /// 列表显示
  139. /// </summary>
  140. [SugarColumn(ColumnDescription = "列表显示", ColumnName = "show_list")]
  141. public bool showList { get; set; }
  142. /// <summary>
  143. /// 查询条件
  144. /// </summary>
  145. [SugarColumn(ColumnDescription = "查询条件", ColumnName = "show_query")]
  146. public bool showQuery { get; set; }
  147. /// <summary>
  148. /// 是否编辑
  149. /// </summary>
  150. [SugarColumn(ColumnDescription = "是否编辑", ColumnName = "show_edit")]
  151. public bool showEdit { get; set; }
  152. /// <summary>
  153. /// 检查重复
  154. /// </summary>
  155. [SugarColumn(ColumnDescription = "检查重复", ColumnName = "check_repeat")]
  156. public bool checkRepeat { get; set; }
  157. /// <summary>
  158. /// 导出标记
  159. /// </summary>
  160. [SugarColumn(ColumnDescription = "导出标记", ColumnName = "export_flag")]
  161. public bool exportFlag { get; set; }
  162. /// <summary>
  163. /// 导入标记
  164. /// </summary>
  165. [SugarColumn(ColumnDescription = "导入标记", ColumnName = "import_flag")]
  166. public bool importFlag { get; set; }
  167. /// <summary>
  168. /// 列表编辑
  169. /// </summary>
  170. [SugarColumn(ColumnDescription = "列表编辑", ColumnName = "list_edit_flag")]
  171. public bool listEditFlag { get; set; }
  172. /// <summary>
  173. /// 列表编辑提示文字
  174. /// </summary>
  175. [SugarColumn(ColumnDescription = "列表编辑提示文字", Length = 50, ColumnName = "list_edit_placeholder")]
  176. public string? listEditPlaceholder { get; set; }
  177. /// <summary>
  178. /// 统计条件字段
  179. /// </summary>
  180. [SugarColumn(ColumnDescription = "统计条件字段", ColumnName = "stat_condition")]
  181. public bool statCondition { get; set; }
  182. /// <summary>
  183. /// 统计数据字段
  184. /// </summary>
  185. [SugarColumn(ColumnDescription = "统计数据字段", ColumnName = "stat_data")]
  186. public bool statData { get; set; }
  187. /// <summary>
  188. /// 关联数据表
  189. /// </summary>
  190. [SugarColumn(ColumnDescription = "关联数据表", ColumnName = "link_table_id")]
  191. public int linkTableId { get; set; }
  192. /// <summary>
  193. /// 关联数据字段
  194. /// </summary>
  195. [SugarColumn(ColumnDescription = "关联数据字段", ColumnName = "link_field_id")]
  196. public int linkFieldId { get; set; }
  197. /// <summary>
  198. /// 关联数据源ID
  199. /// </summary>
  200. [SugarColumn(ColumnDescription = "关联数据源ID", ColumnName = "api_id")]
  201. public int apiId { get; set; }
  202. }
  203. }