Call center SQL database schema

Question

0.00/5 (No votes)

See more:

Hello dears
imagine
I have to develop call center project and i am have a problem in create database so i will explain scenario

there are two type of employees
1- first one make the call to tell clients new offers like blew
Employee login to system then get the numbers randomly then he make a call to client then save his feedback about client like
* Client didn't interested in product
* Client busy and need to call him again after day or few hours
* Client angry and don't want to calling him again
* Client interested in product and want to hearing from you more

so if client interested in product want to hearing from you more , Employee will till him we care in his time and we will complete the order via whatsapp to send him products images and end call then save feedback .

2-Second employee will continue the order by whatsapp and he will get client number from the system based on first employee feedback so all clients that interested in products will shown in page for the second employees

after order completed there are commission for two both employees 5% for each one

best regards

What I have tried:

my database table

Employees ( ID - Name - Username - Password )
Numbers (ID - Number (PK) )
Call_log (ID - NumberID (FK) - Date - Status - Employeeid )
Products ( ID- Product_Name - Price )
orders ( ID - Date - Call_Log_ID)
order details ( ID - ProductID - Quantity )

in this schema i know who make first call with client but i don't know which employee complete the order and make the invoice

my Question if we have one call and this call completed and client buy products

so how can i know who make first call ? and who complete the order ? to calculate the commission between because there are more than 12 employee . 8 employee for make first call and 4 for continue with client

Posted 28-Jun-16 17:54pm

beljk

Updated 10-Aug-16 1:10am

v2

Add a Solution

Comments

Tomas Takac 29-Jun-16 2:40am

Maybe I don't understand but isn't that information (who made the first call) in your Call_log table?

beljk 29-Jun-16 13:50pm

Employee that told client product offers and if client interested in the product then employee will end the call with client and tell client we will continue the order by using WhatsApp to send him products images then the same employee will call another client and make this steps again .. Other employee will contact the interested clients by using WhatsApp and complete the order .. I want to know this two employee that first one make a call and other employee complete the order because every one will get commission 50% for each one of two employee

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 11114915 - Tanvi · Answer 1 · 2016-08-10T01:10:00

Add one more column to get employeeID of watsAppEmployee. Once first caller registers the positive feedback, details will reflect in watsAppEmployee login and he can mark it (by clicking checkbox) for owing that and this response is registered in table marking its watsAppEmployeeID against the order. In this way you will have first caller as well watsAppEMployee ids and on that basis you can distribute the commission.

Also, if first caller assigns order to the WatsAppEMp, then its watsAPpEMpID can be mentioned along with the feedback.

In this way, you can get the firstcaller id and watsAppEmpID once order is confirmed.