Changes between Version 1 and Version 2 of UseCase0001


Ignore:
Timestamp:
03/16/26 20:42:16 (5 days ago)
Author:
221511
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase0001

    v1 v2  
    5656WHERE r.resource_id = 5;
    5757}}}
    58 
     58 The system also retrieves upcoming reservations for this resource:
    5959{{{
    6060SELECT res.reservation_id, res.start_time, res.end_time,
     
    7777       OR EXTRACT(ISODOW FROM DATE '2026-02-20') <= 5);
    7878}}}
    79 
     79 Then the system checks for conflicting reservations at that time:
    8080{{{
    8181SELECT COUNT(*) AS conflict_count