| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| tenant_id | bigint | — | NO | |
| merchant_id | bigint | — | YES | |
| store_id | bigint | MUL | YES | |
| device_no | varchar | UNI | NO | |
| name | varchar | — | YES | |
| type | varchar | — | YES | POS/DOOR/GATEWAY/SENSOR/PRINTER/SCALE |
| status | varchar | — | YES | |
| meta | varchar | — | YES | |
| last_seen | datetime | — | YES | |
| created_at | datetime | — | YES | |
| group_id | bigint | — | YES |