What tables link ads, orders and payments?

Question

Database design

Logic: The
user adds an ad.
The status of the object is not published.
The user pays for the ad.
Object status - published.
5 days
pass The status of the object is not published.
What should be the collection of tables? Possible without margins.
mysql database

Answer 1

User(id, name)
Ad(id, user_id, status, text)
Payment(id, user_id, ad_id, pay_date, sum)