Changes between Version 18 and Version 19 of DatabaseCreation

Timestamp:

04/21/26 22:03:30 (11 days ago)

Author:

231027

Comment:

--

DatabaseCreation

@@ -322 +322 @@
 == Погледи (Views)
 
-=== `PerformerEvents`
-
-{{{
-
-CREATE VIEW PerformerEvents AS
+=== `Performer_Events`
+
+{{{
+
+CREATE VIEW "Performer_Events" AS
 SELECT p.performer_id,
        p.name AS performer_name,
        e.event_id,
-       e.name AS event_title,
+       e.name AS event_name,
        eh.event_time
 FROM "Performer" p
@@ -339 +339 @@
 }}}
 
-=== `UserTickets`
-
-{{{
-
-CREATE VIEW UserTickets AS
+=== `User_Tickets`
+
+{{{
+
+CREATE VIEW "User_Tickets" AS
 SELECT u.user_id,
        u.username,
@@ -358 +358 @@
 }}}
 
-=== `VenueLayout`
-
-{{{
-
-CREATE VIEW VenueLayout AS
+=== `Venue_Layout`
+
+{{{
+
+CREATE VIEW "Venue_Layout" AS
 SELECT v.venue_id,
        v.name AS venue_name,
@@ -375 +375 @@
 }}}
 
-=== `EventReviews`
-
-{{{
-
-CREATE VIEW EventReviews AS
+=== `Event_Reviews`
+
+{{{
+
+CREATE VIEW "Event_Reviews" AS
 SELECT eh.event_happening_id,
        e.event_id,
-       e.name AS event_title,
+       e.name AS event_name,
        u.user_id,
-       u.username AS reviewer_name,
+       u.username,
        ehr.rating_id,
        ehr.rating,