BUTTON

테이블 (6)

관리자 (ADMINS)

  • (ADMIN_ID) — VARCHAR(40) — 기본 키 — NOT NULL
  • (ADMIN_PW) — VARCHAR(60) — NOT NULL
  • (ADMIN_NAME) — VARCHAR(40)
  • (MOBILE) — VARCHAR(40)
  • (EMAIL) — VARCHAR(100)
  • (JOIN_DATE) — DATE

기기 (DEVICES)

  • PK (ID_DEVICE) — INT — 기본 키 — 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
  • UK (SERIAL_NUM) — VARCHAR(100)
  • (ID_USER) — INT — 외래 키 → 회원.PK — NOT NULL
  • (EMAIL) — VARCHAR(40)

센서 (SENSORS)

  • PK (ID_SENSOR) — INT — 기본 키 — NOT NULL
  • PK (ID_DEVICE) — INT — 외래 키 → 기기.PK — NOT NULL
  • (SWITCH_VALUE) — INT — NOT NULL
  • (UPDATE_DATE) — DATETIME — NOT NULL
  • (SWITCH_ALARM_YN) — INT — NOT NULL
  • (SWITCH_LIMIT) — INT — NOT NULL
  • (COUNT_SWITCH) — INT — NOT NULL
  • (FLAG_COUNT_SWITCH) — INT — NOT NULL
  • (WISH_DATE) — INT — NOT NULL
  • FK (ID_USER) — INT — 외래 키 → 회원.PK — NOT NULL
  • (EMAIL) — VARCHAR(40)

센서로그 (SENSORS_LOG)

  • (SERIAL_NUM) — VARCHAR(100)
  • (SWITCH_VALUE) — INT
  • (UPDATE_DATE) — DATETIME
  • (EMAIL) — VARCHAR(40)

토큰 (TOKEN)

  • PK (ID_TOKEN) — INT — 기본 키 — NOT NULL
  • (TOKEN) — VARCHAR(300) — NOT NULL
  • PK (ID_USER) — INT — 외래 키 → 회원.PK — NOT NULL
  • (EMAIL) — VARCHAR(40)

회원 (USERS)

  • PK (ID_USER) — 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
  • UK (EMAIL) — VARCHAR(40) — NOT NULL