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