tour-us - Laravel Schema Designer

ads

id increments
timestamps timestamps
title string
content text
image string
expire_date date

main_categories

id increments
timestamps timestamps
name string
image string

subcategories

id increments
timestamps timestamps
name string
main_category_id ^FK integer

tourist_places

id increments
timestamps timestamps
subcategory_id ^FK integer
city_id ^FK integer
image string
name string
lat string
long string
map_desc text
description text

cities

id increments
timestamps timestamps
name string

orders

id increments
timestamps timestamps
main_category_id integer
city_id ^FK integer
lat string
long string
date date
time time
persons_num integer
provider_id integer
hours_num integer
description longText
payment_method_id integer
user_id ^FK integer
status integer
vat double
total_price double
person_price double
order_num string
refuse_reason string
cancel_reason string
notes text
subcategory_id ^FK integer
price double

providers

id increments
timestamps timestamps
image string
name string
phone string
country_key string
email string
bio text
main_category_id ^FK integer
subcategory_id ^FK integer
city_id ^FK integer
lat string
long string
map_desc text
has_car boolean
persons_num integer
bank_name string
bank_owner_name string
account_id string
iban string
approval_status integer
code string
person_price double
is_notify boolean

users

id increments
timestamps timestamps
name string
phone string
country_key string
email string
image string
code string

complaints

id increments
timestamps timestamps
order_id ^FK integer
complaint_reason string
description text
status integer
user_id ^FK integer

languages

id increments
timestamps timestamps
name string

complaint_images

id increments
timestamps timestamps
complaint_id ^FK integer
image string

plans

id increments
timestamps timestamps
name string
price double
description text
provider_id ^FK integer
date date
time time

provider_languages

id increments
timestamps timestamps
provider_id ^FK integer
language_id ^FK integer

provider_timings

id increments
timestamps timestamps
provider_id ^FK integer
from time
to time
is_off boolean

provider_works

id increments
timestamps timestamps
provider_id ^FK integer
image string
description text

contact-us

id increments
timestamps timestamps
name string
phone string
country_key string
email string
message longText

reviews

id increments
timestamps timestamps
user_id ^FK integer
order_id ^FK integer
comment text
rate integer
provider_id ^FK integer

intros

id increments
timestamps timestamps
image string
title string
description text

complaint_replys

id increments
timestamps timestamps
complaint_id ^FK integer
reply text
replyer_id integer
replyer_type string

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