archive - Laravel Schema Designer

timestamps

id increments
timestamps timestamps
timestamp integer
chunk_duration tinyInteger
cam_id ^FK integer

statistics

id increments
timestamps timestamps
softDeletes softDeletes
views integer
cam_id ^FK integer
timestamp_id ^FK integer

realms

id increments
timestamps timestamps
softDeletes softDeletes
name string (10)

cams

id increments
timestamps timestamps
softDeletes softDeletes
name string (10)
realm_id ^FK integer

statistics_archive

id increments
timestamps timestamps
softDeletes softDeletes
views integer
cam_id ^FK integer
timestamp_id ^FK integer

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