RawData

bletcher erd prev ver

Tables (3)

Untitled (RawData)

  • Key (id) — int — Primary key — NOT NULL
  • Field (contents) — varchar(80) — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (Devices)

  • Key (id) — int(11) — Primary key — NOT NULL
  • Key (user_id) — int(11) — Foreign key → Untitled.Key — NOT NULL
  • Field (trap_id) — varchar(255)
  • Field (region) — varchar(255)
  • Field (location) — varchar(255)
  • Field (model_name) — varchar(255)
  • Field (is_replacement) — tinyint(1)
  • Field (is_error) — tinyint(1)
  • Field (created_at) — datetime

Untitled (Users)

  • Key (id) — int(11) — Primary key — NOT NULL
  • Field (username) — varchar(255)
  • Field (password) — varchar(255)