Changes between Version 13 and Version 14 of DatabaseCreation

Timestamp:

04/21/26 21:00:28 (11 days ago)

Author:

231027

Comment:

--

DatabaseCreation

@@ -319 +319 @@
 }}}
 
+
 == Погледи (Views)
+
+=== Performer Events View
+
+{{{
+
+CREATE VIEW PerformerEvents AS
+SELECT p.performer_id,
+       p.name AS performer_name,
+       e.event_id,
+       e.name AS event_title,
+       eh.event_time
+FROM "Performer" p
+JOIN "Event_Happening_Performer" ehp ON p.performer_id = ehp.performer_id
+JOIN "Event_Happening" eh ON ehp.event_happening_id = eh.event_happening_id
+JOIN "Event" e ON eh.event_id = e.event_id;
+
+}}}
+
+=== User Tickets View
+
+{{{
+
+CREATE VIEW UserTickets AS
+SELECT u.user_id,
+       u.username,
+       t.ticket_id,
+       tp.purchase_id,
+       tp.qr_code,
+       tr.refund_id,
+       tr.refund_time
+FROM "User" u
+JOIN "Ticket_Purchase" tp ON u.user_id = tp.user_id
+JOIN "Ticket" t ON tp.ticket_id = t.ticket_id
+LEFT JOIN "Ticket_Refund" tr ON tp.purchase_id = tr.purchase_id;
+
+}}}
+
+=== Venue Layout View
+
+{{{
+
+CREATE VIEW VenueLayout AS
+SELECT v.venue_id,
+       v.name AS venue_name,
+       s.section_id,
+       s.name AS section_name,
+       st.seat_id,
+       st.seat_number
+FROM "Venue" v
+JOIN "Section" s ON v.venue_id = s.venue_id
+JOIN "Seat" st ON s.section_id = st.section_id;
+
+}}}
+
+=== Event Reviews View
+
+{{{
+
+CREATE VIEW EventReviews AS
+SELECT eh.event_happening_id,
+       e.event_id,
+       e.name AS event_title,
+       u.user_id,
+       u.username AS reviewer_name,
+       ehr.rating_id,
+       ehr.rating,
+       ehr.comment
+FROM "Event" e
+JOIN "Event_Happening" eh ON e.event_id = eh.event_id
+JOIN "Event_Happening_Rating" ehr ON eh.event_happening_id = ehr.event_happening_id
+JOIN "User" u ON ehr.user_id = u.user_id;
+
+}}}