consultant - Laravel Schema Designer

con_experts

id increments
level_id integer
expertNum integer
nationalCode string (10)
idNo string (10)
phone string (15)
temp_mobile string (128)
postalCode string (20)
address string (500)
alt_department_ids string (150)
signature_file_id bigInteger
uploadedFilesIDs string (120)
experimentalPeriod enum
status tinyInteger
subStatus tinyInteger
maxPrice decimal (15,0)
voice_call tinyInteger
reserve_call tinyInteger
firstActivated tinyInteger
conditionsAgree enum
introduction integer
experiences text
subject string (255)
card_file_id string (255)
old_price integer
corp_price decimal (15,0)
discount_percent integer
is_vip tinyInteger
spc_user tinyInteger
is_private tinyInteger
videocall tinyInteger
videoDescription string (500)
listing tinyInteger
nezamCode string (255)
package_enabled tinyInteger
chat_consulting tinyInteger
temporary_banned_times integer
chat_consulting_description string (500)
departmentID integer
navid_net_number string (20)
timestamps timestamps
chat_enabled tinyInteger
currency_code string (5)
immediatelyOffWork bigInteger
commisionRate decimal (15,0)
reservasion_cancel_period integer
minimum_instantaneous_communication_interval integer
immediate_contact_enabled tinyInteger
call_enabled tinyInteger
video_enabled tinyInteger
reserve_enabled tinyInteger
online_status string
calender string (500)
chat_consulting_price decimal (15,0)
last_activated_at datetime
videoPrice integer
shortBio string (500)
userID integer
profileImageID string (300)
bio text
metaData string (1000)
name string
languages string (200)
family string

con_expert_categories

id increments
expertUserID ^FK bigInteger
categoryID ^FK bigInteger
timestamps timestamps

con_packages

id increments
name string (255)
timestamps timestamps

con_reservations

id increments
user_id bigInteger
start_date timestamp
finish_date timestamp
expert_id bigInteger
canceled_at timestamp
canceled_by string (255)
status string (255)
package_id bigInteger
service_id bigInteger
host_id bigInteger
timestamps timestamps

con_categories

id increments
parent_id bigInteger
slag string (255)
image_id bigInteger
active tinyInteger
language string (5)
country string (5)
timestamps timestamps
title string (255)
description string (500)

con_services

id increments
name string (255)
timestamps timestamps

con_package_service

id increments
package_id ^FK bigInteger
service_id ^FK bigInteger
is_free tinyInteger
off_percent integer
duration integer
timestamps timestamps

con_hosts

id increments
name string (191)
code string (191)
token string (300)
info text
status enum
timestamps timestamps

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