Changeset c4c43f3 for db-scripts/ddl.sql

Timestamp:

04/20/26 19:04:21 (3 months ago)

Author:

Andrej <asumanovski@…>

Branches:

master

Children:

37307aa

Parents:

6fa5831

Message:

Normalization of the database

File:

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

db-scripts/ddl.sql

@@ -73 +73 @@
     training_user_id BIGINT
         REFERENCES TRAINING_USERS(user_id) ON DELETE CASCADE,
-    weight_user_id BIGINT
-        REFERENCES WEIGHT_USERS(user_id) ON DELETE CASCADE,
     duration NUMERIC,
     calories NUMERIC,
@@ -83 +81 @@
 CREATE TABLE DISCIPLINE_USERS (
     user_id BIGINT PRIMARY KEY
-        REFERENCES USERS(user_id) ON DELETE CASCADE,
-    num_tasks INTEGER,
-    tasks TEXT
+        REFERENCES USERS(user_id) ON DELETE CASCADE
 );
 
@@ -92 +88 @@
     user_id BIGINT
         REFERENCES USERS(user_id) ON DELETE CASCADE,
-    name TEXT NOT NULL,
-    num_tasks INTEGER,
-    tasks TEXT
+    name TEXT NOT NULL
 );