Changes between Version 5 and Version 6 of UseCase001
- Timestamp:
- 05/12/26 23:37:17 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCase001
v5 v6 10 10 11 11 {{{#!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.12 1. User provides their required registration details, including a {{{email}}}, {{{password}}} and {{{username}}}, and submits the registration form. 13 13 14 **2.**System validates that the {{{email}}} is unique and that all required fields meet the necessary formatting standards.14 2. System validates that the {{{email}}} is unique and that all required fields meet the necessary formatting standards. 15 15 16 16 {{{#!div style="margin-left: 20px;" … … 22 22 }}} 23 23 24 **3.**System creates a new entry in the {{{User}}} table with a unique {{{user_id}}} and the current {{{date_created}}}.24 3. System creates a new entry in the {{{User}}} table with a unique {{{user_id}}} and the current {{{date_created}}}. 25 25 26 {{{#!div style="margin-left: 20px;" 26 27 {{{ 27 28 INSERT INTO User (email, password, username, date_created) 28 29 VALUES ('user@example.com', 'hashed_password', 'NewUser', CURRENT_TIMESTAMP); 29 30 }}} 31 }}} 30 32 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}}}.33 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}}}. 32 34 35 {{{#!div style="margin-left: 20px;" 33 36 {{{ 34 37 INSERT INTO Consumer (user_id, points_collected) 35 38 VALUES (LAST_INSERT_ID(), 0); 36 39 }}} 40 }}} 37 41 38 **5.**System confirms the successful account creation and automatically logs the user in.42 5. System confirms the successful account creation and automatically logs the user in. 39 43 }}}
