1. query

sqlite3 /opt/domoticz/domoticz.db ".tables"
BackupLog             MobileDevices         Scenes
Cameras               MultiMeter            SetpointTimers
CamerasActiveDevices  MultiMeter_Calendar   SharedDevices
CustomImages          MySensors             Temperature
DeviceStatus          MySensorsChilds       Temperature_Calendar
DeviceToPlansMap      MySensorsVars         TimerPlans
EnOceanNodes          Notifications         Timers
EventMaster           Percentage            ToonDevices
EventRules            Percentage_Calendar   UV
Fan                   Plans                 UV_Calendar
Fan_Calendar          Preferences           UserSessions
Floorplans            PushLink              UserVariables
Hardware              Rain                  Users
LightSubDevices       Rain_Calendar         WOLNodes
LightingLog           SceneDevices          Wind
Meter                 SceneLog              Wind_Calendar
Meter_Calendar        SceneTimers           ZWaveNodes
sqlite3 /opt/domoticz/domoticz.db "pragma table_info('DeviceStatus')"
0|ID|INTEGER|0||1
1|HardwareID|INTEGER|1||0
2|DeviceID|VARCHAR(25)|1||0
3|Unit|INTEGER|0|0|0
4|Name|VARCHAR(100)|0|Unknown|0
5|Used|INTEGER|0|0|0
6|Type|INTEGER|1||0
7|SubType|INTEGER|1||0
8|SwitchType|INTEGER|0|0|0
9|Favorite|INTEGER|0|0|0
10|SignalLevel|INTEGER|0|0|0
11|BatteryLevel|INTEGER|0|0|0
12|nValue|INTEGER|0|0|0
13|sValue|VARCHAR(200)|0|null|0
14|LastUpdate|DATETIME|0|datetime('now','localtime')|0
15|Order|INTEGER BIGINT(10)|0|0|0
16|AddjValue|FLOAT|0|0|0
17|AddjMulti|FLOAT|0|1|0
18|AddjValue2|FLOAT|0|0|0
19|AddjMulti2|FLOAT|0|1|0
20|StrParam1|VARCHAR(200)|0|''|0
21|StrParam2|VARCHAR(200)|0|''|0
22|LastLevel|INTEGER|0|0|0
23|Protected|INTEGER|0|0|0
24|CustomImage|INTEGER|0|0|0
25|Description|VARCHAR(200)|0|''|0
26|Options|TEXT|0|null|0
27|Color|TEXT|0|NULL|0

2. 1 phase

sqlite3 /opt/domoticz/domoticz.db "select * from devicestatus;"
1|2|00082001|1|Phase L1 Current|1|243|23|0|1|12|255|0|3|2022-02-06 00:51:12|1|0.0|1.0|0.0|1.0|||0|0|0|||
2|2|00082002|1|Phase L2 Current|1|243|23|0|1|12|255|0|9|2022-02-06 00:51:12|2|0.0|1.0|0.0|1.0|||0|0|0|||
3|2|00082003|1|Phase L3 Current|1|243|23|0|1|12|255|0|5|2022-02-06 00:51:12|3|0.0|1.0|0.0|1.0|||0|0|0|||
5|2|00082005|1|Phase L1 Voltage|1|243|8|0|1|12|255|0|237|2022-02-06 00:51:12|5|0.0|1.0|0.0|1.0|||0|0|0|||
6|2|00082006|1|Phase L2 Voltage|1|243|8|0|1|12|255|0|228|2022-02-06 00:51:12|6|0.0|1.0|0.0|1.0|||0|0|0|||
7|2|00082007|1|Phase L3 Voltage|1|243|8|0|1|12|255|0|228|2022-02-06 00:51:12|7|0.0|1.0|0.0|1.0|||0|0|0|||
8|2|82008|1|Phase L3 Power|1|248|1|0|1|12|255|0|369|2022-02-06 00:51:12|10|0.0|1.0|0.0|1.0|||0|0|0|||
9|2|82009|1|Phase L1 Power|1|248|1|0|1|12|255|0|106|2022-02-06 00:51:12|8|0.0|1.0|0.0|1.0|||0|0|0|||
10|2|82010|1|Phase L2 Power|1|248|1|0|1|12|255|0|135|2022-02-06 00:51:12|9|0.0|1.0|0.0|1.0|||0|0|0|||
12|3|1|1|Power|1|250|1|0|1|12|255|0|1364;220;0;18;0;0|2022-02-07 23:18:09|12|0.0|1.0|0.0|1.0|||0|0|0|||
13|3|00000001|1|Voltage L1|1|243|8|0|1|12|255|0|228.000|2022-02-07 23:18:09|13|0.0|1.0|0.0|1.0|||0|0|0|||

