Data Documentation
Find below a list of our data tables.
All imported data will either directly imported or converted into this structure.
Data which can not directly map onto existing columns is collected in the custom json column.
More documentation and information for prospect users can be found in the
Prospect wiki
| agents | All our Agents (Installers/Sales Agents) |
|---|---|
| customers | All our Customers |
| installations | All Installations of our devices. This could be an SHS, a grid, a meter, etc. |
| installations_ts | Time Series data of individual devices |
| paygo_accounts_snapshots_ts | Time Series data of events processed from meters_ts |
| payments_ts | Payment time series data for SHS Accounts or Meter Accounts |
| trust_trace | Trust Trace - the results of data validations and checks on subjects from other tables. Populated by data processors. |
| custom | This tables saves completely custom data as json. For easier export and graphing per source views with customizable structure are automatically created. |