amr - Laravel Schema Designer

sites

id increments
name string
addres string
timestamps timestamps

apartments

id increments
site_id ^FK integer
number string
timestamps timestamps

concentrators

id increments
site_id ^FK integer
serial string (256)
fw_update boolean
timestamps timestamps

transmitters

id increments
site_id ^FK integer
apartment_id ^FK integer
serial string (64)
timestamps timestamps

readings

id increments
transmitter_id ^FK integer
water_value integer
battery_level integer
tamper_status boolean
pair_status boolean
timestamps timestamps

tenants

id increments
name string (40)
surname string (40)
email string (256)
phone string (15)
timestamps timestamps

occupancy

id increments
apartment_id ^FK integer
tenant_id ^FK integer
timestamps timestamps

report

id increments
timestamps timestamps
consumption integer
date string
reading_start_id ^FK integer
reading_end_id ^FK integer

concentrator_status

id increments
concentrator_id ^FK integer
battery_level integer
power_main tinyInteger
location string (30)
heatlh string (50)
timestamps timestamps

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