Purchasing a Subscription

Actors: Registered User (USER)

1. The user selects a subscription plan.

2. The system creates an active subscription.

3. The payment is recorded.

INSERT INTO user_subscription (user_id, plan_id, start_date, end_date, status)
VALUES (1, 2, CURRENT_DATE, CURRENT_DATE + INTERVAL '6 months', 'ACTIVE');

INSERT INTO payment (user_id, subscription_id, amount)
VALUES (1, 1, 49.99);