켑스톤

테이블 (4)

Measure

  • time (Key) — TIMESTAMP — 기본 키 — NOT NULL
  • SensorNumber — Integer — 외래 키 → Sensor.SensorNumber — NOT NULL
  • CoValue — DOUBLE
  • co2Value — DOUBLE
  • fireValue — DOUBLE
  • temperature — DOUBLE

Sensor

  • SensorNumber — Integer — 기본 키 — NOT NULL
  • UserID — varchar(40) — 외래 키 → User.UserID — NOT NULL
  • SensorLocation — varchar(40)

User

  • UserID — varchar(40) — 기본 키 — NOT NULL
  • UserPass — varchar(40)
  • UserEmail (Field2) — varchar(40)
  • UserNumber (Field3) — varchar(40)
  • Useraddress — varchar(40)

Waterpump

  • count — NUMBER — 기본 키 — NOT NULL
  • SensorNumber — Integer — 외래 키 → Sensor.SensorNumber — NOT NULL
  • time — DATE
  • run — Integer