Index: db-scripts/ddl.sql
===================================================================
--- db-scripts/ddl.sql	(revision 37307aadda57d1e5b86180b9b2b8a6318ec36095)
+++ db-scripts/ddl.sql	(revision 708af9efba48db0445f07728b5d091a3d8898876)
@@ -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)
 );