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