Equetronic

Introduction

Equetronic is a company that is based on the Equestrian Sports industry i.e., the horse riding and related sports industry.

Equetronic provides with a device with a RFID Tag that can be attached to the horse. The device collects information like horse's heart rate, speed, steps and GPS co-ordinates. Trainers and Owners can view real time GPS locations, stats about horse, record training sessions, replay previous training sessions, compare and do much more using the Equetronic Dasboard. In this way it can provide **Global Real-Time Connection Between Racehorse, Riders, Owners & Trainers**.

DeviceDashboard
DeviceDashboard

Information

Understanding the Industry

The Equestrian Industry in which Equetronic is primarily dealing with is focused on the organised sector of Horse Racing and Horse Training. The global horse racing market size was valued at USD 402.3 Billion in 2022 and is expected to reach USD 793.9 Billion by 2030.

Here we have the main are Agencies that will handle horses, trainers, staff, riders etc.

  • For Equetronic these agencies are the Customers.
  • Customers can have one or more Training Centers associated to them.
  • Training Centers manages the Horses, Trainers, Race Courses and Riders.
  • Training Centers can have one or more Race Courses anywhere around the globe though usually they are nearby each other.
  • Training Centers will have multiple Horses under them.
  • Horses can be passed along other Training Centers with different Customers.
  • Training Centers also provides Horse Trainers.
  • A Trainer can have multiple horses assigned to them.
  • The Horse can belong to individuals called Oweners, who provide these horse to the Training Centers.
  • The device prototypes are primarily made with Arduino, but the final device is manufactured from China.

Industry

User Types

  • Admin
  • Horse Owner
  • Horse Trainer
  • Guest

Purpose

The EHM device has already been has been produced. Which has an RFID tag attached and can monitor vitals of the horse like heart rate, speed, steps etc., and can provide exact GPS co-ordinates.

The main objective is to create a web framework that can display these vitals from the device to the end user in real time with the stats extended with further calculations no matter where the user is on the globe. The framework should be able to display all realtime data, also display the position of horse and other horses on the map, should be able to detect whenever a checkpoint is crossed. It should further store the data and user should be able to revisit he session and even replay it as if it was live. They should also be able to compare data between multiple sessions with the same horse or with the others.

Problem

  • Must store data regarding
    • Customers
    • Training Centers
    • Horse Profile
    • Race Courses
  • Must have a good clean interface to access, view, edit and delete data
  • Racecourse management
    • Should be able to add/edit/delete check points
    • Should show checkpoints
    • Must be able to locate via Google Maps
  • Real-time almost 0-delay, live preview of the Race/Training with horses being shown in Google Maps, and stats calculated in real time.
  • Calculating real time geo-positions, extended stats and checkpoint crossing mechanism in real-time.
  • Replaying races using Training Records
  • Comparing Races/Training Sessions of two records
  • Training records and Training Comparison pages should load fast even if the data is large to fetch.

Solution

  • VaahCMS : For all backend management of Creating, Viewing, Editing or deleting data related to Customers, Horses, Training Centers etc,. While also providing a clean and modern UI and User Experience.
  • The whole framework has to be divided into three parts
    • Equetronic Helpers : Collection of functions containing all heavy calculations that is required to done in real time as well as during data syncing.
    • Equetronic API : An api hosted on Fastify that can receive raw EHM Data from the device and send it for Live Preview via Pusher with the extended stats calculated with Equetronic Helpers. Store the raw data temporarily on Fauna DB
    • Equetronic Dev : The main dashboard build with VaahCMS for the end user to view the Live Preview, View Training Records, Manage Race Courses, Horses, Training Centers, Customers etc.
  • The data will be timely Synced with Fauna DB to store the data in the MySql with calculated stats to so the page load time will be as little as possible
  • Integration of vue2-google-maps with precise calculations when horse crosses any checkpoint.
  • Fusion Charts will be integrated to show all stats in a graph

Project Demo


User Flow

User-Flow

Database Diagram

DB Diagaram

Table of Contents