Load Readings Schema
The database schema for load readings with filename format : <YYYY-MM-DD-load-readings.sqlite> under a single date subdirectory.
| Table Name | Description |
|---|
W_in | |
W_out | |
cacheable | |
entity_ids | |
maximums | |
metadata | |
schema_version | |
sqlite_sequence | |
W_in
| Attribute | Type | Description |
|---|
id | Integer | |
data | Blob | |
W_out
| Attribute | Type | Description |
|---|
id | Integer | |
data | Blob | |
cacheable
| Attribute | Type | Description |
|---|
id | Integer | |
data | Blob | |
entity_ids
| Attribute | Type | Description |
|---|
id | Integer | |
entity_id | Text | |
maximums
| Attribute | Type | Description |
|---|
id | Integer | |
data | Blob | |
| Attribute | Type | Description |
|---|
key | Text | |
value | Text | |
schema_version
| Attribute | Type | Description |
|---|
version | Text | |
sqlite_sequence
| Attribute | Type | Description |
|---|
name | Text | |
seq | Text | |
Load Readings Index Schema
The database schema for load readings index with filename format : <load-readings-index.sqlite> in the top level ewb data directory.
| Table Name | Description |
|---|
dateRange | |
metadata | |
sqlite_sequence | |
dateRange
| Attribute | Type | Description |
|---|
id | Integer | |
data | Blob | |
| Attribute | Type | Description |
|---|
key | Text | |
value | Text | |
sqlite_sequence
| Attribute | Type | Description |
|---|
name | Text | |
seq | Text | |