QR_door

Tables (4)

Log_iot (log_iot)

  • Logid (log_id) — INT(11) — Primary key — NOT NULL
  • QR_idx (qr_idx) — INT(4) — NOT NULL
  • time — DATETIME — NOT NULL

Log_web (log_web)

  • Logid (log_id) — INT(11) — Primary key — NOT NULL
  • QR_idx (qr_idx) — INT(4) — NOT NULL
  • time — DATETIME — NOT NULL

QRcode (qrcode)

  • QR_idx (qr_idx) — INT(4) — Primary key — NOT NULL
  • QRdata (qr_data) — VARCHAR(255) — NOT NULL
  • active — TINYINT(1) — NOT NULL

RFID (rfid)

  • RFID_idx (rfid_idx) — INT(4) — Primary key — NOT NULL
  • UID (uid) — INT(4)
  • active — TINYINT(1)