diff options
Diffstat (limited to 'ebus-racket/doc')
| -rw-r--r-- | ebus-racket/doc/database-schema.sql | 18 | ||||
| -rw-r--r-- | ebus-racket/doc/sample_dump_1_1min.bin | bin | 0 -> 1300 bytes |
2 files changed, 18 insertions, 0 deletions
diff --git a/ebus-racket/doc/database-schema.sql b/ebus-racket/doc/database-schema.sql new file mode 100644 index 0000000..281659c --- /dev/null +++ b/ebus-racket/doc/database-schema.sql @@ -0,0 +1,18 @@ +CREATE TABLE sensor ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + name TEXT, + description TEXT +); +CREATE TABLE value ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + "timestamp" timestamp without time zone, + sensor_id integer, + type TEXT, + value_float real, + value_int integer, + value_string TEXT, + FOREIGN KEY(sensor_id) REFERENCES sensor(id) +); +CREATE INDEX sensor_idx_001 on sensor(id); +CREATE INDEX sensor_idx_002 on sensor(name); +CREATE INDEX value_idx_001 on value(sensor_id, timestamp); diff --git a/ebus-racket/doc/sample_dump_1_1min.bin b/ebus-racket/doc/sample_dump_1_1min.bin Binary files differnew file mode 100644 index 0000000..f0ec73e --- /dev/null +++ b/ebus-racket/doc/sample_dump_1_1min.bin |