MarketDatabase - Laravel Schema Designer

locations

id increments
timestamps timestamps
device_code ^FK integer
longitude decimal (9,7)
latitude decimal (9,7)

daily_sales

id increments
timestamps timestamps
title string
description string (140)
photo string
user_id ^FK integer

users

id increments
timestamps timestamps
email string
password string
stand_id ^FK integer
is_admin boolean

check_ins

id increments
timestamps timestamps
user_id ^FK integer
device_code ^FK integer

stands

id increments
timestamps timestamps
name string
description text
category_id ^FK integer
user_id ^FK integer

categories

id increments
timestamps timestamps
name string (30)

devices

id increments
timestamps timestamps
device_code integer

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