Database design and link to site

Đã hoàn thành Đã đăng vào 6 năm trước Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

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

Phát triển cơ sở dữ liệu Lập trình cơ sở dữ liệu An ninh Web Thiết kế trang web

ID dự án: #15432099

Về dự án

12 đề xuất Dự án từ xa 6 năm trước đang mở

Được trao cho:

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 Thêm

$700 USD trong 14 ngày
(30 Đánh Giá)
6.1

12 freelancer chào giá trung bình$839 cho công việc này

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 Thêm

$315 USD trong 10 ngày
(349 Nhận xét)
7.9
deltatechnepal

A proposal has not yet been provided

$500 USD trong 30 ngày
(35 Nhận xét)
5.8
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 Thêm

$555 USD trong 10 ngày
(74 Nhận xét)
5.9
gianpie

A proposal has not yet been provided

$2777 USD trong 18 ngày
(4 Nhận xét)
3.7