DataSourcesTableField.java 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107
  1. package com.yihu.quota.model.source;
  2. import org.hibernate.annotations.Formula;
  3. import javax.persistence.*;
  4. /**
  5. * Created by wxw on 2018/9/10.
  6. *
  7. * @author wxw.
  8. */
  9. @Entity
  10. @Table(name = "olap_data_sources_table_field")
  11. public class DataSourcesTableField {
  12. private Integer id;
  13. /**
  14. * 表名Id
  15. */
  16. private Integer tableId;
  17. /**
  18. * 字段名
  19. */
  20. private String fieldName;
  21. /**
  22. * 字段编码
  23. */
  24. private String fieldCode;
  25. /**
  26. * 字段类型
  27. */
  28. private String fieldType;
  29. /**
  30. * 备注
  31. */
  32. private String note;
  33. /**
  34. * 临时字段,字段所在表的名称
  35. */
  36. private String tableName;
  37. @Id
  38. @GeneratedValue(strategy = GenerationType.IDENTITY)
  39. @Column(name = "id", unique = true, nullable = false)
  40. public Integer getId() {
  41. return id;
  42. }
  43. public void setId(Integer id) {
  44. this.id = id;
  45. }
  46. @Column(name = "table_id")
  47. public Integer getTableId() {
  48. return tableId;
  49. }
  50. public void setTableId(Integer tableId) {
  51. this.tableId = tableId;
  52. }
  53. @Column(name = "field_name")
  54. public String getFieldName() {
  55. return fieldName;
  56. }
  57. public void setFieldName(String fieldName) {
  58. this.fieldName = fieldName;
  59. }
  60. @Column(name = "field_code")
  61. public String getFieldCode() {
  62. return fieldCode;
  63. }
  64. public void setFieldCode(String fieldCode) {
  65. this.fieldCode = fieldCode;
  66. }
  67. @Column(name = "field_type")
  68. public String getFieldType() {
  69. return fieldType;
  70. }
  71. public void setFieldType(String fieldType) {
  72. this.fieldType = fieldType;
  73. }
  74. public String getNote() {
  75. return note;
  76. }
  77. public void setNote(String note) {
  78. this.note = note;
  79. }
  80. @Formula("(SELECT tables.table_name FROM olap_data_sources_table_field filed Right JOIN olap_data_sources_table tables ON filed.table_id = tables.id WHERE filed.id = id)")
  81. public String getTableName() {
  82. return tableName;
  83. }
  84. public void setTableName(String tableName) {
  85. this.tableName = tableName;
  86. }
  87. }