| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| 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 |