mesa - Laravel Schema Designer

User

id increments
timestamps timestamps
user_name string (255)
email string (255)
name string (255)
password string (255)
Status tinyInteger
role_id tinyInteger
phone string (255)
email_verified string (255)
fcm_token string (255)

inbording

id increments
timestamps timestamps
image string (255)
title string (255)
description string (255)
active string

business

id increments
timestamps timestamps
name string (255)
business_category_id ^FK integer
location string (255)
phone string (255)
attachment string (255)
user_id ^FK integer
open_at date
close_st date
max_people integer
fees string (255)

branch

id increments
timestamps timestamps
location string (255)
user_id ^FK integer
is_active tinyInteger

category

id increments
timestamps timestamps
name string (255)
description string (255)
image string (255)
active tinyInteger

rooms

id increments
timestamps timestamps
title string (255)
no_of_person integer
price string (255)
category_id ^FK integer
description string (255)
open_at date
close_at date
Status tinyInteger
branch_id ^FK integer
policy text
tags json
active string (100)

gallary

id increments
timestamps timestamps
room_id ^FK integer
image string (255)
thumb_image string (255)
is_main tinyInteger

feature

id increments
timestamps timestamps
name string (255)
active string (100)
icon string (255)

room_feature

id increments
timestamps timestamps
room_id ^FK integer
feature_id ^FK integer

business_category

id increments
timestamps timestamps
name string
image string
parent_id integer
position tinyInteger
active string (100)

booking

id increments
timestamps timestamps
Date date
date_from time
date_to time
user_id ^FK integer
room_id ^FK integer
type string (255)
Status tinyInteger
totla_price integer
file string (255)

setting

id increments
timestamps timestamps
Key string (255)
Value string
active string (100)

Favorite

id increments
timestamps timestamps
user_id ^FK integer
room_id ^FK integer

contact_us

id increments
timestamps timestamps
naem string (255)
email string (255)
subject string (255)
message string (255)

review

id increments
timestamps timestamps
user_id ^FK integer
rate float
comment text
room_id ^FK integer

Ads

id increments
timestamps timestamps
banner string (255)
invoice string (255)
price string (255)
duration string (255)
approved tinyInteger
start_date date
end_date date

service

id increments
timestamps timestamps
name string (255)
description text
icon string (255)

room_services

id increments
timestamps timestamps
service_id ^FK integer
room_id ^FK integer

translate

id increments
timestamps timestamps
language_id ^FK integer
modale text
recored_id integer
field string (100)
display_text string (255)

language

id increments
timestamps timestamps
code string (100)
is_active tinyInteger

admins

id increments
timestamps timestamps
user_name string (255)
email string (255)
name string
password string (255)
Status string (255)
role_id string (255)
phone string (255)
email_verified string (255)
fcm_token string (255)

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