SmartHome DB (졸프이후)

테이블 (5)

DEVICE_STATE (Device State)

  • DEVICE_CD (Key) — SEED — 기본 키 — NOT NULL
  • DEVICE_NM (State Value) — VARCHAR(255)
  • DEVICE_VAL (Field) — TINYINT(1)

DUST_INFO (Untitled2)

  • COLLECT_SEQ (Key) — SEED — 기본 키 — NOT NULL
  • DUST (Field) — INT
  • COLLECT_TIME (Field2) — DATETIME

MODE

  • MODE_CD (Mode_Code) — VARCHAR(255) — 기본 키 — NOT NULL
  • MODE_NM (mode_name) — VARCHAR(255) — NOT NULL — UNIQUE
  • MODE_STATE (Field) — TINYINT
  • TIMER (set_timer) — INT
  • SUNLIGHT (set_sunlight) — VARCHAR(255)
  • DUST (set_dust) — INT(11)
  • NUM_PERSON (set_person) — INT(11)
  • VALVE (.) — TINYINT
  • CLEANER (Field3) — TINYINT
  • LIGHT (Field4) — TINYINT
  • BLIND (Field5) — TINYINT
  • WINDOW (Field6) — TINYINT

MOTION_INFO (Untitled)

  • SENSOR_SEQ (Key) — SEED — 기본 키 — NOT NULL
  • MOTION_A (Field) — INT
  • MOTION_B (Field2) — INT
  • A_TIME (Field3) — DATETIME
  • B_TIME (Field4) — DATETIME
  • Field5 — INT

SUNLIGHT_INFO (Sensor_info)

  • SENSOR_SEQ (seq) — SEED — 기본 키 — NOT NULL
  • SUNLIGHT (sunlight) — INT
  • MEASURE_TIME (Field) — DATETIME