Changes between Version 19 and Version 20 of DatabaseCreation

Timestamp:

04/22/26 16:47:28 (10 days ago)

Author:

231027

Comment:

--

DatabaseCreation

@@ -336 +336 @@
 JOIN "Event_Happening" eh ON ehp.event_happening_id = eh.event_happening_id
 JOIN "Event" e ON eh.event_id = e.event_id;
+
+}}}
+
+=== `Venue_Layout`
+
+{{{
+
+CREATE VIEW "Venue_Layout" 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;
 
 }}}
@@ -358 +375 @@
 }}}
 
-=== `Venue_Layout`
-
-{{{
-
-CREATE VIEW "Venue_Layout" 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`
-
-{{{
-
-CREATE VIEW "Event_Reviews" AS
+=== `Event_Ratings`
+
+{{{
+
+CREATE VIEW "Event_Ratings" AS
 SELECT eh.event_happening_id,
        e.event_id,