test

bletcher erd prev ver

Tables (5)

Copy Of Untitled (TPU)

  • Key (id) — varchar(30) — Primary key — NOT NULL
  • Field (trap_id) — varchar(30)
  • Field2 (trap_id_type) — int
  • Key (payload_id) — varchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (MPU)

  • Key (id) — Primary key — NOT NULL
  • Field (time) — varchar(30)
  • Field (lqi) — int
  • Field (mpu_index) — varchar(30)
  • Field (is_device) — boolean
  • Key (tpu_id) — varchar(30) — Foreign key → Copy Of Untitled.Key — NOT NULL

Untitled (Payload)

  • Key (id) — varchar(30) — Primary key — NOT NULL
  • Field (cmd) — varchar(30)
  • Field (item) — varchar(30)
  • Field (data_type) — varchar(30)
  • id (data_id) — varchar(30) — Foreign key → posts.id — NOT NULL

posts (Data)

  • id — varchar(30) — Primary key — NOT NULL
  • Field (pest_capture) — varchar(50)
  • text (pest_temperature) — varchar(30)
  • Field (pest_sensor_duty) — varchar(30)
  • Field (pest_pan_duty) — varchar(30)
  • Field2 (pest_pan_rpm) — varchar(30)
  • Field3 (pest_status_code) — varchar(30)
  • Field (snapshot_image_data) — varchar(30)
  • Field (snapshot_image_index) — int
  • Field (mouseCycle_capture) — varchar(30)
  • Field (mouseCycle_voltage) — varchar(30)
  • Field (mouseCycle_rssi) — varchar(30)
  • Field (mouseCycle_status_code) — varchar(30)
  • Field (mouseWarning_inclination) — varchar(30)
  • Field (mouseWarning_power) — varchar(30)
  • Field (mouseWarning_voltage) — varchar(30)
  • Field (mouseWarning_flag) — varchar(30)
  • Field (mouseWarning_capture) — varchar(30)
  • Field (damWarning_temperature) — varchar(30)
  • Field (damWarning_vibration) — varchar(30)
  • Field (damWarning_power) — varchar(30)

user (SPU)

  • username (id) — varchar(30) — Primary key — NOT NULL
  • username (notice_id) — varchar(30)
  • Field (raw_data) — varchar(255)
  • password (version) — varchar(10)
  • Field (dam_id) — varchar(30)
  • Field (dam_id_type) — varchar(30)
  • Field3 (spu_index) — int
  • Key (mpu_id) — varchar(30) — Foreign key → Untitled.Key — NOT NULL