yhlxj/netflix-dao/src/main/java/com/cyksj/model/dto/QuestionnaireFieldsView.java

package com.cyksj.model.dto;

import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Getter;
import lombok.Setter;

/*
 *项目名: netflix
 *文件名: QuestionnaireFieldsView
 *创建者: JavaZou
 *创建时间:2023/6/12 16:23
 */
@Getter
@Setter
@SearchBean(tables = "form_template ft left join form_fields ff on ff.template_id = ft.id" +
		" left join form_fields_default fd on fd.fields_id = ff.id :promotion_id:",
		where = "ff.deleted is true and ft.deleted is true")
public class QuestionnaireFieldsView {
	@DbField("ff.id")
	private Long id;

	@DbField("fd.fields_name")
	private String fieldsName;

	@DbField("ff.data_type")
	private Integer dataType;

	@DbField("ff.fields_entry_type")
	private Integer FieldsEntryType;

	@DbField("ff.show_table")
	private Integer showTable;

	@DbField("ff.sorted")
	private Integer sorted;

	@DbField("ff.template_id")
	private Long templateId;

	@DbField("ft.name")
	private String templateName;

	@DbField("ft.desc_str")
	private String descStr;

	@DbField("fd.promotion_id")
	private Long promotionId;

	@DbField("fd.value")
	private String value;
}