Changes between Version 3 and Version 4 of RelationalDesign

Timestamp:

05/19/26 01:40:49 (9 days ago)

Author:

232012

Comment:

--

RelationalDesign

@@ -12 +12 @@
 1. USER (**__user_id__**, **username**, **email**, **password**, **date_created**, shipping_address, telephone_number)
 
-2. ADMIN (**__user_id*__**[USER], discount_percentage, type)
+2. ADMIN (**__user_id*__**[USER], **type**, **discount_percentage**)
 
-3. CONSUMER (**__user_id*__**[USER], points_collected)
+3. CONSUMER (**__user_id*__**[USER], **points_collected**)
 
 4. WISHLIST (**__wishlist_id__**, **__user_id*__**[USER])
 
-5. PRODUCT (product_id, price, format, description, stock)
+5. PRODUCT (**__product_id__**, **price**, **format**, **description**, **stock**)
 
-6. RELEASE (release_id, product_id*[PRODUCT]?????, title, release_date, genre, record_label, cover_photo)
+6. RELEASE (**__release_id__**, **title**, **release_date**, **genre**, **cover_photo**, record_label)
 
-7. ALBUM (release_id*[RELEASE])
+7. ALBUM (**__release_id*__**[RELEASE])
 
-8. SINGLE (release_id*[RELEASE], duration)
+8. SINGLE (**__release_id*__**[RELEASE], **duration**)
 
-9. SONG (song_id, song_name, duration)
+9. SONG (**__song_id__**, **song_name**, **duration**)
 
-10. ORDER (order_id, user_id*[USER], purchase_date, status, payment_method, points_used, points_earned)
+10. ORDER (**__order_id__**, **__user_id*__**[USER], **purchase_date**, **status**, **payment_method**, **points_earned**, points_used)
 
-11. ORDER_ITEM (order_id*[ORDER], product_id*[PRODUCT], quantity, price_at_purchase)
+11. ORDER_ITEM (**__order_id*__**[ORDER], **__product_id*__**[PRODUCT], **quantity**, **price_at_purchase**)
 
-12. ARTIST (artist_id, artist_name, photo, description)
+12. ARTIST (**__artist_id__**, **artist_name**, photo, description)
 
-13. MODIFICATION (modification_id, user_id*[ADMIN], date_modified, discount)
+13. MODIFICATION (**__modification_id__**, **__user_id*__**[ADMIN], **date_modified**, **type_of_modification**, discount)
 }}}