Changes between Version 6 and Version 7 of RelationalDesign


Ignore:
Timestamp:
12/13/21 17:05:43 (3 years ago)
Author:
193113
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v6 v7  
    1212
    1313    * Users(__**user_id**__, [[span(style=color: #FF0000, **username**)]], **name**, **surname**, [[span(style=color: #FF0000, **email**)]], **password**)
    14     * Movies(__**movie_id**__, [[span(style=color: #FF0000, **title**)]], **description**, **image_url**, **airing_date**, imbd_rating, ''user_id'' (Persons))
     14    * Persons(__**person_id**__, **name**, **surname**, **type**, **date_of_birth**, **image_url**, **description**)
     15    * Movies(__**movie_id**__, [[span(style=color: #FF0000, **title**)]], **description**, **image_url**, **airing_date**, imbd_rating, ''director_id'' (Persons))
    1516    * Genres(__**genre_id**__, [[span(style=color: #FF0000, **type**)]])
    16     * Persons(__**person_id**__, **name**, **surname**, **type**, **date_of_birth**, **image_url**, **description**)
    1717    * Movie_rates(**__''movie_id''__** * (Movies), **__''user_id''__** * (Users), **reason**, **stars_rated**)
    1818    * Movie_likes(**__''movie_id''__** * (Movies), **__''user_id''__**  * (Users))
     
    2020    * User_genres(**__''user_id''__** * (Users), **__''genre_id''__** * (Genres))
    2121    * Movie_actors(**__''movie_id**__'' * (Movies), **__''person_id**__'' * (Persons))
    22     * User_rates(**__''user_id**__'' * (Users), **__''person_id**__'' * (Persons), **reason**, **stars_rated**)
     22    * Person_rates( **__''person_id**__'' * (Persons),**__''user_id**__'' * (Users), **reason**, **stars_rated**)
    2323    * Discussions(**__discussion_id**__ , **type**, **text**, **title**, **date**, **''user_id''** * (Users))
    2424    * Movie_discussions(**__''discussion_id**__'' *( Discussions), **__''movie_id''__** * (Movies))