Skip to main content

ERD for DeepVibe DB

Following are the tables and the super-tables created for storing DeepVibe data in both TDEngine local instances and TDEngine cloud

Super-tables​

supertables

Using each of these super-tables, tables are created for each Sensor Node with the name node_<mac addr>_<property>

Table information​

  1. bme280_history
    bme280

  2. latest_fft
    latest fft

  3. latest_ceemdan

    No preview was available at the time of taking the screenshots. Should update later.

  4. accelerometer_history
    sample period is in seconds accel history

  5. latest_acceleration
    dt is in milliseconds latest acceleration

  6. analog_sensor_history
    analog sensor history

  7. ds18b20_history
    ds18b20 history