Index: db-scripts/ddl.sql
===================================================================
--- db-scripts/ddl.sql	(revision 89156c1feb4b06a2d4ecb2bbac89f7c39f0df7e2)
+++ db-scripts/ddl.sql	(revision e9a0543bbb622a2b343d1f5fe3b2df7ddb6a0bd3)
@@ -55,8 +55,8 @@
     user_id BIGINT PRIMARY KEY
         REFERENCES USERS(user_id) ON DELETE CASCADE,
-    weight NUMERIC,
-    height NUMERIC,
-    goal_weight NUMERIC,
-    goal_calories NUMERIC
+    weight NUMERIC NOT NULL,
+    height NUMERIC NOT NULL,
+    goal_weight NUMERIC NOT NULL,
+    goal_calories NUMERIC NOT NULL
 );
 
@@ -65,6 +65,8 @@
     user_id BIGINT
         REFERENCES WEIGHT_USERS(user_id) ON DELETE CASCADE,
-    calories NUMERIC,
-    date DATE
+    calories NUMERIC NOT NULL,
+    date DATE NOT NULL,
+
+    CONSTRAINT daily_intakes_unique_user_date UNIQUE (user_id, date)
 );