Changes between Version 30 and Version 31 of konceptualenDizajnLogickiFizicki

Timestamp:

06/26/25 00:02:14 (4 months ago)

Author:

213209

Comment:

--

konceptualenDizajnLogickiFizicki

@@ -33 +33 @@
 [[Image(Validate preorder price trigger.txt)]]
 
+== Погледи(Views)
+
+{{{
+create or replace view v_reservation_details as
+select
+    r.reservationid,
+    u.first_name || ' ' || u.last_name as customer_name,
+    res.name as restaurant_name,
+    r.check_in_time,
+    r.check_out_time,
+    r.party_size,
+    r.status,
+    p.preordered_item_name,
+    p.quantity,
+    p.price_at_order
+from reservations r
+join app_user u on r.userid = u.user_id
+join restaurants res on r.restaurantid = res.restaurantid
+left join reservation_preordered_items p on r.reservationid = p.reservation_id;
+}}}
+
+{{{
+create or replace view v_menu_with_tags as
+select
+    m.menu_id,
+    m.item_name,
+    m.description,
+    m.menu_category,
+    m.price,
+    r.name as restaurant_name,
+    t.tag_name,
+    t.tag_value
+from menus m
+join restaurants r on m.restaurant_id = r.restaurantid
+left join menu_tags t on m.menu_id = t.menu_id;
+}}}
+
 == Релациски дијаграм изведен од DBeaver
 [[Image(finalDbeaverER.jpg​)]]