Changes between Version 3 and Version 4 of RelationalModel
- Timestamp:
- 04/18/26 21:54:34 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalModel
v3 v4 34 34 35 35 ); 36 37 36 CREATE TABLE Vehicles_model ( 38 37 Vehicles_model_id SERIAL PRIMARY KEY, 39 38 Model VARCHAR(255) NOT NULL 40 39 ); 41 42 40 CREATE TABLE Locations ( 43 41 location_id SERIAL PRIMARY KEY, … … 50 48 created_at TIMESTAMP NOT NULL 51 49 ); 52 53 50 CREATE TABLE Users ( 54 51 User_id SERIAL PRIMARY KEY, … … 69 66 ON UPDATE CASCADE 70 67 ); 71 72 68 CREATE TABLE Drivers ( 73 69 driver_id SERIAL PRIMARY KEY, … … 87 83 ON UPDATE CASCADE 88 84 ); 89 90 85 CREATE TABLE Admins ( 91 86 admins_id SERIAL PRIMARY KEY, … … 106 101 ON UPDATE CASCADE 107 102 ); 108 109 103 CREATE TABLE Vehicle_types ( 110 104 vehicle_type_id SERIAL PRIMARY KEY, … … 119 113 ON UPDATE CASCADE 120 114 ); 121 122 115 CREATE TABLE Vehicle_ownership ( 123 116 Vehicle_ownership_id SERIAL PRIMARY KEY, … … 136 129 ON UPDATE CASCADE 137 130 ); 138 139 131 CREATE TABLE Pricing_rules ( 140 132 tariff_id SERIAL PRIMARY KEY, … … 151 143 ON UPDATE CASCADE 152 144 ); 153 154 145 CREATE TABLE Drivers_Vehicle_ownership ( 155 146 driver_id INT NOT NULL, … … 168 159 ON DELETE CASCADE 169 160 ); 170 171 161 CREATE TABLE Active_drivers ( 172 162 driver_id INT PRIMARY KEY, … … 186 176 ON DELETE RESTRICT 187 177 ); 188 189 178 CREATE TABLE Rides ( 190 179 ride_id SERIAL PRIMARY KEY, … … 224 213 payment_tip VARCHAR(255) NOT NULL 225 214 ); 226 227 215 CREATE TABLE Payments ( 228 216 payment_id SERIAL PRIMARY KEY, … … 244 232 FOREIGN KEY (payment_method_id) REFERENCES Payment_methods(payment_method_id) ON DELETE RESTRICT 245 233 ); 246 247 248 234 CREATE TABLE Ratings ( 249 235 rating_id SERIAL PRIMARY KEY, … … 266 252 FOREIGN KEY (driver_id) REFERENCES Drivers(driver_id) ON DELETE CASCADE 267 253 ); 268 269 254 CREATE TABLE Cancellations ( 270 255 cancellation_id SERIAL PRIMARY KEY, … … 287 272 288 273 ); 289 290 274 CREATE TABLE Notifications ( 291 275 notification_id SERIAL PRIMARY KEY, … … 308 292 FOREIGN KEY (message_id) REFERENCES Messages(message_id) ON DELETE CASCADE 309 293 ); 294 295
