Database Model

detection

Incoming hardware detection events

column	type	constraints
id	integer	primary key
baton_id	integer	fk_baton
beacon_id	integer	fk_beacon
timestamp	timestamp

team

column	type	constraints
id	integer	primary key
name	varchar(255)
baton_id	integer	fk_baton

baton

column	type	constraints
id	integer	primary key
name	varchar(255)

beacon

column	type	constraints
id	integer	primary key
name	varchar(255)

lap

Generated by the logic, based on incoming detections.

column	type	constraints
id	integer	primary key
team_id	integer	fk_team
timestamp	timestamp