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