tourism - Laravel Schema Designer

users

id increments
first_name string (50)
username string
email string
last_name string (50)
password string
phone bigInteger
image string
block tinyInteger
type enum
timestamps timestamps

countries

id increments
name string
timestamps timestamps
user_id ^FK integer

cities

id increments
country_id ^FK integer
name string
timestamps timestamps

Categories

id increments
name string
parent_id integer
user_id ^FK integer
timestamps timestamps

products

id increments
name string
description text
region text
price integer
cost integer
country_id ^FK integer
city_id ^FK integer
store_id ^FK integer
category_id ^FK integer
timestamps timestamps

category_attributes

id increments
name string
category_id ^FK integer
timestamps timestamps

product_attributes_values

id increments
product_id ^FK integer
ad_id ^FK integer
attribute_id ^FK integer
value string
timestamps timestamps

stores

id increments
identity_number bigInteger
email string
password string
block tinyInteger
user_id ^FK integer
timestamps timestamps

ratings

id increments
rate integer
type enum
product_id ^FK integer
ad_id ^FK integer
store_id ^FK integer
user_id ^FK integer
timestamps timestamps

tickets

id increments
title string
subject text
admin_id integer
user_id integer
readed tinyInteger
timestamps timestamps
ticket_category_id ^FK integer
ticket_priority_id ^FK integer

tickets_categories

id increments
name string
timestamps timestamps

ticket_priorities

id increments
timestamps timestamps
name string

ticket_reply

id increments
admin_id integer
user_id string
ticket_id ^FK integer
timestamps timestamps

ads

id increments
category_id ^FK integer
name string
description text
region text
price_per_hour integer
price_per_day string
price_per_person integer
country_id ^FK integer
city_id ^FK integer
store_id ^FK integer
timestamps timestamps

order

id increments
products json
amount integer
status tinyInteger
user_id ^FK integer
timestamps timestamps

offers

id increments
name string
start_date string
expire_date string
percentage string
from string
to string
ad_id ^FK integer
offer_category_id ^FK integer
price_type_id ^FK integer
timestamps timestamps

offer_categories

id increments
name string
description text
timestamps timestamps

price_types

id increments
name string
timestamps timestamps

product_prices

id increments
quantity integer
price integer
weekend_price integer
ad_id ^FK integer
timestamps timestamps

ad_labels

id increments
label string
ad_id ^FK integer
product_id ^FK integer
timestamps timestamps

trip_categories

id increments
image string
timestamps timestamps

sell_trips

id increments
price integer
price_per_person integer
region text
quantity integer
image string
from string
to string
category_id ^FK integer
country_id ^FK integer
city_id ^FK integer
timestamps timestamps

trip_offers

id increments
trip_id ^FK integer
category_id ^FK integer
trip_category_id ^FK integer
timestamps timestamps

offer_features

id increments
trip_offer_id ^FK integer
item_offer_id ^FK integer
res_offer_id ^FK integer
type string
value string
timestamps timestamps

trip_category_ttributes

id increments
trip_category_id ^FK integer
timestamps timestamps