MqttSimulator
Tables (4)
tbl_client (Untitled3)
- id (PK) — int — Primary key — NOT NULL
- cpu_id (UK) — string — NOT NULL
- project_id (Field3) — int
- sub_topic (Field4) — string
- pub_topic (Field) — string
tbl_client_protocol (Untitled5)
- id (PK) — int — Primary key — NOT NULL
- client_id (FK) — int — Foreign key → tbl_client.id — NOT NULL
- protocol_id (FK2) — int — Foreign key → tbl_protocol.id — NOT NULL
- custom_json (Field) — string
- interval_ms (Field3) — int
- is_use (Field2) — int
tbl_message_log (Untitled6)
- id (PK) — int — Primary key — NOT NULL
- client_protocol_id (FK) — int — Foreign key → tbl_client_protocol.id — NOT NULL
- created_at (Field) — datetime
- payload (Field2) — string
tbl_protocol (Untitled4)
- id (PK) — int — Primary key — NOT NULL
- protocol_name (Field) — string