Changes between Version 5 and Version 6 of UseCase001


Ignore:
Timestamp:
05/12/26 23:37:17 (2 weeks ago)
Author:
232012
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase001

    v5 v6  
    1010
    1111{{{#!div style="text-align: justify; width: 100%;"
    12 **1.** User provides their required registration details, including a {{{email}}}, {{{password}}} and {{{username}}}, and submits the registration form.
     121. User provides their required registration details, including a {{{email}}}, {{{password}}} and {{{username}}}, and submits the registration form.
    1313
    14 **2.** System validates that the {{{email}}} is unique and that all required fields meet the necessary formatting standards.
     142. System validates that the {{{email}}} is unique and that all required fields meet the necessary formatting standards.
    1515
    1616{{{#!div style="margin-left: 20px;"
     
    2222}}}
    2323
    24 **3.** System creates a new entry in the {{{User}}} table with a unique {{{user_id}}} and the current {{{date_created}}}.
     243. System creates a new entry in the {{{User}}} table with a unique {{{user_id}}} and the current {{{date_created}}}.
    2525
     26{{{#!div style="margin-left: 20px;"
    2627{{{
    2728INSERT INTO User (email, password, username, date_created)
    2829VALUES ('user@example.com', 'hashed_password', 'NewUser', CURRENT_TIMESTAMP);
    2930}}}
     31}}}
    3032
    31 **4.** System initializes a corresponding entry in the {{{Consumer table}}}, setting the {{{points_collected}}} to zero and establishing the one-to-one relationship with the new {{{user_id}}}.
     334. System initializes a corresponding entry in the {{{Consumer table}}}, setting the {{{points_collected}}} to zero and establishing the one-to-one relationship with the new {{{user_id}}}.
    3234
     35{{{#!div style="margin-left: 20px;"
    3336{{{
    3437INSERT INTO Consumer (user_id, points_collected)
    3538VALUES (LAST_INSERT_ID(), 0);
    3639}}}
     40}}}
    3741
    38 **5.** System confirms the successful account creation and automatically logs the user in.
     425. System confirms the successful account creation and automatically logs the user in.
    3943}}}