Object Data Model

Record:

  id:          String      // unique (PK), only alphanumeric
  latitude:    Number      // between -90 and +90 (inclusive)
  longitude:   Number      // between -180 and +180 (inclusive)
  timestamp:   Date
  driver_id:   String      // reference to Driver
  slip_score:  Number      // between 0 and 100 (inclusive)

Manager:

  id:          String      // unique (PK), only alphanumeric
  name:        String
  company_id:  String      // reference to Company

Driver:

  id:          String      // unique (PK), only alphanumeric
  name:        String
  company_id:  String      // reference to Company

Company:

  id:          String      // unique (PK), only alphanumeric
  name:        String