Capstone_Client

bletcher erd prev ver

Tables (4)

Untitled (User)

  • Key (id) — int — Primary key — NOT NULL
  • Field (username) — varchar — NOT NULL
  • Field (password) — varchar — NOT NULL
  • Field2 (device_cnt) — int

Untitled (Notice)

  • Key (id) — int(11) — Primary key — NOT NULL
  • Key (device_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (is_readed) — tinyint — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

Untitled (Device)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field2 (trap_id) — varchar — NOT NULL
  • Field (location) — varchar — NOT NULL
  • Field (region) — varchar — NOT NULL
  • Field (is_replacement) — tinyint
  • Field (is_error) — tinyint
  • Field (created_at) — timestamp — NOT NULL
  • Field (type\)

Untitled (err_Detail)

  • Key (device_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (code) — varchar
  • Field (last_transmission_time) — date — NOT NULL
  • Field (is_expired) — tinyint — NOT NULL