orange_fidelite - Laravel Schema Designer

partners

id increments
timestamps timestamps
softDeletes softDeletes
status enum
name string (255)
description text
website string (255)
facebook string (255)
instagram string (255)
twitter string (255)
email string (255)

pos

id increments
timestamps timestamps
softDeletes softDeletes
partner_id ^FK integer
address string (255)
name string (20)
phone string (20)
opening_times text
lat float (10,6)
lng float (10,6)

partners_images

id increments
timestamps timestamps
softDeletes softDeletes
partner_id ^FK integer
path string (255)
thumb_rect string (255)

categories

id increments
timestamps timestamps
parent_id ^FK integer
name string (255)
color string (20)

offers

id increments
timestamps timestamps
softDeletes softDeletes
status enum
description text
type enum
added_value text
discount_with_purchase text
discount_before_price float
discount_after_price float
discount_fixed_amount float
discount_percent_amount float
howto text
legal text
starting_at datetime
ending_at datetime
partner_id ^FK integer
main_image_id ^FK integer
duration enum

offers_images

id increments
timestamps timestamps
softDeletes softDeletes
offer_id ^FK integer
path string (255)
thumb_wide string (255)
thumb_square string (255)
thumb_rect string (255)

offers_categories

id increments
timestamps timestamps
offer_id ^FK integer
category_id ^FK integer

users

id increments
timestamps timestamps
name string
email string
password string
remember_token string

password_resets

email string
token string

socialwall

timestamps timestamps
softDeletes softDeletes
id string
image_path string
video_path string
caption text
external_url string

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