crm_smartserve - Laravel Schema Designer

Users

id increments
name string
email string
phone string
asterisk_ip string
ex_number string
ex_pass string
ex_type enum
menu_id string
password string
gender enum
status enum
tenant_id ^FK integer
softDeletes softDeletes
timestamps timestamps

tenants

id increments
domain string
user_id ^FK integer
db_name string
db_user string
db_pass string
redis_user string
redis_pass string
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string
user_id ^FK integer
timestamps timestamps

permissions

id increments
name string
slug string
role_id ^FK integer
timestamps timestamps

settings

id increments
timestamps timestamps
user_id ^FK integer
outbound_number string
extension string
ai_extension string

call_logs

id increments
caller_number string
receiver_number string
src string
duration timestamp
status enum
type enum
agent_id ^FK integer
timestamps timestamps

contacts

id increments
name string
dial_code string
phone string
timestamps timestamps

campaigns

id increments
name string
type enum
call_at_time integer
notes text
timestamps timestamps

campaign_contact

id increments
timestamps timestamps
campaign_id ^FK integer
contact_id ^FK integer
call_attempt integer

campaign_report

id increments
timestamps timestamps
campaign_id ^FK integer
total_calls integer
answered_calls integer
failed_calls integer
total_duration string

tickets

id increments
subject string
type string
agent_id ^FK integer
contact_id ^FK integer
status enum
desc text
timestamps timestamps

products

id increments
name string
desc string
timestamps timestamps

skus

id increments
product_id ^FK integer
price double
stock bigInteger
timestamps timestamps

orders

id increments
contact_id ^FK integer
total double
status enum
timestamps timestamps

sku_order_items

id increments
order_id ^FK integer
sku_id ^FK integer
price double
quantity integer
subtotal double
timestamps timestamps

order_flow_two

id increments
contact_id ^FK integer
total double
status enum
timestamps timestamps

order_items_flow_two

id increments
order_id ^FK integer
quantity integer
unit_price double
subtotal double
timestamps timestamps

sku_flow_two

id increments
code string
stock integer
price double
product_id ^FK integer
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01