Changes between Version 1 and Version 2 of VenueCapacity

Timestamp:

05/27/26 23:53:59 (5 hours ago)

Author:

193284

Comment:

--

VenueCapacity

@@ -450 +450 @@
 )
 VALUES (
-    'Марко',
+    'Александар',
     'Стојановски',
-    'marko.s@email.com',
-    '070-123-456'
+    'aleksandar@email.com',
+    '070-111-222'
 );
 
@@ -478 +478 @@
 VALUES (
     'Golden Palace',
-    'Centar',
-    'Skopje',
-    'Ilindenska 15',
+    'Центар',
+    'Скопје',
+    'Булевар Македонија 15',
     150,
     55.00,
     1
 );
+
+INSERT INTO venue_booking (
+    date,
+    start_time,
+    end_time,
+    status,
+    price,
+    venue_id,
+    wedding_id
+)
+VALUES (
+    '2024-07-20',
+    '18:00:00',
+    '23:59:00',
+    'CONFIRMED',
+    4500.00,
+    2,
+    2
+);
+
+INSERT INTO event (
+    event_type,
+    date,
+    start_time,
+    end_time,
+    status,
+    wedding_id
+)
+VALUES (
+    'Reception',
+    '2024-07-20',
+    '18:00:00',
+    '23:00:00',
+    'SCHEDULED',
+    2
+);
+
+INSERT INTO guest (
+    first_name,
+    last_name,
+    email,
+    wedding_id
+)
+VALUES
+(
+    'James',
+    'Peterson',
+    'james@email.com',
+    2
+),
+(
+    'Elizabeth',
+    'Martinez',
+    'elizabeth@email.com',
+    2
+),
+(
+    'Robert',
+    'Davis',
+    'robert@email.com',
+    2
+);
+
+INSERT INTO attendance (
+    status,
+    table_number,
+    role,
+    guest_id,
+    event_id
+)
+VALUES
+(
+    'CONFIRMED',
+    1,
+    'Guest',
+    1,
+    1
+),
+(
+    'CONFIRMED',
+    1,
+    'Guest',
+    2,
+    1
+),
+(
+    'CONFIRMED',
+    2,
+    'Guest',
+    3,
+    1
+),
+(
+    'ATTENDED',
+    1,
+    'Guest',
+    1,
+    1
+),
+(
+    'ATTENDED',
+    1,
+    'Guest',
+    2,
+    1
+),
+(
+    'ATTENDED',
+    2,
+    'Guest',
+    3,
+    1
+);
 }}}
 
@@ -490 +603 @@
 
 {{{
- venue_id | venue_name    | venue_capacity
-----------+---------------+----------------
- 2        | Golden Palace | 150
+ venue_id | venue_name    | venue_capacity | wedding_id | organizer_name         | wedding_date | confirmed_attendees | actual_attendance | available_seats | occupancy_rate_percent | utilization_category | booking_status | booking_date
+----------+---------------+----------------+------------+------------------------+--------------+---------------------+-------------------+-----------------+------------------------+---------------------+----------------+--------------
+ 2        | Golden Palace | 150            | 2          | Александар Стојановски | 2024-07-20   | 3                   | 3                 | 147             | 2.00                   | LOW                 | CONFIRMED      | 2024-07-20
 }}}
 
@@ -498 +611 @@
 
 * Confirmed Attendees:
-  * guests marked as CONFIRMED
+  * 3 guests with CONFIRMED attendance status
 
 * Actual Attendance:
-  * guests marked as ATTENDED
+  * 3 guests with ATTENDED status
 
 * Available Seats:
-  * venue capacity minus confirmed attendees
+  * 150 - 3 = 147
 
 * Occupancy Rate:
-  * percentage of occupied seats
+  * (3 / 150) × 100 = 2.00%
 
 * Utilization Category:
-  * calculated based on occupancy thresholds
+  * occupancy below 60% → LOW
+
+* Operational Insight:
+  * the venue has very low occupancy utilization and significant unused capacity
 
 == Summary ==