Changeset 708af9e for db-scripts/ddl.sql

Timestamp:

04/27/26 22:01:12 (2 months ago)

Author:

Andrej <asumanovski@…>

Branches:

master

Children:

8449b9c

Parents:

89156c1

Message:

Weight tracking feature complete

File:

• db-scripts/ddl.sql (modified) (2 diffs)

db-scripts/ddl.sql

@@ -55 +55 @@
     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 +65 @@
     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)
 );