Changes between Version 2 and Version 3 of P5


Ignore:
Timestamp:
04/07/26 22:14:10 (8 days ago)
Author:
211099
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • P5

    v2 v3  
    4040
    4141=== Closures
    42 user_id+ = {user_id, username, email, user_name, surname, password,
    43             user_created_at, user_updated_at}
    44 → Does NOT contain all attributes of R
     42user_id+ = {user_id, username, email, user_name, surname, password,user_created_at, user_updated_at} → Does NOT contain all attributes of R
    4543
    46 username+ = {username, user_id, email, user_name, surname, password,
    47              user_created_at, user_updated_at}
    48 → Does NOT contain all attributes of R
     44username+ = {username, user_id, email, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R
    4945
    50 email+ = {email, user_id, username, user_name, surname, password,
    51           user_created_at, user_updated_at}
    52 → Does NOT contain all attributes of R
     46email+ = {email, user_id, username, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R
    5347
    54 story_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
     48story_id+ = {story_id, mature_content, short_description, image, story_content, user_id, story_created_at, story_updated_at, username, email, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R
    5949
    60 chapter_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
     50chapter_id+ = {chapter_id, chapter_number, chapter_name, title, chapter_content, word_count, rating, published_at, view_count, story_id, chapter_created_at, chapter_updated_at, mature_content, short_description, image, story_content, user_id, story_created_at, story_updated_at, username, email, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R
    6851
    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
     52{story_id, chapter_number}+ = {story_id, chapter_number, chapter_id, chapter_name, title, chapter_content, word_count, rating, published_at, view_count, chapter_created_at, chapter_updated_at, mature_content, short_description, image, story_content, user_id, story_created_at, story_updated_at, username, email, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R
    7753
    78 genre_id+ = {genre_id, genre_name}
    79 → Does NOT contain all attributes of R
     54genre_id+ = {genre_id, genre_name} → Does NOT contain all attributes of R
    8055
    81 genre_name+ = {genre_name, genre_id}
    82 → Does NOT contain all attributes of R
     56genre_name+ = {genre_name, genre_id} → Does NOT contain all attributes of R
    8357
    84 list_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
     58list_id+ = {list_id, list_name, list_content, is_public, user_id, list_created_at, list_updated_at, username, email, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R
    8859
    89 notification_id+ = {notification_id, notification_content, is_read,
    90                     recipient_user_id, type, link, notification_created_at}
    91 → Does NOT contain all attributes of R
     60notification_id+ = {notification_id, notification_content, is_read, recipient_user_id, type, link, notification_created_at} → Does NOT contain all attributes of R
    9261
    93 suggestion_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
     62suggestion_id+ = {suggestion_id, original_text, suggested_text, accepted, suggestion_created_at, applied_at, story_id,  mature_content, short_description, image, story_content, user_id, story_created_at, story_updated_at, username, email, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R
    10063
    101 comment_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
     64comment_id+ = {comment_id, comment_content, user_id, story_id, comment_created_at, comment_updated_at, mature_content, short_description, image, story_content, story_created_at, story_updated_at, username, email, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R
    10765
    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
     66{user_id, story_id}+ = {user_id, story_id, like_created_at, collab_created_at, mature_content, short_description, image, story_content, story_created_at, story_updated_at, username, email, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R
    11467
    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
     68{list_id, story_id}+ = {list_id, story_id, added_at, list_name, list_content, is_public, list_created_at, list_updated_at, mature_content, short_description, image, story_content,user_id, story_created_at, story_updated_at, username, email, user_name, surname, password, user_created_at, user_updated_at} → Does NOT contain all attributes of R