Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
ust:meeting_minutes_october_4_6_2022 [2022/10/14 00:36] jchang |
ust:meeting_minutes_october_4_6_2022 [2022/10/14 00:37] (current) jchang |
||
|---|---|---|---|
| Line 39: | Line 39: | ||
| * create table apple(time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,press_pa INTEGER,temp_c INTEGER,humidity_centi_pct INTEGER,apogee_w_m2 FLOAT); | * create table apple(time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,press_pa INTEGER,temp_c INTEGER,humidity_centi_pct INTEGER,apogee_w_m2 FLOAT); | ||
| * CREATE TABLE cranberry (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,apogee_w_m2 FLOAT,temp_cK INTEGER,humidity_pct INTEGER,press_pa INTEGER); | * CREATE TABLE cranberry (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,apogee_w_m2 FLOAT,temp_cK INTEGER,humidity_pct INTEGER,press_pa INTEGER); | ||
| + | * CREATE TABLE dragonfruit (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,apogee_w_m2 FLOAT,temp_cK INTEGER,humidity_pct INTEGER,press_pa INTEGER); | ||
| * CREATE TABLE heartbeat (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER); | * CREATE TABLE heartbeat (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER); | ||
| * \d public.apple (shows apple table) | * \d public.apple (shows apple table) | ||