Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
ust:meeting_minutes_november_22_24_2022 [2022/11/22 23:25] jchang [Updates] |
ust:meeting_minutes_november_22_24_2022 [2022/12/05 23:22] (current) jchang [Updates] |
||
---|---|---|---|
Line 5: | Line 5: | ||
**November 22, 2022** | **November 22, 2022** | ||
* New simplified schema -> using the one last semester's team is coming up with | * New simplified schema -> using the one last semester's team is coming up with | ||
+ | * CREATE TABLE weather_node ( | ||
+ | weatherbox INTEGER, | ||
+ | node_addr INTEGER, | ||
+ | overflow_num INTEGER, | ||
+ | uptime_ms BIGINT, | ||
+ | n INTEGER, | ||
+ | batt_mv INTEGER, | ||
+ | panel_mv INTEGER, | ||
+ | bme280_pressure_pascals INTEGER, | ||
+ | bme280_temperature_kelvin INTEGER, | ||
+ | bme280_humidity_percent INTEGER, | ||
+ | apogee_w_m2 FLOAT, | ||
+ | sp215_irradiance_watts_per_square_meter BIGINT | ||
+ | ) | ||
* Create an SQL file (or migration script) to add the new table | * Create an SQL file (or migration script) to add the new table | ||
* Test this new table locally | * Test this new table locally | ||
Line 14: | Line 28: | ||
| | ||
**November 24, 2022** | **November 24, 2022** | ||
+ | ** Troubleshot with Apple and Guava | ||