smartIoT

테이블 (6)

DEVICE (Device)

  • DEVICE_CD (Device_Code) — VARCHAR(255) — 기본 키 — NOT NULL
  • DEVICE_NM (Device_Name) — VARCHAR(255)

DEVICE_STATE (Device State)

  • STATE_CD (State_Code) — VARCHAR(255) — 기본 키 — NOT NULL
  • DEVICE_CD (Device_Code) — VARCHAR(255) — 외래 키 → DEVICE.DEVICE_CD — NOT NULL
  • SEQ (seq) — SEED — 외래 키 → SUNLIGHT_SENSOR_INFO.SUNLGIHT_SEQ — NOT NULL
  • STATE_ NM (State Name) — VARCHAR(255)
  • STATE_VALUE (State Value) — VARCHAR(255)

MODE

  • MODE_CD (Mode_Code) — VARCHAR(255) — 기본 키 — NOT NULL
  • MODE_STATE_CD — VARCHAR(255) — 기본 키 — NOT NULL
  • DEVICE_CD (Device_Code) — VARCHAR(255) — 외래 키 → DEVICE.DEVICE_CD — NOT NULL
  • MODE_NM (mode_name) — VARCHAR(255)
  • TIMER (set_timer) — VARCHAR(255)
  • SUNLIGHT (set_sunlight) — VARCHAR(255)
  • DUST (set_dust) — INT(11)
  • NUM_PERSON (set_person) — INT(11)
  • MODE_STATE_NM (Mode_State_Name) — VARCHAR(255)

SUNLIGHT_SENSOR_INFO (Sensor_info)

  • SUNLGIHT_SEQ (seq) — SEED — 기본 키 — NOT NULL
  • SUNLIGHT (sunlight) — INT(11)
  • MOTION_1 (motion1) — INT(11)
  • MOTION_2 (motion2) — INT(11)
  • DUST (Dust) — INT(11)

상태2 (Situation2)

  • S_Code (Static Code) — VARCHAR(255) — 기본 키 — NOT NULL
  • C_Time (Current Time) — INT(11)

장치1 (Device1)

  • TYPE (Type) — VARCHAR(255) — 기본 키 — NOT NULL
  • S_Code (Static Code) — VARCHAR(255) — 외래 키 → 상태2.S_Code — NOT NULL
  • STATE_Name (STATE Name) — VARCHAR(255)
  • S_Value (Static Value) — VARCHAR(255)