Changes between Version 1 and Version 2 of RelationalModel

Timestamp:

04/18/26 20:33:46 (2 weeks ago)

Author:

231055

Comment:

--

RelationalModel

@@ -32 +32 @@
                         status_tip VARCHAR(255) NOT NULL,
                         status_text VARCHAR(255) NOT NULL
+
 );
 
@@ -219 +220 @@
                            FOREIGN KEY (status_id) REFERENCES Status(status_id) ON DELETE RESTRICT
 );
+CREATE TABLE Payment_methods(
+                                payment_method_id SERIAL PRIMARY KEY,
+                                payment_tip  VARCHAR(255) NOT NULL
+);
 
 CREATE TABLE Payments (
                           payment_id SERIAL PRIMARY KEY,
                           amount NUMERIC(10,2) NOT NULL,
-                          payment_method VARCHAR(255) NOT NULL,
+                          payment_method_id INT NOT NULL,
                           payment_time TIMESTAMP NOT NULL,
                           ride_id INT NOT NULL,
@@ -234 +239 @@
 
                           CONSTRAINT FK_Payments_Status
-                              FOREIGN KEY (status_id) REFERENCES Status(status_id) ON DELETE RESTRICT
-);
+                              FOREIGN KEY (status_id) REFERENCES Status(status_id) ON DELETE RESTRICT,
+
+                          CONSTRAINT FK_Payments_Method
+                              FOREIGN KEY (payment_method_id) REFERENCES Payment_methods(payment_method_id) ON DELETE RESTRICT
+);
+
 
 CREATE TABLE Ratings (
@@ -273 +282 @@
                                    FOREIGN KEY (ride_id) REFERENCES Rides(ride_id) ON DELETE CASCADE
 );
+CREATE TABLE Messages(
+                         message_id SERIAL PRIMARY KEY,
+                         message_text VARCHAR(255) NOT NULL
+
+);
 
 CREATE TABLE Notifications (
                                notification_id SERIAL PRIMARY KEY,
-                               type VARCHAR(255) NOT NULL,
-                               message VARCHAR(255) NOT NULL,
+                               message_id INT NOT NULL,
                                sent_time TIMESTAMP NOT NULL,
                                User_id INT NOT NULL,
-                               ride_id INT NOT NULL,
+                               ride_id INT,
                                status_id INT NOT NULL,
 
@@ -290 +303 @@
 
                                CONSTRAINT FK_Notifications_Status
-                                   FOREIGN KEY (status_id) REFERENCES Status(status_id) ON DELETE RESTRICT
-);
-#!sql
+                                   FOREIGN KEY (status_id) REFERENCES Status(status_id) ON DELETE RESTRICT,
+
+                               CONSTRAINT FK_Notifications_Messages
+                                    FOREIGN KEY (message_id) REFERENCES Messages(message_id) ON DELETE CASCADE
+);