LMN_TEST

Tables (10)

tbl_alarm (CopyOfCopyOfCopyOfUntitled22)

  • dt (Key) — Primary key — NOT NULL
  • id (sub) — 센서id
  • floor (Field) — 층
  • sector (Field2) — 구역
  • msg — 알림내용
  • type — 상황코드 혹은 종류
  • Field3

tbl_c_hr (CopyOfCopyOfUntitled2)

  • id (prime) — 센서id — Primary key — NOT NULL
  • floor (Field) — 층
  • sector (Field2) — 구역
  • yyyy — 연
  • mm — 월
  • dd — 일
  • tt — 시
  • co2_mean (ppm) — 이산화탄소(시간평균)

tbl_electric_day (CopyOfCopyOfCopyOfCopyOfUntitled)

  • id (prime) — 센서id — Primary key — NOT NULL
  • id (prime2) — 센서id — Foreign key → tbl_entire_day.id — NOT NULL
  • floor (Field) — 층
  • sector (Field2) — 구역
  • date (yyyymmddhhmmss) — 시간
  • watt_curr (watt h) — 순간전력소비
  • watt_total (watt) — 누적전력소비

tbl_entire_day (CopyOfCopyOfCopyOfCopyOfUntitled2)

  • id (prime) — 센서id — Primary key — NOT NULL
  • floor (Field) — 층
  • sector (Field2) — 구역
  • date (yyyymmddhhmmss) — 시간
  • flow_curr (m3h) — 순간유량
  • flow_total (m3) — 누적유량

tbl_raw_cth (CopyOfUntitled)

  • id (prime) — 센서id — Primary key — NOT NULL
  • floor (Field) — 층
  • sector (Field2) — 구역
  • date (yyyymmddhhmmss) — 시간
  • co2 (ppm) — 이산화탄소
  • temp (c) — 온도
  • humi (%) — 습도

tbl_raw_electric (CopyOfCopyOfCopyOfUntitled)

  • id (prime) — 센서id — Primary key — NOT NULL
  • floor (Field) — 층
  • sector (Field2) — 구역
  • date (yyyymmddhhmmss) — 시간
  • watt_curr (watt h) — 순간전력소비
  • watt_total (watt) — 누적전력소비

tbl_raw_th (Untitled)

  • id (prime) — 센서id — Primary key — NOT NULL
  • floor (Field) — 층
  • sector (Field2) — 구역
  • date (yyyyMMdd HHmmss) — 시간
  • temp (c) — 온도
  • humi (%) — 습도

tbl_raw_water (CopyOfCopyOfUntitled)

  • id (prime) — 센서id — Primary key — NOT NULL
  • floor (Field) — 층
  • sector (Field2) — 구역
  • date (yyyymmddhhmmss) — 시간
  • flow_curr (m3h) — 순간유량
  • flow_total (m3) — 누적유량

tbl_water_day (CopyOfCopyOfCopyOfUntitled2)

  • id (prime) — 센서id — Primary key — NOT NULL
  • id (prime2) — 센서id — Foreign key → tbl_entire_day.id — NOT NULL
  • floor (Field) — 층
  • sector (Field2) — 구역
  • date (yyyymmddhhmmss) — 시간
  • flow_curr (m3h) — 순간유량
  • flow_total (m3) — 누적유량

tbl_weather_api (Untitled2)

  • date (Key) — Primary key — NOT NULL