madr - Laravel Schema Designer

Users

id increments
lastname string (50)
firstname string (50)
username string (30)
email string
password string
api_token string
id_company ^FK integer
timestamps timestamps

Robots

id increments
name string (30)
id_company ^FK integer
api_token string

Companies

id increments
SIRET string
name string (50)
timestamps timestamps

Roles

id increments
title string (50)

GroupUser

id_user ^FK integer
id_group ^FK integer

Systems

id increments
title string (30)

Missions

id increments
title string (30)
achieved boolean
timestamps timestamps

Groups

id increments
name string (50)
description string

Demands

id increments
title string (50)
description string
valid boolean
finish boolean
timestamps timestamps

Softwares

id increments
name string (30)
version float
timestamps timestamps

Configurations

id increments
id_software ^FK integer
timestamps timestamps

SystemRobot

id increments
id_robot ^FK integer
id_system ^FK integer

GroupSystem

id increments
id_system ^FK integer
id_group ^FK integer

Data

id increments
longetitude float
latitude float
temperature float
speed integer
distance float
id_robot ^FK integer
timestamps timestamps

RoleUser

id_role ^FK integer
id_user ^FK integer

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