Lidar

Tables (8)

auth_refresh_tokens

  • id — BIGSERIAL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL — 토큰을
  • refresh_token — VARCHAR(500) — NOT NULL — 리프레시
  • expires_at — TIMESTAMPTZ — NOT NULL — 토큰
  • created_at — TIMESTAMPTZ — 토큰

companies

  • id — SERIAL
  • company_name — VARCHAR(100) — NOT NULL — 고객사
  • created_at — TIMESTAMPTZ

lidar_grid_configs

  • id — SERIAL
  • sensor_id — INTEGER — Foreign key → lidar_sensors.id — NOT NULL
  • total_boundary — GEOMETRY(POLYGON, 4326) — NOT NULL
  • rows — INTEGER — NOT NULL — 격자
  • cols — INTEGER — NOT NULL — 격자
  • cell_width_m — DOUBLE — 설정한
  • cell_height_m — DOUBLE — 설정한
  • is_active — BOOLEAN — 설정
  • created_at — TIMESTAMPTZ — 설정

lidar_sensors

  • id — SERIAL
  • company_id — INTEGER — Foreign key → companies.id — NOT NULL — 담당
  • sensor_code — VARCHAR(50) — NOT NULL — 센서
  • address — VARCHAR(255) — 센서
  • location — GEOMETRY(POINT, 4326) — 센서
  • azimuth — DOUBLE — 설치
  • fov — DOUBLE — 센서
  • max_range_m — INTEGER — 센서
  • is_active — BOOLEAN — 센서
  • installed_at — TIMESTAMPTZ — 센서

lidar_sessions

  • id — BIGSERIAL
  • sensor_id — INTEGER — Foreign key → lidar_sensors.id — NOT NULL — 데이터를
  • measured_at — TIMESTAMPTZ — NOT NULL — 실제
  • source_filename — VARCHAR(255) — NOT NULL — 원본
  • wind_direction — DOUBLE — 풍향
  • wind_speed — DOUBLE — 풍속
  • rainfall — DOUBLE — 강우량
  • is_vapor_removed — BOOLEAN — 수증기
  • image_url_pm10 — VARCHAR(500) — 생성된
  • image_url_pm25 — VARCHAR(500) — 생성된
  • image_bounds — JSONB — 프론트엔드
  • created_at — TIMESTAMPTZ — 데이터가

pollution_stats_area

  • id — BIGSERIAL
  • session_id — BIGINT — Foreign key → lidar_sessions.id — NOT NULL — 측정
  • zone_id — INTEGER — Foreign key → zone_definitions.id — NOT NULL — 분석
  • pm10_avg — DOUBLE — 구역
  • pm10_max — DOUBLE — 구역
  • pm25_avg — DOUBLE — 구역
  • pm25_max — DOUBLE — 구역
  • point_count — INTEGER — 통계

users

  • id — SERIAL
  • company_id — INTEGER — Foreign key → companies.id — NOT NULL — 담당
  • assigned_sensor_id — INTEGER — Foreign key → lidar_sensors.id — 담당
  • user_id — VARCHAR(50) — NOT NULL — 로그인
  • password_hash — VARCHAR(255) — NOT NULL — 로그인
  • email — VARCHAR(100) — 알림
  • phone_number — VARCHAR(20) — 알림
  • role — VARCHAR(20) — NOT NULL — 사용자
  • alert_boundary — GEOMETRY(MULTIPOLYGON, 4326) — 사용자가
  • alert_threshold_pm10 — INTEGER — 사용자별
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

zone_definitions

  • id — SERIAL
  • company_id — INTEGER — Foreign key → companies.id — NOT NULL — 담당
  • zone_name — VARCHAR(50) — NOT NULL — 구역
  • boundary — GEOMETRY(MULTIPOLYGON, 4326) — NOT NULL — 구역의
  • is_active — BOOLEAN — 구역
  • created_at — TIMESTAMPTZ — 구역