heraj - Laravel Schema Designer

users

id increments
username string (191)
email string (191)
phone integer
country ^FK integer
city ^FK integer
timestamps timestamps

country

id increments
code string (191)
timestamps timestamps

country_translations

id increments
country_id ^FK integer
name string (191)
locale string (191)
timestamps timestamps

cities

id increments
country_id ^FK integer
code string (191)
timestamps timestamps

city_translations

id increments
city_id ^FK integer
name string (191)
locale string (191)
timestamps timestamps

categories

id increments
timestamps timestamps
parent_id integer

category_translations

id increments
category_id ^FK integer
name string (191)
locale string (191)
timestamps timestamps

products

id increments
country_id ^FK integer
city_id ^FK integer
price integer
discount integer
timestamps timestamps

product_translations

product_id ^FK integer
id increments
name string (191)
descrption text
locale string (191)
timestamps timestamps

ads

id increments
category_id ^FK integer
country_id ^FK integer
city_id ^FK integer
price integer
created date
user_id ^FK integer
timestamps timestamps
contact_option enum
year date

ads_translation

id increments
ads_id ^FK integer
title string (191)
descrption text
timestamps timestamps
locale string (191)

replay

id increments
user_id ^FK integer
ads_id ^FK integer
comment text
timestamps timestamps

pages

id increments
timestamps timestamps

page_translations

id increments
page_id ^FK integer
title string (191)
descrption text
timestamps timestamps
locale string (191)

files

id increments
timestamps timestamps
image string (191)

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