| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| device_type | varchar | MUL | NO | iot/wear/lbs/vid/ptz/cloud |
| device_id | varchar | — | NO | |
| event_type | varchar | — | YES | |
| metric | varchar | — | YES | |
| value | decimal | — | YES | |
| unit | varchar | — | YES | |
| lat | decimal | — | YES | |
| lng | decimal | — | YES | |
| ref_url | varchar | — | YES | 视频/云台/云端资源地址或对象key |
| payload | json | — | YES | |
| occurred_at | datetime | — | YES | |
| received_at | datetime | — | YES | |
| algo | varchar | — | YES |