Changes between Version 44 and Version 45 of DatabaseCreation
- Timestamp:
- 05/12/26 22:28:25 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseCreation
v44 v45 14 14 min_age INT NOT NULL 15 15 ); 16 17 }}} 18 19 {{{ 16 20 17 21 CREATE TABLE "Concert" ( … … 24 28 ON UPDATE CASCADE 25 29 ); 30 31 }}} 32 33 {{{ 26 34 27 35 CREATE TABLE "Play" ( … … 53 61 ); 54 62 63 }}} 64 65 {{{ 66 55 67 CREATE TABLE "Musical_Performer" ( 56 68 performer_id BIGINT PRIMARY KEY, … … 64 76 ); 65 77 78 }}} 79 80 {{{ 81 66 82 CREATE TABLE "Acting_Performer" ( 67 83 performer_id BIGINT PRIMARY KEY, … … 91 107 ); 92 108 109 }}} 110 111 {{{ 112 93 113 CREATE TABLE "Section" ( 94 114 section_id BIGSERIAL PRIMARY KEY, … … 102 122 CONSTRAINT uq_section_venue_name UNIQUE (venue_id, name) 103 123 ); 124 125 }}} 126 127 {{{ 104 128 105 129 CREATE TABLE "Seat" ( … … 127 151 CONSTRAINT organizer_contact_email_check CHECK (contact_email ~ '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$') 128 152 ); 153 154 }}} 155 156 {{{ 129 157 130 158 CREATE TABLE "Sponsor" ( … … 159 187 ); 160 188 189 }}} 190 191 {{{ 192 161 193 CREATE TABLE "Event_Period" ( 162 194 period_id BIGSERIAL PRIMARY KEY, … … 195 227 ); 196 228 229 }}} 230 231 {{{ 232 197 233 CREATE TABLE "Event_Happening_Organizer" ( 198 234 event_happening_id BIGINT NOT NULL, … … 207 243 ON UPDATE CASCADE 208 244 ); 245 246 }}} 247 248 {{{ 209 249 210 250 CREATE TABLE "Event_Happening_Sponsor" ( … … 248 288 ); 249 289 290 }}} 291 292 {{{ 293 250 294 CREATE TABLE "Event_Happening_Rating" ( 251 295 rating_id BIGSERIAL PRIMARY KEY, … … 289 333 ); 290 334 335 }}} 336 337 {{{ 338 291 339 CREATE TABLE "Ticket_Purchase" ( 292 340 purchase_id BIGSERIAL PRIMARY KEY, … … 304 352 ON UPDATE CASCADE 305 353 ); 354 355 }}} 356 357 {{{ 306 358 307 359 CREATE TABLE "Ticket_Refund" (
