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 — 구역