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)