123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107 |
- package com.yihu.quota.model.source;
- import org.hibernate.annotations.Formula;
- import javax.persistence.*;
- /**
- * Created by wxw on 2018/9/10.
- *
- * @author wxw.
- */
- @Entity
- @Table(name = "olap_data_sources_table_field")
- public class DataSourcesTableField {
- private Integer id;
- /**
- * 表名Id
- */
- private Integer tableId;
- /**
- * 字段名
- */
- private String fieldName;
- /**
- * 字段编码
- */
- private String fieldCode;
- /**
- * 字段类型
- */
- private String fieldType;
- /**
- * 备注
- */
- private String note;
- /**
- * 临时字段,字段所在表的名称
- */
- private String tableName;
- @Id
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- @Column(name = "id", unique = true, nullable = false)
- public Integer getId() {
- return id;
- }
- public void setId(Integer id) {
- this.id = id;
- }
- @Column(name = "table_id")
- public Integer getTableId() {
- return tableId;
- }
- public void setTableId(Integer tableId) {
- this.tableId = tableId;
- }
- @Column(name = "field_name")
- public String getFieldName() {
- return fieldName;
- }
- public void setFieldName(String fieldName) {
- this.fieldName = fieldName;
- }
- @Column(name = "field_code")
- public String getFieldCode() {
- return fieldCode;
- }
- public void setFieldCode(String fieldCode) {
- this.fieldCode = fieldCode;
- }
- @Column(name = "field_type")
- public String getFieldType() {
- return fieldType;
- }
- public void setFieldType(String fieldType) {
- this.fieldType = fieldType;
- }
- public String getNote() {
- return note;
- }
- public void setNote(String note) {
- this.note = note;
- }
- @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)")
- public String getTableName() {
- return tableName;
- }
- public void setTableName(String tableName) {
- this.tableName = tableName;
- }
- }
|