Changes between Version 1 and Version 2 of View5


Ignore:
Timestamp:
08/21/26 08:53:54 (25 hours ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • View5

    v1 v2  
    5252==== Logic explanation
    5353**1.** The `request` table provides the request details.
     54
    5455**2.** `make_request` connects each request with the client who submitted it.
     56
    5557**3.** `client` provides customer information.
     58
    5659**4.** `answers` connects requests with personnel members who answered them.
     60
    5761**5.** `personal` provides information about the employee.
     62
    5863**6.** LEFT JOIN is used for answers because a request may not have been answered yet.
    5964