utaa_api - Laravel Schema Designer

sensors

id increments
timestamps timestamps
title string
mac string
api_key string
user_id integer

readings

id increments
timestamps timestamps
user_id integer
sensor_id integer
location_id integer
pm1 string
pm25 string
pm10 string
so2 string
o3 string
no2 string
co string
nh3 string
humidity string
temperature string
other text

locations

id increments
timestamps timestamps
user_id integer
sensor_id integer
lat string
lon string
ip string

user_infos

id increments
user_id integer
timestamps timestamps
country string
city string
district string
address_1 string
address_2 string
zipcode string
phone string

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