tmshia - Laravel Schema Designer

users

id increments
timestamps timestamps
name string
email string
mobile string
country_code_id ^FK integer
password string
type enum
status enum
admin_approve enum
confirm_code string
confirmation_status enum
image string
wallet string
id_number string
age string
verified enum
rank string
account_type enum
certification_image string
bank_name string
bank_image string
account_number string
experience string
currency_id ^FK integer
gender enum
completed_register enum

device_tokens

id increments
timestamps timestamps
user_id ^FK integer
token text
device_language enum
device_type enum
status enum

service_categories

id increments
timestamps timestamps
title json
image string
type enum

services

id increments
timestamps timestamps
type enum
title string
service_category_id ^FK integer
duration string
guide_id ^FK integer
price string
persons string
description text
address string
target_group enum
main_image string
country_id ^FK integer
city_id ^FK integer
area_id ^FK integer
children enum
children_age string
feature text
start_time time
has_offer enum
admin_approve enum
lat string
lng string
currency string
date_start date
time_start time
date_end date
time_end time

countries

id increments
timestamps timestamps
title json
image string
type enum
country_code string
parent_id ^FK integer

service_images

id increments
timestamps timestamps
service_id ^FK integer

attachments

id increments
timestamps timestamps
title json
image string

service_attachments

id increments
timestamps timestamps
service_id ^FK integer
attachment_id ^FK integer

regiments

id increments
timestamps timestamps
service_id ^FK integer
date_from date
date_to date

service_offers

id increments
timestamps timestamps
service_id ^FK integer
price string
date_from date
date_to date

service_favourites

id increments
timestamps timestamps
user_id ^FK integer
service_id ^FK integer

rates

id increments
timestamps timestamps
user_id ^FK integer
guide_id ^FK integer
rate string
comment text

distinations

id increments
timestamps timestamps
title json
image string
city_id ^FK integer

customized_trips

id increments
timestamps timestamps
client_id ^FK integer
type enum
category_id ^FK integer
date_start date
date_end date
start_time time
end_time time
description text
duration string
country_id ^FK integer
city_id ^FK integer
male_count string
female_count string
children_count string
offer_id ^FK integer
guide_id ^FK integer
status enum

offers

id increments
timestamps timestamps
trip_id ^FK integer
guide_id ^FK integer
price string
status enum

suggested_services

id increments
timestamps timestamps
guide_name string
guide_image string
guide_number string
guide_id ^FK integer
country_id ^FK integer
city_id ^FK integer
lat string
lng string
description text

sliders

id increments
timestamps timestamps
image string

events

id increments
timestamps timestamps
title json
lat string
lng string
country_id ^FK integer
city_id ^FK integer
duration_days string
event_type_id ^FK integer
description text

event_types

id increments
timestamps timestamps
title json

notifications

id increments
timestamps timestamps
user_id ^FK integer
body text
type enum
seen enum

event_images

id increments
timestamps timestamps
event_id ^FK integer
image string

popular_questions

id increments
timestamps timestamps
question string
answer text

settings

id increments
timestamps timestamps
twitter string
whatsapp string
instagram string
sanp string
youtube string
about longText
normal_commission string
customized_trips_commission string
cancel_discount string
accepted_hours string
cancel_hours string
client_terms longText
guide_terms longText
customized_trips_offer_hours string
accepted_customized_hours string

wallet_charges

id increments
timestamps timestamps
user_id ^FK integer
payment_type enum
amount string

contact_us

id increments
timestamps timestamps
name string
email string
mobile string
country_code string
type enum
message text
read enum
reply string
reply_time timestamp

coupons

id increments
timestamps timestamps
code string
discount string
use_counts string
end_date date

currencies

id increments
timestamps timestamps
title string

discover_categories

id increments
timestamps timestamps
title json
image string

discover_items

id increments
timestamps timestamps
category_id ^FK integer
title json
country_id ^FK integer
city_id ^FK integer

discover_images

id increments
timestamps timestamps
item_id ^FK integer
image string

updates_requests

id increments
timestamps timestamps
user_id ^FK integer
image string
name string
mobile string
country_code_id ^FK integer
city_id ^FK integer
email string
currency_id ^FK integer
bank_name string
bank_image string
account_number string
account_type enum
gender enum
certification_image string
id_number string
experience string
approve_status enum