--- a/flys-backend/src/main/java/de/intevation/flys/model/SQRelation.java	Wed Jun 13 06:22:04 2012 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/model/SQRelation.java	Wed Jun 13 08:12:00 2012 +0000
@@ -11,6 +11,7 @@
 import javax.persistence.Column;
 import javax.persistence.SequenceGenerator;
 import javax.persistence.OneToMany;
+import javax.persistence.OneToOne;
 import javax.persistence.JoinColumn;
 import javax.persistence.GenerationType;
 
@@ -21,6 +22,8 @@
 
     private Integer id;
 
+    private River river;
+
     private TimeInterval timeInterval;
 
     private String description;
@@ -28,6 +31,17 @@
     private List<SQRelationValue> values;
 
 
+    protected SQRelation() {
+    }
+
+
+    public SQRelation(River river, TimeInterval timeInterval, String desc) {
+        this.river        = river;
+        this.timeInterval = timeInterval;
+        this.description  = desc;
+    }
+
+
     @Id
     @SequenceGenerator(
         name           = "SEQUENCE_SQ_ID_SEQ",
@@ -46,6 +60,17 @@
     }
 
 
+    @OneToOne
+    @JoinColumn(name = "river_id")
+    public River getRiver() {
+        return river;
+    }
+
+    public void setRiver(River river) {
+        this.river = river;
+    }
+
+
     @Column(name = "description")
     public String getDescription() {
         return description;
@@ -56,7 +81,8 @@
     }
 
 
-    @Column(name = "time_interval")
+    @OneToOne
+    @JoinColumn(name = "time_interval_id")
     public TimeInterval getTimeInterval() {
         return timeInterval;
     }