== Purchasing a Subscription

==== Actors: **Registered Boss**

**1.** The user selects a subscription plan.

**2.** The system creates an active subscription.

**3.** The payment is recorded.


{{{#!sql
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);


}}}