WawaTour - Laravel Schema Designer

roles

id bigIncrements
title string

users

id bigIncrements
timestamps timestamps
username string (30)
email string (100)
password string (100)
salt string (30)
register_ip string (15)
forget_token string (100)
active_token string (100)

permissions

id bigIncrements
slug string (100)

permission_role

permission_id ^FK bigInteger
role_id ^FK bigInteger

role_user

role_id ^FK bigInteger
user_id ^FK bigInteger

login_attempts

id bigIncrements
user_id ^FK bigInteger
login_ip string (15)
login_time timestamp

pois

id bigIncrements
timestamps timestamps
name string
photo string
full_address string
city string
status enum
tickets text
icons json
caption_path string
latlng string (10)
description text
url string
category_id ^FK bigInteger
gallery_id ^FK bigInteger
beacon_uuid string
i18n json

categories

id bigIncrements
timestamps timestamps
name string
icon string
i18n json

routes

id bigIncrements
timestamps timestamps
title string
length string
duration string
description text
status enum
i18n json

badges

id bigIncrements
timestamps timestamps
title string
icon_path string
status enum
i18n json

mobile_surveys

id bigIncrements
timestamps timestamps
answer json
mobile_user_id ^FK bigInteger

galleries

id bigIncrements
timestamps timestamps
title string
i18n json

gallery_images

id bigIncrements
timestamps timestamps
path string
width integer
height integer
alt string (255)
description text
gallery_id ^FK bigInteger
i18n json

ar_tours

id bigIncrements
timestamps timestamps
latlng string
audio_path string
audio_caption_path string
video_path string
video_caption_path string
quiz json
vr360_xml_path string
title string
description text
poi_id ^FK bigInteger
gallery_id ^FK bigInteger
i18n json
arkit_path string
arcore_path string

route_poi

id bigIncrements
timestamps timestamps
order integer

route_category

id bigIncrements
timestamps timestamps
route_id ^FK bigInteger
category_id ^FK bigInteger

badge_poi

id bigIncrements
timestamps timestamps
poi_id ^FK bigInteger
badge_id ^FK bigInteger

poi_user

id bigIncrements
timestamps timestamps
mobile_user_id ^FK bigInteger
poi_id ^FK bigInteger

badge_user

id bigIncrements
timestamps timestamps
badge_id ^FK bigInteger
mobile_user_id ^FK bigInteger

user_route

id bigIncrements
timestamps timestamps
mobile_user_id ^FK bigInteger
data json

mobile_user

id bigIncrements
timestamps timestamps
uuid string (32)

badge_route

id bigIncrements
timestamps timestamps
badge_id ^FK bigInteger
route_id ^FK bigInteger

banners

id bigIncrements
timestamps timestamps
lang string (2)
image_path string
status enum
expires datetime
starts datetime
url string
mode string

contacts

id bigIncrements
timestamps timestamps
full_name string
details text
address_book_id ^FK bigInteger
role string

address_books

id bigIncrements
timestamps timestamps
name string
order integer

static_pages

id bigIncrements
timestamps timestamps
slug string
summary text
text mediumText

ecard_themes

id bigIncrements
timestamps timestamps
status enum
image_path string

teams

id bigIncrements
timestamps timestamps
name string
user_id bigInteger
personal_team boolean

team_user

id bigIncrements
timestamps timestamps
team_id ^FK bigInteger
user_id ^FK bigInteger
role string

team_invitations

id bigIncrements
timestamps timestamps
team_id ^FK bigInteger
email string
role string