Need a MySQL Database
- or -
Post a project like this4034
$50
- Posted:
- Proposals: 2
- Remote
- #232209
- Awarded
Description
Experience Level: Intermediate
I need a MySQL database buuilt. It needs four tables. Customers, Dealers, Status and Account Executive. The Status table needs to be linked to teh customer, the customer table needs to be linked to the dealer table and the dealer table needs to be linked to the Account Executive table. There will be only 6 status; Approved, Declined, Conditioned, Processing, Booked, and Funded. The database needs the ability to have multiple user logins, but only the admin login needs to be able to add dealers and Account Executives. The database needs to have the ability to upload multiple new customers from a .csv file (see example .csv file attached) and it needs to have the ability to bulk update customer status' sorted by dealer. Finally, I need the database to automatically generate a staus report update for each dealer and email the status update report to the designated email at 12 AM eastern Standard Time. as also do the same for Account Executives, the only difference is that the Account Executive Report include all customers for each of their assigned dealers, Any questions please feel free to ask
David P.
100% (120)Projects Completed
112
Freelancers worked with
88
Projects awarded
80%
Last project
18 Apr 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies