呼叫中心SQL数据库架构 [英] Call center SQL database schema

问题描述

Hello dears

想象

我必须开发呼叫中心项目，我在创建数据库时遇到问题所以我会解释这个场景



有两种类型的员工

1-第一个打电话告诉客户新的报价如吹气

员工登录系统然后随机获取数字然后他打电话给客户然后保存他对客户的反馈如

*客户对产品不感兴趣

*客户忙，需要打电话给他再过一天或几个小时

*客户生气，不想再给他打电话

*客户对产品感兴趣并希望收到你的回复



因此，如果对产品感兴趣的客户希望更多地收到您的回复，员工将在他们的时间关注他们，我们将通过whatsapp完成订单，向他发送产品图片和结束通话然后保存反馈。



2秒的员工将通过whatsa续订pp并且他将根据第一个员工反馈从系统获取客户编号，以便所有对产品感兴趣的客户将在页面中显示第二个员工



订单完成后两个员工的佣金为每人5％





最好的问候



我尝试过：



我的数据库表



员工（ID - 姓名 - 用户名 - 密码）

号码（ID - 号码（PK））

Call_log（ID - 号码ID（FK） - 日期 - 状态 - 员工）

产品（ID-产品名称 - 价格）

订单（ID - 日期 - Call_Log_ID）

订单详情（ID - ProductID - Quantity）


这个架构中的
我知道谁先与客户打电话，但我不知道哪个员工完成订单并开具发票



我的问题，如果我们有一个电话，这个电话已完成，客户购买公关产品



所以我怎么知道谁先打电话？谁完成订单？计算之间的佣金因为有超过12名员工。 8个员工进行第一次调用，4个用于继续客户端

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

推荐答案

再添加一列以获取watsAppEmployee的employeeID。一旦第一个调用者注册了正反馈，详细信息将反映在watsAppEmployee登录中，并且他可以将其标记（通过单击复选框），因为这个并且此响应在表中注册，标记其watsAppEmployeeID对照订单。通过这种方式，您将拥有第一个调用者以及watsAppEMployee ID，并且在此基础上您可以分配佣金。



此外，如果第一个调用者将订单分配给WatsAppEMp，那么它的watsAPpEMpID可以与反馈一起提及。



通过这种方式，一旦确认订单，你就可以得到第一个来电者ID和watsAppEmpID。

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.

这篇关于呼叫中心SQL数据库架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！