--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/main/java/de/intevation/lada/model/stammdaten/Query.java	Fri Jul 08 15:32:36 2016 +0200
@@ -0,0 +1,167 @@
+package de.intevation.lada.model.stammdaten;
+
+import java.io.Serializable;
+import java.util.List;
+
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.FetchType;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+import javax.persistence.OneToMany;
+import javax.persistence.OrderBy;
+import javax.persistence.Transient;
+
+import com.fasterxml.jackson.annotation.JsonIgnore;
+
+
+/**
+ * The persistent class for the query database table.
+ * 
+ */
+@Entity
+public class Query implements Serializable {
+    private static final long serialVersionUID = 1L;
+
+    @Id
+    private Integer id;
+
+    private String description;
+
+    private String name;
+
+    private String sql;
+
+    @ManyToOne
+    @JoinColumn(name="type", insertable=false, updatable=false)
+    private QueryType type;
+
+    @Column(name="type")
+    private Integer typeId;
+
+    @Transient
+    private Boolean favorite;
+
+    //bi-directional many-to-one association to Filter
+    @OneToMany(fetch=FetchType.EAGER, mappedBy="query")
+    private List<Filter> filters;
+
+    //bi-directional many-to-one association to Result
+    @OneToMany(fetch=FetchType.EAGER, mappedBy="query")
+    @OrderBy("index")
+    private List<Result> results;
+
+    public Query() {
+    }
+
+    public Integer getId() {
+        return this.id;
+    }
+
+    public void setId(Integer id) {
+        this.id = id;
+    }
+
+    public String getDescription() {
+        return this.description;
+    }
+
+    public void setDescription(String description) {
+        this.description = description;
+    }
+
+    public String getName() {
+        return this.name;
+    }
+
+    public void setName(String name) {
+        this.name = name;
+    }
+
+    public String getSql() {
+        return this.sql;
+    }
+
+    public void setSql(String sql) {
+        this.sql = sql;
+    }
+
+    public String getType() {
+        return this.type.getType();
+    }
+
+    /**
+     * @return the typeId
+     */
+    @JsonIgnore
+    public Integer getTypeId() {
+        return typeId;
+    }
+
+    /**
+     * @param typeId the typeId to set
+     */
+    @JsonIgnore
+    public void setTypeId(Integer typeId) {
+        this.typeId = typeId;
+    }
+
+    /**
+     * @return the favorite
+     */
+    public Boolean getFavorite() {
+        return favorite;
+    }
+
+    /**
+     * @param favorite the favorite to set
+     */
+    public void setFavorite(Boolean favorite) {
+        this.favorite = favorite;
+    }
+
+    public List<Filter> getFilters() {
+        return this.filters;
+    }
+
+    public void setFilters(List<Filter> filters) {
+        this.filters = filters;
+    }
+
+    public Filter addFilter(Filter filter) {
+        getFilters().add(filter);
+        filter.setQuery(this);
+
+        return filter;
+    }
+
+    public Filter removeFilter(Filter filter) {
+        getFilters().remove(filter);
+        filter.setQuery(null);
+
+        return filter;
+    }
+
+    public List<Result> getResults() {
+        return this.results;
+    }
+
+    public void setResults(List<Result> results) {
+        this.results = results;
+    }
+
+    public Result addResult(Result result) {
+        getResults().add(result);
+        result.setQuery(this);
+
+        return result;
+    }
+
+    public Result removeResult(Result result) {
+        getResults().remove(result);
+        result.setQuery(null);
+
+        return result;
+    }
+}