Completed

Database design and link to site

I need to design a comprehensive database that will have the following features and will intergrate within the website for member login and sign up to include payment processing with digital contracts. See below for a full list of what I have come up with.

I’d love for it to be done in using a system like Caspio or something similar that is easy to manage and run analytics on the data.

Information and functions that need to be accomplished

-their membership information

-First and Last name

-Address

-Cell Phone #

-Email

-Email Alert subscriptions

-their profile picture

-allow them to see different things within the website based on user access level

-Admin

-Can see everything on the website and in the database

-Can edit everything in the database and on the website

-Manager

-Can see all content on the website

-Can see almost all content in the database except user private information such as credit

card numbers, userpaswords,

-Can see and do everything users below can see and do

-Can suspend user account access for roles below manager level

-Manage user roles below manager

-CANNOT promote user to the same level as oneself

-Escalate Support tickets to Admin Level

-Support Tech

-Can see support tickets

-Answer Support tickets

-Close Support tickets

-Query Database

-Merge Records

-Escalate support tickets to Manager level

-Manage Membership Status on member accounts

-Office Staff

-Query Database

-Suspend a Member account

-More permissions later to be determined

-Active Member

-Can see all available discounts and services to members

-Can query vendor database by type of service aka vehicle maintenance, legal services,

health, dental, vision, telecommunications, restaurants, also the query should be able

to be filtered by their GEO location or address

-InActive Member

-Can see all vendors that are signed up with the The company but is unable to see the discounts provided to our members

-Payment Hold

-Can see all vendors that are signed up with the Company but is unable to see the discounts provided to our members but at the top of every page is a thick red banner that reads ACCOUNT ON HOLD FOR FAILED PAYMENT

Also the database needs to have a lookup page for vendors to be able to authenticate a members active status by typing in the membership ID and then the vendor code and clicking verify

We would also want this database to be able to house all vendors and a description of their services all in a table of course so that one column can show the normal price that vendor charges and then the next column can show either a set dollar amount for the services the vendor provides or a discount percentage. The discount or set dollar amount for services the vendor provides would need to be hidden from public view unless the person viewing is signed in with a member login and also has a member status of active.

I would also like the database to be able to securely store the members payment method and have an auto billing method set up for membership renewal.

I would also like this database to be mobile friendly so we can link it into a mobile app to be developed later

What is the best solution for all of what I just described

Habilidades: Desarrollo de base de datos, Programación de bases de datos, Seguridad web, Diseño de sitios web

Ver más: i need to design few photorealistic renders of a new type of house, database design microblogging site, database design commerce site, how to connect html to sql database, how to connect html to database with mysql, how to connect a web page to a database using php, how to connect mysql database to website, how to connect web page to database, how to connect website to database in sql, how to link access database to website, connect website to database javascript, database design contest site, database design classified site, database design auction site, demo database design live auction site, file upload site database design, database design post social networking site, database design sitter site, modular database design java service, service reservation database design

Información del empleador:
( 0 comentarios ) puyallup, United States

Nº del proyecto: #15432099

Adjudicado a:

fanninson45

I am a caspio developer. I did similar project here https://www.freelancer.com/projects/php/Caspio-Developer/ I am an experienced Database Programmer and willing to assist you with this project Relevant Skills and Exp Más

$700 USD en 14 días
(0 comentarios)
0.0

13 freelancers están ofertando el promedio de $821 para este trabajo

A2Design

Hello, We are a team of 30 developers based in Russia. If you you need help with: - Website/web application/e-commerce development (any complexity) from scratch or using a premade solution - Front-end and back-en Más

$750 USD en 7 días
(95 comentarios)
8.6
dgapscom

Hi there, I am Faisal professional SEO friendly web designer & developer. Please come in private chat to discuss more in detail about your project. Relevant Skills and Experience I have 6+ years of experience with mor Más

$315 USD en 10 días
(323 comentarios)
7.5
lavizsolutions

Hi, I can provide you solution in PHP and mysql with codeignitor framework. as most the times projec cancelled here so for time being placing a temp bib, after getting your message will show you with wireframes. Más

$2000 USD en 25 días
(10 comentarios)
6.3
deltatechnepal

A proposal has not yet been provided

$500 USD en 30 días
(24 comentarios)
5.3
softcarve

Hi, I have good proficiency in sql and i would like to design database for you. please get in touch to discuss more. Relevant Skills and Experience sql Proposed Milestones $300 USD - after half complete $255 USD - af Más

$555 USD en 10 días
(29 comentarios)
5.0
$555 USD en 10 días
(4 comentarios)
3.8
Europa17

Dear,sir I've just completely understood what you need. I am confident to accomplish your work. Because I am database and webdesign expert. Please contact me fordiscussing more. Relevant Skills and Experience database Más

$611 USD en 10 días
(5 comentarios)
3.4
$250 USD en 10 días
(8 comentarios)
3.6
gianpie

A proposal has not yet been provided

$2777 USD en 18 días
(3 comentarios)
3.7
$555 USD en 10 días
(0 comentarios)
0.0
$555 USD en 10 días
(1 comentario)
0.0
edavet

I have carefully read your job description and I suggest my candidacy as l had projects like this, know all necessary programming languages and design skills to work on it. Relevant Skills and Experience My portfolio: Más

$555 USD en 10 días
(0 comentarios)
0.0