Changes between Version 2 and Version 3 of ddlScript.sql

Timestamp:

03/25/26 11:37:19 (3 weeks ago)

Author:

211099

Comment:

--

ddlScript.sql

@@ -124 +124 @@
     content TEXT NOT NULL,
     is_read BOOLEAN DEFAULT FALSE,
-    created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP
+    recipient_user_id INTEGER,
+    type VARCHAR(50),
+    link VARCHAR(500),
+    created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
+    FOREIGN KEY (recipient_user_id) REFERENCES USERS(user_id)
+        ON DELETE SET NULL
+        ON UPDATE CASCADE
 );