prodeal - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
username string (255)
first_name string
last_name string
email string

shops

id increments
timestamps timestamps
softDeletes softDeletes
name string
first_address text
second_address text
description text
website string
latitude text
longitude text

deals

id increments
shop_id ^FK integer
timestamps timestamps
softDeletes softDeletes
code string
validity timestamps
quantity integer
description text

deals_users

id increments
timestamps timestamps
softDeletes softDeletes
deal_id ^FK integer
user_id ^FK integer

comments

id increments
user_id ^FK integer
shop_id ^FK integer
timestamps timestamps
softDeletes softDeletes
rating tinyInteger
comment text

images

id increments
timestamps timestamps
softDeletes softDeletes
type string
type_id integer
url text

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