Changes between Version 1 and Version 2 of P5


Ignore:
Timestamp:
04/07/26 19:24:48 (6 days ago)
Author:
211099
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • P5

    v1 v2  
    3838- FD14: {user_id, story_id} → collab_created_at
    3939- FD15:{list_id, story_id} → added_at   -> /
     40
     41=== Closures
     42user_id+ = {user_id, username, email, user_name, surname, password,
     43            user_created_at, user_updated_at}
     44→ Does NOT contain all attributes of R
     45
     46username+ = {username, user_id, email, user_name, surname, password,
     47             user_created_at, user_updated_at}
     48→ Does NOT contain all attributes of R
     49
     50email+ = {email, user_id, username, user_name, surname, password,
     51          user_created_at, user_updated_at}
     52→ Does NOT contain all attributes of R
     53
     54story_id+ = {story_id, mature_content, short_description, image,
     55             story_content, user_id, story_created_at, story_updated_at,
     56             username, email, user_name, surname, password,
     57             user_created_at, user_updated_at}
     58→ Does NOT contain all attributes of R
     59
     60chapter_id+ = {chapter_id, chapter_number, chapter_name, title,
     61               chapter_content, word_count, rating, published_at,
     62               view_count, story_id, chapter_created_at, chapter_updated_at,
     63               mature_content, short_description, image, story_content,
     64               user_id, story_created_at, story_updated_at, username,
     65               email, user_name, surname, password,
     66               user_created_at, user_updated_at}
     67→ Does NOT contain all attributes of R
     68
     69{story_id, chapter_number}+ = {story_id, chapter_number, chapter_id,
     70               chapter_name, title, chapter_content, word_count, rating,
     71               published_at, view_count, chapter_created_at, chapter_updated_at,
     72               mature_content, short_description, image, story_content,
     73               user_id, story_created_at, story_updated_at, username,
     74               email, user_name, surname, password,
     75               user_created_at, user_updated_at}
     76→ Does NOT contain all attributes of R
     77
     78genre_id+ = {genre_id, genre_name}
     79→ Does NOT contain all attributes of R
     80
     81genre_name+ = {genre_name, genre_id}
     82→ Does NOT contain all attributes of R
     83
     84list_id+ = {list_id, list_name, list_content, is_public, user_id,
     85            list_created_at, list_updated_at, username, email,
     86            user_name, surname, password, user_created_at, user_updated_at}
     87→ Does NOT contain all attributes of R
     88
     89notification_id+ = {notification_id, notification_content, is_read,
     90                    recipient_user_id, type, link, notification_created_at}
     91→ Does NOT contain all attributes of R
     92
     93suggestion_id+ = {suggestion_id, original_text, suggested_text, accepted,
     94                  suggestion_created_at, applied_at, story_id,
     95                  mature_content, short_description, image, story_content,
     96                  user_id, story_created_at, story_updated_at, username,
     97                  email, user_name, surname, password,
     98                  user_created_at, user_updated_at}
     99→ Does NOT contain all attributes of R
     100
     101comment_id+ = {comment_id, comment_content, user_id, story_id,
     102               comment_created_at, comment_updated_at,
     103               mature_content, short_description, image, story_content,
     104               story_created_at, story_updated_at, username, email,
     105               user_name, surname, password, user_created_at, user_updated_at}
     106→ Does NOT contain all attributes of R
     107
     108{user_id, story_id}+ = {user_id, story_id, like_created_at, collab_created_at,
     109                         mature_content, short_description, image, story_content,
     110                         story_created_at, story_updated_at, username, email,
     111                         user_name, surname, password,
     112                         user_created_at, user_updated_at}
     113→ Does NOT contain all attributes of R
     114
     115{list_id, story_id}+ = {list_id, story_id, added_at, list_name, list_content,
     116                         is_public, list_created_at, list_updated_at,
     117                         mature_content, short_description, image, story_content,
     118                         user_id, story_created_at, story_updated_at, username,
     119                         email, user_name, surname, password,
     120                         user_created_at, user_updated_at}
     121→ Does NOT contain all attributes of R