Consult - Laravel Schema Designer

hosts

id increments
name string (255)
token string (255)
meta json
allowed_ips string (255)
active boolean
timestamps timestamps
softDeletes softDeletes

categories

id increments
parent_id ^FK integer
title string (255)
description text
slug string (255)
image string (255)
timestamps timestamps
softDeletes softDeletes

host_categories

id increments
host_id ^FK integer
category_id ^FK integer
country_code string (5)
timestamps timestamps

experts

id increments
uuid string (80)
user_id integer
currency_code string (5)
first_name string (50)
last_name string
bio mediumText
image string (500)
status enum
active boolean
chat_enabled boolean
chat_cost decimal (15,0)
call_enabled boolean
call_cost decimal (15,0)
video_enable boolean
video_cost decimal (15,0)
timestamps timestamps
softDeletes softDeletes

expert_languages

id increments
expert_id ^FK integer
lang_code string (5)
timestamps timestamps

expert_days

id increments
expert_id ^FK integer
day string (10)
start_time time
end_time time
timestamps timestamps

expert_documents

id increments
expert_id ^FK integer
file_name string (255)
file_address string (500)
is_public boolean
timestamps timestamps
softDeletes softDeletes

services

id increments
Title string (255)
description text
timestamps timestamps

packages

id increments
title string (255)
description string
active boolean
duration integer
timestamps timestamps

expert_off_days

id increments
expert_id ^FK integer
start_time datetime
end_time datetime
timestamps timestamps

package_items

id increments
package_id ^FK integer
service_id ^FK integer
session_count mediumInteger
price_type enum
price_value decimal (15,0)
extra_price_value decimal (15,0)
price_currency_code string (5)
session_type enum
duration integer
timestamps timestamps
softDeletes softDeletes

expert_packages

id increments
expert_id ^FK integer
package_id ^FK integer
timestamps timestamps

expert_package_reservations

id increments
host_id ^FK integer
user_id integer
expert_id ^FK integer
expert_package_id ^FK integer
package_name string
actual_cost decimal (15,0)
discount_cost decimal (15,0)
final_cost decimal (15,0)
used_voucher_id integer
user_transaction_id integer
currency_code integer
status enum
start_time datetime
end_time datetime
timestamps timestamps
immideiatly boolean
softDeletes softDeletes

expert_package_reservation_items

id increments
expert_package_reservation_id ^FK integer
package_item_id integer
service_id ^FK integer
session_order integer
session_type enum
start_time datetime
end_time datetime
status enum
timestamps timestamps

transactions

id increments
timestamps timestamps
softDeletes softDeletes

change_logs

id increments
timestamps timestamps

expert_categories

id increments
timestamps timestamps
expert_id ^FK integer
category_id ^FK integer

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