Table Types
Table Types
Detailed reference documentation for all four Machbase table types. Each section provides complete syntax, features, and advanced usage patterns.
Table Types
- Tag Tables - Sensor/device time-series data
- Log Tables - Event streams and logs
- Volatile Tables - In-memory real-time data
- Lookup Tables - Reference and master data
Quick Reference
| Type | Create Syntax | Best For |
|---|---|---|
| Tag | CREATE TAGDATA TABLE | Sensor data (ID, time, value) |
| Log | CREATE TABLE | Events, logs, flexible schema |
| Volatile | CREATE VOLATILE TABLE | Real-time cache, sessions |
| Lookup | CREATE LOOKUP TABLE | Device registry, config |
For a comprehensive comparison and decision guide, see Table Types Overview.
Last updated on