core Monitor DB
Tables (3)
LocaltionDB (Local)
- ID — INT — Primary key — NOT NULL
- 위치이름 (LocalName) — varchar(100) — NOT NULL
- 위도 (localX) — varchar(150) — NOT NULL
- 경도 (localY) — varchar(150) — NOT NULL
- 위치시간 (localDateTime) — dateTime — NOT NULL
- 온도센서 (temp_sensor) — INT — Foreign key → TempSensor.ID — NOT NULL
- user_id (user_name) — INT — Foreign key → User.ID — NOT NULL
TempSensor (Temp)
- ID — INT — Primary key — NOT NULL
- 온도센서 (TempsensorValue) — varchar(100) — NOT NULL
- 습도 (HumValue) — varchar(100) — NOT NULL
- 날짜시간 (TempDateTime) — dateTime — NOT NULL
- user_id (user_name) — INT — Foreign key → User.ID — NOT NULL
User (Users)
- ID — INT — Primary key — NOT NULL
- 사용자ID (userID) — varchar(15) — NOT NULL
- 사용자PW (userPW) — varchar(20) — NOT NULL
- 사용자이름 (userName) — varchar(30) — NOT NULL