Changes between Version 4 and Version 5 of UseCase002

Timestamp:

05/12/26 23:55:11 (2 weeks ago)

Author:

232012

Comment:

--

UseCase002

@@ -14 +14 @@
 2. System retrieves the user record from the database to verify the credentials and determine the user's role.
 
-3. System checks the {{{Admin}}} and {{{Consumer}}} tables to identify the specific permissions and attributes associated with that {{{user_id}}}.
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT user_id, email, password 
+FROM User 
+WHERE email = 'user@example.com';
+}}}
+}}}
+
+3. System checks the Admin and Consumer tables to identify the specific permissions and attributes associated with that user_id.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT user_id, points_collected 
+FROM Consumer 
+WHERE user_id = @authenticated_user_id;
+
+SELECT user_id, admin_level 
+FROM Admin 
+WHERE user_id = @authenticated_user_id;
+}}}
+}}}
+
 
 4. System grants access and redirects the user to the appropriate dashboard based on the results.