Banner Administration System

I have an existing website. I would like to build an external banner management system for it. The website will programmatically require a module/extension (from the banner-managment), specifying the placeholder- system-name, url and the item-id (if viewing an item) and receive back the html code of the banner to place. DB tables (suggestion, may vary): - banner-size (id, width, height) - placeholder (id, system-name, banner-size-id, title) - website-page (id, parent-id, url, item-specific) - client (id, name, email, phone, password) - campaign (id, client-id, title, description, date-start, date-end) - banner (id, campaign-id, title, url) - placement (id, banner-id, frequency) - placement-placeholder (placement-id, placeholder-id) - placement-website-page (placement-id, website-page-id, item-id) The admin adds a client. Then he adds the campaign. Then he adds the banners. Banners are uploaded and placed at the same action, since banners are only part of a campaign. In other words, same page controls all banners of a campaign and their placements. He can add a banner without uploading the actual file, in order to reserve the url for it. In case he wants to upload a flash version, he needs the url in advance. Later on he can upload the flash file with the url provided in advance, and only then set the banner to active. One more important thing is that all banners can have an image back-up. He can upload several images and choose the interval between them and the animation effect, this way is an alternative for browsers that doesn't support flash. Any client can enter the system with their email and password. They cannot edit, but they can view their campaign and statistics. Statistics are needed too. Impressions and clicks. Details about placement and page. A graph like in the following example is the way to go. Keep in mind there are different analysis possible, meaning there's more than one graph possible for the admin/client to view. Feel free to add DB tables as you desire to acomplish this goal. This is a good example: [login to view URL] but it lacks some features i've described. Feel free to change the DB structure suggested and add tables as much as you need. Use Yii in the back-end, implementing all build-in helpers (active-record etc). Please use internationalization (I18N), the project will be translated. Keep in mind RTL support. Use bootstrap3 in the front-end, pretty much like in the example i provided. That's about it. Feel free to ask any questions and suggest anything to make your work easier, but fit my requirements.