Changes between Version 1 and Version 2 of View4


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

--

Legend:

Unmodified
Added
Removed
Modified

  • View4

    v1 v2  
    5353==== Logic explanation
    5454**1.** The `employees` table identifies personnel who are employees.
     55
    5556**2.** The `personal` table provides their personal information.
     57
    5658**3.** The `works_in_store` relationship identifies the store where each employee works.
     59
    5760**4.** The `store` table provides the store name and identifier.
     61
    5862**5.** The `worked` relationship provides working hours, weekly totals, wage, and payment method.
     63
    5964**6.** LEFT JOIN is used for `worked` so that an employee can still appear even if no work-report record has yet been entered.
    6065