I need a professional to build a database for a website of our company.
In this site we will have 4 types of users:
- not partner
The administrator must be responsible for all content posted on the site and may change, post and remove content from all pages.
The partner must have a control screen of their information, which will be visible on the site on an individual page and may include and change according to the forms that will be available. Among this information we will have photos, links, videos, etc. Partners will have the option of placing a coupon for users with a gift, discount or something similar.
The nonpartner is the company that can disclose your information for free without contributing to the site. Information is limited and it is not entitled to an individual page.
The user is the individual who will use the site itself. He should have access to all information, lists, individual pages of partners, etc. You are not required to register to access information, but if you want to access partner coupons, you must register and log in.
We need to have a login system for the user, one for the administrator, one for partners and one for non-partners.
The site offers listings of companies offering products and services for seniors, divided into categories and subcategories. In these lists, we have 2 types of companies. Those who are partners and those who are not. Then, within a table we will have companies that show name, basic category, address and zip code (not partners); and we will have companies that will show a (partner) ID, name, full description, address, phone, and zip code. It is important that all items from partner companies are clickable and lead to their individual page.
We need any company to register to enter your information. At the time of registration they must choose to be partners and have access to an individual page and more information in the lists, or stay in the free option with less information.
Within each subcategory, where the business lines will be, we need the user to be able to apply filters like alphabetical order, group by zip code, etc.
We also need to have a search box on the homepage where the user can find companies or categories by keywords.