I gang

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

Færdigheder: Databaseudvikling, Programmering af database, Web Sikkerhed, Web Design

Se mere: i need to design few photorealistic renders of a new type of house, database design microblogging site, database design commerce site, 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, database design matrimonial site, will add site links database reciprocate link exchange

Om arbejdsgiveren:
( 0 bedømmelser ) puyallup, United States

Projekt-ID: #15432099

Tildelt til:

fanninson45

I am a caspio developer. I did similar project here [url removed, login to view] I am an experienced Database Programmer and willing to assist you with this project Relevant Skills and Exp Mere

$700 USD in 14 dage
(18 bedømmelser)
5.6

13 freelancers are bidding on average $821 for this job

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 Mere

$750 USD in 7 dage
(95 bedømmelser)
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 Mere

$315 USD in 10 dage
(323 bedømmelser)
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. Mere

$2000 USD in 25 dage
(10 bedømmelser)
6.3
deltatechnepal

A proposal has not yet been provided

$500 USD in 30 dage
(24 bedømmelser)
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 Mere

$555 USD in 10 dage
(29 bedømmelser)
5.0
$555 USD in 10 dage
(3 bedømmelser)
3.7
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 Mere

$611 USD in 10 dage
(4 bedømmelser)
3.4
$250 USD in 10 dage
(8 bedømmelser)
3.6
gianpie

A proposal has not yet been provided

$2777 USD in 18 dage
(3 bedømmelser)
3.7
$555 USD in 10 dage
(2 bedømmelser)
3.7
$555 USD in 10 dage
(1 bedømmelse)
0.1
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: Mere

$555 USD in 10 dage
(0 bedømmelser)
0.0