tachines - Laravel Schema Designer

users

id increments
name string (255)
email string (255)
phone text
address text
email_verified_at timestamp
password string (255)
remember_token string (100)
country_id integer
type integer
website text
timestamps timestamps

countries

id increments
code text
name text
timestamps timestamps
softDeletes softDeletes

advertisements

id increments
user_id integer
category_id integer
brand_id integer
currency_id integer
year text
mileage text
location longText
weight string
model text
stelnr text
refnr text
aksel text
price text
date_registered datetime
description text
status boolean
views integer
video_url text
timestamps timestamps
softDeletes softDeletes

categories

id increments
parent_id integer
name text
image text
status boolean
timestamps timestamps

category_detail

id increments
name text
status boolean
timestamps timestamps
softDeletes softDeletes

advertisement_details

id increments
advertisement_id integer
category_detail_id integer
label text
value text
timestamps timestamps
softDeletes softDeletes

advertisement_images

id increments
advertisement_id integer
image_url text
order integer
timestamps timestamps
softDeletes softDeletes

user_types

id increments
type text
timestamps timestamps

favorites

id increments
user_id integer
advertisement_id integer
timestamps timestamps
softDeletes softDeletes

user_roles

id increments
user_type_id integer
role text
allow boolean
timestamps timestamps
softDeletes softDeletes

brands

id increments
name text
status boolean
timestamps timestamps
softDeletes softDeletes

sync_data

id increments
user_id integer
sync_url string
cron_id integer
timestamps timestamps
softDeletes softDeletes

subcategories

id increments
category_id integer
name text
status boolean
timestamps timestamps
softDeletes softDeletes

cron_frequencies

id increments
frequency text
cron_text text
timestamps timestamps
softDeletes softDeletes

advertisement_categories

id increments
advertisement_id integer
category_detail_id integer
timestamps timestamps
softDeletes softDeletes

currencies

id increments
currency_code string (10)
name string (255)
symbol string (25)
format string (50)
exchange_rate string (255)
active tinyInteger
timestamps timestamps
softDeletes softDeletes

payment_packages

id increments
name text
monthly_duration integer
status boolean
timestamps timestamps
softDeletes softDeletes

payments

id increments
client_id integer
advertisement_id integer
package_type integer
payment_type integer
ref_no text
expiration_date datetime
expired boolean
timestamps timestamps
softDeletes softDeletes

payment_type

id increments
name text
timestamps timestamps
softDeletes softDeletes

messages

id increments
from integer
to integer
title text
message text
timestamps timestamps
softDeletes softDeletes

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