Changes between Version 12 and Version 13 of RelationalDesign

Timestamp:

05/26/26 04:16:39 (2 days ago)

Author:

232012

Comment:

--

RelationalDesign

@@ -10 +10 @@
 {{{#!div style="text-align: justify; width: 100%;"
 
-1. USER (**__user_id__**, **username**, **email**, **password**, **date_created**, shipping_address, telephone_number)
+1. USERS (**__user_id__**, **username**, **email**, **password**, **date_created**, shipping_address, telephone_number)
 
-2. ADMIN (**__user_id*__**[USER], **type**, **discount_percentage**)
+2. ADMINS (**__user_id*__**[USER], **type**, **discount_percentage**)
 
-3. CONSUMER (**__user_id*__**[USER], **points_collected**)
+3. CONSUMERS (**__user_id*__**[USER], **points_collected**)
 
-4. WISHLIST (**__wishlist_id__**, **__user_id*__**[USER])
+4. WISHLISTS (**__wishlist_id__**, **__user_id*__**[USER])
 
-5. WISHLIST_ITEM (**__wishlist_id__**, **__product_id__**[PRODUCT], **added_at**)
+5. WISHLIST_ITEMS (**__wishlist_id__**, **__product_id__**[PRODUCT], **added_at**)
 
-6. PRODUCT (**__product_id__**, **__release_id*__**[RELEASE], **price**, **format**, **description**, **stock**)
+6. PRODUCTS (**__product_id__**, **__release_id*__**[RELEASE], **price**, **format**, **product_description**, **stock**)
 
-7. RELEASE (**__release_id__**, **title**, **release_date**, **genre**, **cover_photo**, record_label)
+7. RELEASES (**__release_id__**, **title**, **release_date**, **genre**, **cover_photo**, record_label)
 
-8. ALBUM (**__release_id*__**[RELEASE])
+8. ALBUMS (**__release_id*__**[RELEASE])
 
-9. SINGLE (**__release_id*__**[RELEASE], **duration**)
+9. SINGLE_RELEASES (**__release_id*__**[RELEASE], **song_duration**)
 
-10. SONG (**__song_id__**, **song_name**, **duration**)
+10. SONGS (**__song_id__**, **song_name**, **duration**)
 
-11. ORDER (**__order_id__**, **__user_id*__**[USER], **purchase_date**, **status**, **payment_method**, **points_earned**, points_used)
+11. ORDERS (**__order_id__**, **__user_id*__**[USER], **purchase_date**, **status**, **payment_method**, **points_earned**, **points_used**)
 
-12. ORDER_ITEM (**__order_id*__**[ORDER], **__product_id*__**[PRODUCT], **quantity**, **price_at_purchase**)
+12. ORDER_ITEMS (**__order_id*__**[ORDER], **__product_id*__**[PRODUCT], **quantity**, **price_at_purchase**)
 
-13. ARTIST (**__artist_id__**, **artist_name**, photo, description)
+13. ARTISTS (**__artist_id__**, **artist_name**, artist_photo, artist_description)
 
-14. MODIFICATION (**__modification_id__**, **__user_id*__**[ADMIN], **date_modified**, **type_of_modification**, discount)
+14. MODIFICATIONS (**__modification_id__**, **__user_id*__**[ADMIN], **date_modified**, **type_of_modification**, discount)
 
-15. MODIFICATION_PRODUCT (**__modification_id*__**[MODIFICATION], **__product_id*__**[PRODUCT])
+15. MODIFICATION_PRODUCTS (**__modification_id*__**[MODIFICATION], **__product_id*__**[PRODUCT])
 
-16. RELEASE_ARTIST (**__release_id*__**[RELEASE], **__artist_id*__**[ARTIST])
+16. RELEASE_ARTIST (**__release_id*__**[RELEASE], **__artist_id*__**[ARTIST], **release_ordinal**, **type**)
 
 17. ALBUM_SONG (**__album_id*__**[ALBUM], **__song_id*__**[SONG])
 
-18. SONG_ARTIST (**__song_id*__**[SONG], **__artist_id*__**[ARTIST])
+18. SONG_ARTIST (**__song_id*__**[SONG], **__artist_id*__**[ARTIST], song_ordinal)
 }}}