Changes between Version 2 and Version 3 of RelationalDesign
- Timestamp:
- 12/12/21 17:33:55 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v2 v3 11 11 12 12 * Users(__**user_id**__, **username**, **name**, **surname**, **email**, **password**) 13 * Movies(__**movie_id**__, **title**, **description**, image_url, airing_date, imbd_rating, ''user_id'' * (Persons))13 * Movies(__**movie_id**__, **title**, **description**, **image_url**, **airing_date**, imbd_rating, ''user_id'' * (Persons)) 14 14 * Genres(__**genre_id**__, **type**) 15 * Persons(__**person_id**__, **name**, **surname**, **type**, date_of_birth, image_url, description)15 * Persons(__**person_id**__, **name**, **surname**, **type**, **date_of_birth**, **image_url**, description) 16 16 * Movie_rates(**__''movie_id''__** * (Movies), **__''user_id''__** * (Users), **reason**, **stars_rated**) 17 17 * Movie_likes(**__''movie_id''__** * (Movies), **__''user_id''__** * (Users)) … … 19 19 * User_genres(**__''user_id''__** * (Users), **__''genre_id''__** * (Genres)) 20 20 * Movie_actors(**__''movie_id**__'' * (Movies), **__''person_id**__'' * (Persons)) 21 * User_ persons(**__''user_id**__'' * (Users), **__''person_id**__'' * (Persons), **reason**, **stars_rated**)21 * User_rates(**__''user_id**__'' * (Users), **__''person_id**__'' * (Persons), **reason**, **stars_rated**) 22 22 * Discussions(**__discussion_id**__ , **type**, **text**, **title**, **date**, **''user_id''** * (Users)) 23 23 * Movie_discussions(**__''discussion_id**__'' *( Discussions), **__''movie_id''__** * (Movies))