jwIoT

테이블 (9)

DEVICES (devices)

  • PK (ID) — INT — 외래 키 → DEVICES_ORIGIN.PK — NOT NULL
  • (DEVICE_NAME) — VARCHAR(100) — NOT NULL
  • (DEVICE_NAME_ALIAS) — VARCHAR(100) — NOT NULL
  • (INSTALLED_PLACE) — VARCHAR(100) — NOT NULL
  • (INSTALLED_PLACE_DESC) — VARCHAR(100) — NOT NULL
  • FK (ID_USER) — INT — 외래 키 → USERS.PK — NOT NULL

DEVICES_ORIGIN (devices_origin)

  • PK (ID) — INT — 기본 키 — NOT NULL
  • (SERIAL_NUM) — VARCHAR(100)

SENSORS (sensors)

  • Key (ID) — INT — 기본 키 — NOT NULL
  • (NUMBER)
  • (SOC) — FLOAT — NOT NULL
  • (UPDATE_DATE) — DATETIME
  • (ALARM_YN) — INT — NOT NULL
  • (LIMIT) — FLOAT — NOT NULL
  • (COUNT) — INT — NOT NULL
  • (FLAG_COUNT) — INT
  • PK (ID_DEVICE) — INT — 외래 키 → DEVICES.PK — NOT NULL

SENSORS_LOG (sensors_log)

  • (SERIAL_NUM) — VARCHAR(100)
  • (SOC) — FLOAT
  • (UPDATE_DATE) — DATETIME
  • (EMAIL) — VARCHAR(40)

TOKENS (tokens)

  • PK (ID) — INT — 기본 키 — NOT NULL
  • (TOKEN) — VARCHAR(300) — NOT NULL
  • FK (ID_USER) — INT — 외래 키 → USERS.PK — NOT NULL

USERS (users)

  • PK (ID) — INT — 기본 키 — NOT NULL
  • (USER_PW) — VARCHAR(300) — NOT NULL
  • (USER_NAME) — VARCHAR(40) — NOT NULL
  • (MOBILE) — VARCHAR(40) — NOT NULL
  • (JOIN_DATE) — DATETIME — NOT NULL
  • (EMAIL) — VARCHAR(40) — NOT NULL

sensors_info

  • PK (ID) — INT — 기본 키 — NOT NULL
  • (EXPLANATION) — VARCHAR(300)
  • (EXPRESSION_NAME) — VARCHAR(300)
  • (ATTR) — VARCHAR(100)
  • (BYTE_LENGTH) — INT
  • (FORMAT) — VARCHAR(100)
  • (LOW_RANGE) — VARCHAR(100)
  • (HIGH_RANGE) — VARCHAR(100)
  • (SCALE) — FLOAT
  • (DISPLAY_UNIT) — VARCHAR(30)
  • (BLUETOOTH) — VARCHAR(100)

관리자 (admin)

  • PK (ID) — INT — 기본 키 — NOT NULL
  • (ADMINNAME) — VARCHAR(100)
  • (PASSWORD) — VARCHAR(100)
  • (ENABLE) — BOOL

권한 (authority)

  • PK (ID) — INT — 기본 키 — NOT NULL
  • (ADMINNAME) — VARCHAR(100)
  • (AUTHORITY) — VARCHAR(100)
  • PK (ID_ADMIN) — INT — 외래 키 → 관리자.PK — NOT NULL