Logisti - Laravel Schema Designer

blogs

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
description longText
image string (255)
video string (255)
date date

sliders

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
image string (255)
description longText

question_categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

questions

id increments
timestamps timestamps
softDeletes softDeletes
question text
answer longText
category_id ^FK integer

teams

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
image string (255)
description longText

settings

id increments
timestamps timestamps
softDeletes softDeletes
phone string (40)
email string (255)
whatsapp string (40)
facebook text
twitter text
linkedin text
address text
location text
vedio string (255)
allow_captcha boolean
allow_phone_auth boolean
allow_mail_auth boolean
allow_recovery_password boolean
allow_live_chat boolean

topics

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

topic_details

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
description longText
image string (255)
video string (255)
topic_id ^FK integer

comments

id increments
timestamps timestamps
softDeletes softDeletes
body longText
file string (255)
topic_detail_id ^FK integer
client_id integer

notifications

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
body longText
client_id integer
company_id integer
representative_id integer
operator_id integer
read_at string (255)

tickets

id increments
timestamps timestamps
softDeletes softDeletes
representative_id integer
company_id ^FK integer
operator_id ^FK integer
client_id ^FK integer
perriorty string (255)
ticket_category_id ^FK integer
user_id integer
description longText
status string (255)
file string (255)

ticket_categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

ticket_replies

id increments
timestamps timestamps
softDeletes softDeletes
ticket_id ^FK integer
description longText
user_id integer
type string (255)
file string

about_us

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
description longText
image string (255)

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
logo string (255)
key string (255)
code string (255)

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
country_id ^FK integer

packages

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
description longText
price double
offer double
image string (255)

clients

id increments
timestamps timestamps
softDeletes softDeletes
full_name string (255)
age integer
email string (255)
phone string (40)
gender string (255)
address text
country_id ^FK integer
city_id ^FK integer
image string (255)
about longText
verified_mail boolean
otp integer

operators

id increments
timestamps timestamps
softDeletes softDeletes
full_name string (255)
age integer
email string (255)
phone string (40)
gender string (255)
address text
country_id ^FK integer
city_id ^FK integer
image string (255)
about longText
services json
verified_mail boolean
otp integer

companies

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
email string (255)
phone string (40)
address text
logo string (255)
country_id ^FK integer
city_id ^FK integer
verified_mail boolean
about longText
otp integer

representatives

id increments
timestamps timestamps
softDeletes softDeletes
full_name string (255)
age integer
email string (255)
phone string (40)
gender string (255)
address text
country_id ^FK integer
city_id ^FK integer
image string (255)
about longText
services json
verified_mail boolean
otp integer

services

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
description text
image string (255)

requests

id increments
timestamps timestamps
softDeletes softDeletes

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