Changes between Version 7 and Version 8 of UseCase002

Timestamp:

05/21/26 18:14:31 (6 days ago)

Author:

232012

Comment:

--

UseCase002

@@ -17 +17 @@
 {{{
 SELECT user_id, email, password 
-FROM User 
+FROM USERS 
 WHERE email = 'user@example.com';
 }}}
@@ -27 +27 @@
 {{{
 SELECT user_id, points_collected 
-FROM Consumer 
-WHERE user_id = @authenticated_user_id;
+FROM CONSUMERS 
+WHERE user_id = :authenticated_user_id;
 
 SELECT user_id, type, discount_percentage 
-FROM Admin 
-WHERE user_id = @authenticated_user_id;
+FROM ADMINS 
+WHERE user_id = :authenticated_user_id;
 }}}
 }}}
 
-
 4. System grants access and redirects the user to the appropriate dashboard based on the results.
 }}}