BRT API

Tables (7)

schema_mapping.sensor_info (센서정보)

  • Sensor Info UUID (siuuid) — UUID — Primary key — NOT NULL
  • User PK (useruuid) — UUID — Foreign key → schema_user.users.User PK — NOT NULL
  • Sensor Name (name) — VARCHAR(150) — NOT NULL
  • Sensor Icon (icon) — TEXT
  • Rester Date (wdate) — DATETIME — NOT NULL

schema_mapping.sensor_mapping (센서매핑)

  • Sensor Mapping UUID (smuuid) — UUID — Primary key — NOT NULL
  • Sensor Info UUID (siuuid) — UUID — Foreign key → schema_mapping.sensor_info.Sensor Info UUID — NOT NULL
  • Node UUID (nodeuuid) — UUID — Foreign key → schema_user.nodes.Node UUID — NOT NULL

schema_user.farms (농장)

  • Farm UUID (farmuuid) — UUID — Primary key — NOT NULL
  • User PK (useruuid) — UUID — Foreign key → schema_user.users.User PK — NOT NULL
  • Farm Name (name) — VARCHAR(150) — NOT NULL
  • Farm Address (address) — TEXT — JSON
  • Farm Phone (phone) — VARCHAR(20)
  • Rester Date (wdate) — DATETIME — NOT NULL

schema_user.nodes (노드)

  • Node UUID (nodeuuid) — UUID — Primary key — NOT NULL
  • Farm UUID (farmuuid) — UUID — Foreign key → schema_user.farms.Farm UUID — NOT NULL
  • Node Name (name) — VARCHAR(150) — NOT NULL
  • Node Description (description) — TEXT
  • Rester Date (wdate) — DATETIME — NOT NULL

schema_user.users (회원)

  • User PK (useruuid) — UUID — Primary key — NOT NULL
  • ID (userid) — VARCHAR(150) — NOT NULL
  • Password (pwd) — VARCHAR(150) — NOT NULL
  • Email (email) — VARCHAR(100) — NOT NULL
  • NickName (nickname) — VARCHAR(50)
  • Phone (phone) — VARCHAR(20)
  • Rester Date (wdate) — DATETIME — NOT NULL

sensor (센서기록)

  • Sensor Info UUID (siuuid) — UUID — Foreign key → schema_mapping.sensor_mapping.Sensor Info UUID — NOT NULL
  • Node UUID (nodeuuid) — UUID — Foreign key → schema_mapping.sensor_mapping.Node UUID — NOT NULL
  • Fields (fields) — fields — NOT NULL — 센서값
  • Time (time) — time

token (인증토큰)

  • Key (useruuid)
  • value (random)