Changes between Version 41 and Version 42 of DatabaseCreation

Timestamp:

05/09/26 16:53:40 (2 weeks ago)

Author:

231027

Comment:

--

DatabaseCreation

@@ -370 +370 @@
        u.username,
        t.ticket_id,
+       e.event_id,
+       e.name AS event_name,
        tp.purchase_id,
        tp.qr_code,
@@ -377 +379 @@
 JOIN "Ticket_Purchase" tp ON u.user_id = tp.user_id
 JOIN "Ticket" t ON tp.ticket_id = t.ticket_id
+JOIN "Event_Happening" eh ON t.event_happening_id = eh.event_happening_id
+JOIN "Event" e ON eh.event_id = e.event_id
 LEFT JOIN "Ticket_Refund" tr ON tp.purchase_id = tr.purchase_id;