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