Users
id | username | email |
1 | User1 | user1@example.com |
2 | User2 | user2@example.com |
3 | User3 | user3@example.com |
4 | User4 | user4@example.com |
5 | User5 | user5@example.com |
Genres
genre_id | name |
1 | Action |
2 | Comedy |
3 | Drama |
4 | Horror |
5 | Romance |
Movies
movie_id | title | release_year | genre_id |
| | | (→ Genres.genre_id) |
1 | Movie1 | 2021 | 1 |
2 | Movie2 | 2020 | 2 |
3 | Movie3 | 2019 | 3 |
4 | Movie4 | 2022 | 4 |
5 | Movie5 | 2018 | 5 |
Subscriptions
subscription_id | user_id | start_date | end_date | status |
| (→ Users.id) | | | |
1 | 1 | 2023-01-01 | 2023-12-31 | Active |
2 | 2 | 2023-02-01 | 2023-12-31 | Inactive |
3 | 3 | 2023-03-01 | 2023-12-31 | Canceled |
4 | 4 | 2023-04-01 | 2023-12-31 | Expired |
5 | 5 | 2023-05-01 | 2023-12-31 | Active |
Payments
payment_type |
(→ PaymentTypes.payment_type) |
Credit_Card |
Debit_Card |
PayPal |
Bank_Transfer |
Google_Pay |
Streamings
streaming_id | movie_id | user_id | stream_start_time | stream_end_time |
| (→ Movies.movie_id) | (→ Users.id) | | |
1 | 1 | 1 | 2023-01-01 10:00:00 | 2023-01-01 12:00:00 |
2 | 2 | 2 | 2023-01-02 10:00:00 | 2023-01-02 12:00:00 |
3 | 3 | 3 | 2023-01-03 10:00:00 | 2023-01-03 12:00:00 |
4 | 4 | 4 | 2023-01-04 10:00:00 | 2023-01-04 12:00:00 |
5 | 5 | 5 | 2023-01-05 10:00:00 | 2023-01-05 12:00:00 |
Streamings_Payments
streaming_id | payment_id |
(→ Streamings.streaming_id) | (→ Payments.payment_id) |
1 | 1 |
2 | 1 |
3 | 2 |
4 | 2 |
5 | 3 |
3 | 1 |
4 | 1 |
5 | 1 |