DGMIF_Health monitoring

DGMIF_Health monitoring

Tables (4)

Device_Info

  • Sensor_ID — Varchar(10) — Primary key — NOT NULL
  • Num — int(11)
  • MAC_addr — Varchar(12)
  • Tx_interval — Varchar(10)
  • Resolution — Varchar(10)
  • Sample_rate — Varchar(10)
  • Amp_gain — Varchar(10)
  • Tx_power — Varchar(10)
  • Adv_interval — Varchar(10)
  • Adv_timeout — Varchar(10)
  • Battery — varchar(3)

Gateway_info

  • Gateway_ID — Varchar(10) — Primary key — NOT NULL
  • Floor — Varchar(3)
  • Room — Varchar(3)

Sensor_data

  • Num — int(11) — Primary key — NOT NULL
  • Time — datetime
  • Sensor_ID — Varchar(10) — Foreign key → Device_Info.Sensor_ID — NOT NULL
  • User_ID — Varchar(10) — Foreign key → User_info.User_ID — NOT NULL
  • Gateway_ID (Gateway_ID2) — Varchar(10) — Foreign key → Gateway_info.Gateway_ID — NOT NULL
  • Data — Varchar(16)

User_info

  • User_ID — Varchar(10) — Primary key — NOT NULL
  • Num — int(11)
  • Password — Varchar(10)
  • Name — Varchar(255)
  • Email — Varchar(100)
  • Phone — Varchar(20)
  • Type — Varchar(20)
  • Permit — Varchar(6)