In my web application users can submit their advertises and buy package for advertise (packages are used for priority of showing advertises)
Database schema is like this:
**Package: id, title, priority(integer)
**PackageDuration: id, package_id(fk), duration, title
**Advertise: id, title, content, ...
**Order: price, user_id, ...
**AdvertisePackage: advertise_id(fk), packageDuration_id(fk), order_id, startDate
to show advertises lists witch is the most used query in application, I should join these tables:
My question is for performance and ease of query I want to add fields In advertise table: (priority-startDate-endDate)
is it Bad design to do so?