battery

테이블 (7)

DEVICES_ORIGIN

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

관리자 (ADMINS)

  • PK (ADMIN_ID) — VARCHAR(40) — 기본 키 — NOT NULL
  • (ADMIN_PW) — VARCHAR(300)
  • (ADMIN_NAME) — VARCHAR(40)
  • (MOBILE) — VARCHAR(40)
  • (EMAIL) — VARCHAR(100)
  • (JOIN_DATE) — DATETIME

센서 (SENSORS)

  • Key (ID_SENSOR) — INT — 기본 키 — NOT NULL
  • Key (ID_DEVICE) — INT — 외래 키 → 장비.Key — NOT NULL
  • PK (ID_DEVICE_ORIGIN) — INT — 외래 키 → 장비.PK — NOT NULL
  • UK (SERIAL_NUM) — VARCHAR(100)
  • (BATTERY) — FLOAT — NOT NULL
  • (LIQUID) — FLOAT — NOT NULL
  • (UPDATE_DATE) — DATETIME
  • (BATTERY_ALARM_YN) — INT — NOT NULL
  • (LIQUID_ALARM_YN) — INT — NOT NULL
  • (BATTERY_LIMIT) — FLOAT — NOT NULL
  • (LIQUID_LIMIT) — FLOAT — NOT NULL
  • (COUNT_LIQUID) — INT
  • (COUNT_BATTERY) — INT — NOT NULL
  • (FLAG_COUNT_LIQUID) — INT
  • (FLAG_COUNT_BATTERY) — INT
  • (WISH_DATE) — INT
  • FK (ID_USER) — INT — 외래 키 → 회원.PK — NOT NULL
  • UK (EMAIL) — VARCHAR(40)

센서로그 (SENSORS_LOG)

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

장비 (DEVICES)

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

푸시알림정보 (TOKENS)

  • PK (ID_TOKEN) — INT — 기본 키 — NOT NULL
  • (TOKEN) — VARCHAR(300) — NOT NULL
  • FK (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