3. 3 phases

sqlite3 /opt/domoticz/domoticz.db "select * from devicestatus;"
1|3|1|1|Power|1|250|1|0|1|12|255|0|448596;371632;17;354;551;0|2022-02-07 23:18:44|1|0.0|1.0|0.0|1.0|||0|0|0|||
2|3|00000001|1|Voltage L1|0|243|8|0|0|12|255|0|242.300|2022-02-07 23:18:44|2|0.0|1.0|0.0|1.0|||0|0|0|||
3|3|00000002|1|Voltage L2|0|243|8|0|0|12|255|0|0.000|2022-02-07 23:18:44|3|0.0|1.0|0.0|1.0|||0|0|0|||
4|3|00000003|1|Voltage L3|0|243|8|0|0|12|255|0|242.800|2022-02-07 23:18:44|4|0.0|1.0|0.0|1.0|||0|0|0|||
5|3|0000000|1|Usage L1|1|248|1|0|0|12|255|0|254.0|2022-02-07 23:18:44|5|0.0|1.0|0.0|1.0|||0|0|0|||
6|3|0000000|2|Usage L2|1|248|1|0|0|12|255|0|0.0|2022-02-07 23:18:44|6|0.0|1.0|0.0|1.0|||0|0|0|||
7|3|0000000|3|Usage L3|1|248|1|0|0|12|255|0|296.0|2022-02-07 23:18:44|7|0.0|1.0|0.0|1.0|||0|0|0|||
8|3|0000000|4|Delivery L1|0|248|1|0|0|12|255|0|0.0|2022-02-07 23:18:44|8|0.0|1.0|0.0|1.0|||0|0|0|||
9|3|0000000|5|Delivery L2|0|248|1|0|0|12|255|0|0.0|2022-02-07 23:18:44|9|0.0|1.0|0.0|1.0|||0|0|0|||
10|3|0000000|6|Delivery L3|0|248|1|0|0|12|255|0|0.0|2022-02-07 23:18:44|10|0.0|1.0|0.0|1.0|||0|0|0|||
11|3|1|2|Gas|1|251|2|0|1|12|255|0|789984|2022-02-07 23:16:32|11|0.0|1.0|0.0|1.0|||0|0|0|||
12|4|1|1|Weather|1|84|16|0|1|12|255|0|7.1;86;3;1027.6;5|2022-02-07 23:17:53|12|0.0|1.0|0.0|1.0|||0|0|0|||
13|4|2|2|Ground Temperature (10 cm)|0|80|5|0|0|12|255|0|6.8|2022-02-07 23:17:53|13|0.0|1.0|0.0|1.0|||0|0|0|||
14|4|3|3|Feel Temperature|0|80|5|0|0|12|255|0|3.5|2022-02-07 23:17:53|14|0.0|1.0|0.0|1.0|||0|0|0|||
15|4|1|0|Wind|0|86|4|0|0|12|255|0|238.00;WSW;61;93;7.1;3.5|2022-02-07 23:17:53|15|0.0|1.0|0.0|1.0|||0|0|0|||
16|4|1|1|Visibility|0|243|1|0|0|12|255|0|25.0|2022-02-07 23:17:53|16|0.0|1.0|0.0|1.0|||0|0|0|||
17|4|00000201|1|Sun Power|0|243|31|0|0|12|255|0|0.0000|2022-02-07 23:17:53|17|0.0|1.0|0.0|1.0|||0|0|0||1;watt/m2|
18|4|1|0|Rain|0|85|113|0|0|12|255|0|0;0.0|2022-02-07 23:17:53|18|0.0|1.0|0.0|1.0|||0|0|0|||
19|4|0000001|1|Is it Raining|0|17|0|0|0|12|255|0|0|2022-02-06 21:15:06|19|0.0|1.0|0.0|1.0|||0|0|0|||