Sensor

Tables (3)

sensor

  • id — bigserial — Primary key — NOT NULL — auto increment
  • type — varchar(15) — NOT NULL — 센서 종류 (온도, 습도, 강우량, 풍속, 풍향)
  • port — smallint — NOT NULL

sensor_data

  • id — bigserial — Primary key — NOT NULL — AUTO INCREMENT
  • msg_time — timstamp — NOT NULL — 센서 데이터 수집 시각
  • temperature — decimal
  • humidity — decimal
  • rain — decimal
  • wind_speed — decimal
  • wind_direction — varchar(10)
  • ant_height — decimal
  • power_ac — varchar(5)
  • power_dc — varchar(5)
  • 센서 ID (sensor_id) — bigint — Foreign key → sensor.id — NOT NULL — auto increment
  • Field

sensor_setting

  • id — bigserial — Primary key — NOT NULL — auto increment
  • applied_at — timestamp — NOT NULL
  • interval — smallint — NOT NULL — s
  • 센서 ID (sensor_id) — bigint — Foreign key → sensor.id — NOT NULL — auto increment