Database Structure

PiScout uses an individual SQLite database for each event scouted. Additionally, there is a global database used to track which teams have been scouted at which event so they can be referred back to.

Viewing the raw database

You can view the database using any tool of your choice that can open the SQLite .db file. We use DB Browser for SQLite and this program is pre-installed on the AWS server image. In whatever program you choose, simply navigate to the PiScout folder and select the desired database file to open. The files are named based on the event code.

Event database structure

The event database consists of the following tables:

• Scout table: contains the individual team-match records
• Comments table: contains comments entered about the team
• Statistical tables (averages, etc.): 1 table for each statistic, contains the calculated statistical values for each team