Plan_ID | Plan_Name |
---|---|
1 | Basic |
2 | Premium |
3 | Ultra |
Service_ID | Service_Name | Price |
---|---|---|
1 | Netflix | 9.99 |
2 | Amazon Prime Video | 8.99 |
3 | Disney+ | 6.99 |
4 | Hulu | 5.99 |
5 | Apple TV+ | 4.99 |
Service_ID | Plan_ID |
---|---|
(→ Streaming_Service.Service_ID) | (→ Subscription_Plan.Plan_ID) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
Customer_ID | Name | |
---|---|---|
1 | John Doe | john@example.com |
2 | Jane Smith | jane@example.com |
3 | Mike Johnson | mike@example.com |
4 | Emily Davis | emily@example.com |
5 | David Brown | david@example.com |
Method_ID | Cardholder_Name | Card_Number | Expiry_Date | CVV |
---|---|---|---|---|
1 | John Doe | 1234-5678-9012-3456 | 12/25 | 123 |
2 | Jane Smith | 2345-6789-0123-4567 | 01/10 | 456 |
3 | Mike Johnson | 3456-7890-1234-5678 | 06/15 | 789 |
4 | Emily Davis | 4567-8901-2345-6789 | 11/20 | 123 |
5 | David Brown | 5678-9012-3456-7890 | 07/22 | 456 |
Customer_ID | Method_ID | Billing_Address |
---|---|---|
(→ Customer.Customer_ID) | (→ Payment_Method.Method_ID) | |
1 | 1 | 123 Main St, Anytown, USA |
2 | 2 | 456 Oak St, Anycity, USA |
3 | 3 | 789 Pine St, Anothertown, USA |
4 | 4 | 135 Elm St, Anyville, USA |
5 | 5 | 246 Maple Ave, Anystate, USA |
History_ID | Customer_ID | Content_ID | Watched_On |
---|---|---|---|
(→ Customer.Customer_ID) | (→ Content.Content_ID) | ||
1 | 1 | 1 | 2024-01-30 18:37:56 |
2 | 2 | 2 | 2024-01-30 18:37:56 |
3 | 3 | 3 | 2024-01-30 18:37:56 |
4 | 4 | 4 | 2024-01-30 18:37:56 |
5 | 5 | 5 | 2024-01-30 18:37:56 |
Content_ID | Title | Genre | Rating |
---|---|---|---|
1 | The Witcher | Fantasy | 9.1 |
2 | Stranger Things | Science Fiction | 8.7 |
3 | Breaking Bad | Crime Drama | 9.5 |
4 | Friends | Comedy | 8.9 |
5 | Game of Thrones | Fantasy | 9.3 |