Users
id | username | password | graphic_design_tool | web_design_tool | access |
1 | User1 | password1 | Adobe Illustrator | Sublime Text | Subscription |
2 | User2 | password2 | CorelDRAW | Visual Studio Code | Free |
3 | User3 | password3 | Affinity Designer | Brackets | Premium |
4 | User4 | password4 | Xara Designer Pro | Atom | Standard |
5 | User5 | password5 | Sketch | WebStorm | Free |
Movies
id | title | genre | release_year | rating | user_id |
| | | | | (→ Users.id) |
1 | Movie1 | Action | 2020 | 8.5 | 1 |
2 | Movie2 | Comedy | 2019 | 7.6 | 2 |
3 | Movie3 | Drama | 2018 | 8.2 | 3 |
4 | Movie4 | Horror | 2021 | 7.8 | 4 |
5 | Movie5 | Thriller | 2017 | 8.0 | 5 |
Ratings
id | movie_id | user_id | score |
| (→ Movies.id) | (→ Users.id) | |
1 | 1 | 1 | 9.0 |
2 | 2 | 2 | 8.0 |
3 | 3 | 3 | 8.5 |
4 | 4 | 4 | 8.3 |
5 | 5 | 5 | 7.5 |
Genres
id | name |
1 | Action |
2 | Comedy |
3 | Drama |
4 | Horror |
5 | Thriller |
AccessLevels
level_name | price | description |
Basic | 4.99 | Limited features |
Premium | 9.99 | Full features |
Standard | 6.99 | Moderate features |
Free | 0.0 | No cost |
Platinum | 14.99 | Advanced features |
Subscriptions
user_id | access_level_id | start_date | end_date |
(→ Users.id) | (→ AccessLevels.id) | | |
1 | 1 | 2022-01-01 | 2022-12-31 |
2 | 2 | 2021-01-01 | 2021-12-31 |
3 | 3 | 2020-01-01 | 2020-12-31 |
4 | 4 | 2019-01-01 | 2019-12-31 |
5 | 5 | 2018-01-01 | 2018-12-31 |