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)