LaMPS database documentation
- Reinhard Mayr (Unlicensed)
Owned by Reinhard Mayr (Unlicensed)
Disclaimer
This is a documentation of the internal LaMPS SQL database. The database structure may be subject to change without prior announcement.
Vendor-specific details follow the notation #<communication object no>[.<bit position>]. Please consult technical product documentation for details.
Table lamps_test_result_latest
Common fields
| col# | name | description |
|---|---|---|
| 1 | id | test result id |
| 2 | date | timestamp of receiving the result |
| 3 | test_id | FK to lamps_test |
| 4 | device_id | FK to lamps_device |
| 5 | test_type |
|
Fields related to regular DALI tests
| col# | name | description | ABB DG/S 1.1 | ABB DG/Sx.64.1.1 | ABB DGN/S1.16.1 | EAE DA 100, DA 110 | Insta, Gira, Hager, Jung, Eelectron | HDL | Ipas, MDT, Merten, Schneider, B.E.G. | Siemens N 141/02 | Siemens N 141/03, /21, /31, Legrand | Zennio |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | test_succeeded | the gateway responded within the configured device time | #3.8 or gw timeout | |||||||||
| 7 | fault_ballast | #16 | #21.9 | #20.9 | #3.9 | #1544.9 | non-disclosed | #ES.7 | #11.7 | #37.9 | #11.9 | |
| 8 | fault_lamp | #15 | #21.8 | #20.8 | #3.10 | #1544.8 | non-disclosed | #ES.6 | #11.6 | #37.8 | #11.8 | |
| 11 | fault_converter | N/A | #21.10 | #20.10 | N/A | #1544.10 | N/A | N/A | N/A | #37.10 | N/A |
- #ES: Error status communication object. Refer to documentation of the used gateway version for the specific CO#.
Fields related to DALI emergency test
| col# | name | description | ABB DG/Sx.64.1.1 | ABB DGN/S1.16.1 | EAE DA 100, DA 110 | Insta, Gira, Hager, Jung, Eelectron | Ipas, MDT, Merten, Schneider, B.E.G. | Siemens N 141/02 | Siemens N 141/03, /21, /31, Legrand |
|---|---|---|---|---|---|---|---|---|---|
| 9 | test_fault | emergency test failed | #42.11 | #33.11 | N/A | #432.3 | #CTR.3 | #147.3 | #608.3 |
| 10 | fault_battery | #42.17 | #33.17 | #3.14 | #432.9 | #CTR.9 | #147.9 | #608.9 | |
| 11 | fault_converter | #42.16 | #33.16 | #3.16 | #432.8 | #CTR.8 | #147.8 | #608.8 | |
| 12 | fault_emergency_light | #42.19 | #33.19 | N/A | #432.11 | #CTR.11 | #147.11 | #608.11 | |
| 13 | battery_defect | #42.18 | #33.18 | #3.15 | #432.10 | #CTR.10 | #147.10 | #608.10 | |
| 14 | function_test_failed | #42.22 | #33.22 | #3.17 | #432.14 | #CTR.14 | #147.14 | #608.14 | |
| 15 | duration_test_failed | #42.23 | #33.23 | #3.18 | #432.15 | #CTR.15 | #147.15 | #608.15 | |
| 16 | max_time_function_test_exceeded | #42.20 | #33.20 | N/A | #432.12 | #CTR.12 | #147.12 | #608.12 | |
| 17 | max_time_duration_test_exceeded | #42.21 | #33.21 | N/A | #432.13 | #CTR.13 | #147.13 | #608.13 | |
| 18 | value | quantitative test result | #42.24-31 | #33.24-31 | N/A | #432.16-23 | #CTR.16-23 | #147.16-23 | #608.16-23 |
- #CTR: Converter test result communication object. Refer to documentation of the used gateway version for the specific CO#.