trail_map

Tables (15)

app_user

  • user_id — bigint — Primary key — NOT NULL — 사용자_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • display_name — varchar(100) — 사용자_표시명
  • auth_provider — varchar(50) — 인증_제공자
  • auth_subject — varchar(255) — 인증_주체_식별자
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz

course

  • course_id — bigint — Primary key — NOT NULL — 코스_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • mountain_id — bigint — Foreign key → mountain.mountain_id — NOT NULL — 산_식별자
  • course_name — varchar(200) — NOT NULL — 코스_명
  • course_geometry — GEOMETRY — NOT NULL — 코스_경로 | PostgreSQL: geometry(LineString,4326)
  • course_difficulty — varchar(30) — 코스_난이도
  • official_distance_meters — DOUBLE — 공식_거리_미터 | PostgreSQL: double precision
  • official_duration_seconds — integer — 공식_예상_소요시간_초
  • course_version — integer — NOT NULL — 코스_버전
  • source_id — bigint — Foreign key → data_source.source_id — NOT NULL — 출처_식별자
  • source_record_id — varchar(200) — 원본_레코드_식별자
  • source_date — date — 원본_기준일
  • source_hash — varchar(64) — NOT NULL — 원본_해시
  • imported_at — DATETIME — NOT NULL — 적재_일시 | PostgreSQL: timestamptz
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz

course_analysis

  • analysis_id — bigint — Primary key — NOT NULL — 분석_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • course_id — bigint — Foreign key → course.course_id — NOT NULL — 코스_식별자
  • course_version — integer — NOT NULL — 코스_버전
  • dem_source_id — bigint — Foreign key → data_source.source_id — NOT NULL — DEM_출처_식별자
  • algorithm_version — varchar(100) — NOT NULL — 알고리즘_버전
  • analyzed_course_geometry — GEOMETRY — NOT NULL — 분석_대상_경로 | PostgreSQL: geometry(LineString,4326)
  • source_type — varchar(30) — NOT NULL — 출처_유형
  • distance_meters — DOUBLE — 거리_미터 | PostgreSQL: double precision
  • estimated_duration_seconds — integer — 예상_소요시간_초
  • max_elevation_meters — DOUBLE — 최고_고도_미터 | PostgreSQL: double precision
  • min_elevation_meters — DOUBLE — 최저_고도_미터 | PostgreSQL: double precision
  • elevation_gain_meters — DOUBLE — 누적_상승고도_미터 | PostgreSQL: double precision
  • elevation_loss_meters — DOUBLE — 누적_하강고도_미터 | PostgreSQL: double precision
  • steep_section_ratio_percent — DOUBLE — 급경사_비율_퍼센트 | PostgreSQL: double precision
  • quality_status — varchar(30) — NOT NULL — 품질_상태
  • calculated_at — DATETIME — 계산_일시 | PostgreSQL: timestamptz
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz

course_review

  • review_id — bigint — Primary key — NOT NULL — 후기_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • user_id — bigint — Foreign key → app_user.user_id — NOT NULL — 사용자_식별자
  • course_id — bigint — Foreign key → course.course_id — NOT NULL — 코스_식별자
  • review_content — text — NOT NULL — 후기_내용
  • visited_date — date — 방문일
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz

data_source

  • source_id — bigint — Primary key — NOT NULL — 출처_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • source_name — varchar(200) — NOT NULL — 출처_명
  • provider_name — varchar(200) — 제공기관_명
  • source_url — varchar(2000) — 원문_URL
  • source_format — varchar(30) — NOT NULL — 원본_형식
  • source_crs — varchar(100) — 원본_좌표계
  • source_version — varchar(100) — 원본_버전
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz

facility

  • facility_id — bigint — Primary key — NOT NULL — 시설_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • mountain_id — bigint — Foreign key → mountain.mountain_id — 산_식별자
  • facility_name — varchar(200) — 시설_명
  • facility_type — varchar(40) — NOT NULL — 시설_유형
  • facility_location — GEOMETRY — NOT NULL — 시설_위치 | PostgreSQL: geometry(Point,4326)
  • official_status — varchar(100) — 공식_상태
  • source_id — bigint — Foreign key → data_source.source_id — NOT NULL — 출처_식별자
  • source_record_id — varchar(200) — 원본_레코드_식별자
  • source_date — date — 원본_기준일
  • source_hash — varchar(64) — NOT NULL — 원본_해시
  • imported_at — DATETIME — NOT NULL — 적재_일시 | PostgreSQL: timestamptz
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz

facility_report

  • facility_report_id — bigint — Primary key — NOT NULL — 시설_제보_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • facility_id — bigint — Foreign key → facility.facility_id — NOT NULL — 시설_식별자
  • user_id — bigint — Foreign key → app_user.user_id — NOT NULL — 사용자_식별자
  • report_type — varchar(40) — NOT NULL — 시설_제보_유형
  • visited_date — date — NOT NULL — 방문일
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz

hike_record

  • hike_record_id — bigint — Primary key — NOT NULL — 등산_기록_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • schedule_id — bigint — Foreign key → hike_schedule.schedule_id — NOT NULL — 일정_식별자
  • user_id — bigint — Foreign key → app_user.user_id — NOT NULL — 사용자_식별자
  • course_id — bigint — Foreign key → course.course_id — NOT NULL — 코스_식별자
  • course_version — integer — NOT NULL — 코스_버전
  • recorded_course_geometry — GEOMETRY — NOT NULL — 기록_기준_코스_경로 | PostgreSQL: geometry(LineString,4326)
  • started_at — DATETIME — NOT NULL — 시작_일시 | PostgreSQL: timestamptz
  • ended_at — DATETIME — 종료_일시 | PostgreSQL: timestamptz
  • hike_status — varchar(30) — NOT NULL — 등산_진행_상태
  • traveled_distance_meters — DOUBLE — 이동거리_미터 | PostgreSQL: double precision
  • actual_duration_seconds — integer — 실제_소요시간_초
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz

hike_schedule

  • schedule_id — bigint — Primary key — NOT NULL — 일정_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • user_id — bigint — Foreign key → app_user.user_id — NOT NULL — 사용자_식별자
  • course_id — bigint — Foreign key → course.course_id — NOT NULL — 코스_식별자
  • scheduled_starts_at — DATETIME — NOT NULL — 등산_예정_시작_일시 | PostgreSQL: timestamptz
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz

mountain

  • mountain_id — bigint — Primary key — NOT NULL — 산_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • mountain_name — varchar(200) — NOT NULL — 산_명
  • mountain_display_location — GEOMETRY — NOT NULL — 산_표시_위치 | PostgreSQL: geometry(Point,4326)
  • mountain_boundary — GEOMETRY — 산_영역 | PostgreSQL: geometry(MultiPolygon,4326)
  • source_id — bigint — Foreign key → data_source.source_id — NOT NULL — 출처_식별자
  • source_record_id — varchar(200) — 원본_레코드_식별자
  • source_date — date — 원본_기준일
  • source_hash — varchar(64) — NOT NULL — 원본_해시
  • imported_at — DATETIME — NOT NULL — 적재_일시 | PostgreSQL: timestamptz
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz

mountain_review

  • review_id — bigint — Primary key — NOT NULL — 후기_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • user_id — bigint — Foreign key → app_user.user_id — NOT NULL — 사용자_식별자
  • mountain_id — bigint — Foreign key → mountain.mountain_id — NOT NULL — 산_식별자
  • review_content — text — NOT NULL — 후기_내용
  • visited_date — date — 방문일
  • rating — DECIMAL — 평점 | PostgreSQL: numeric
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz

photo

  • photo_id — bigint — Primary key — NOT NULL — 사진_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • user_id — bigint — Foreign key → app_user.user_id — NOT NULL — 사용자_식별자
  • mountain_review_id — bigint — Foreign key → mountain_review.review_id — 산_후기_식별자
  • course_review_id — bigint — Foreign key → course_review.review_id — 코스_후기_식별자
  • spot_review_id — bigint — Foreign key → spot_review.review_id — 스팟_후기_식별자
  • spot_id — bigint — Foreign key → user_spot.spot_id — 스팟_식별자
  • object_key — varchar(1024) — NOT NULL — 객체_키
  • original_file_name — varchar(255) — NOT NULL — 원본_파일명
  • media_type — varchar(100) — NOT NULL — 미디어_유형
  • file_size_bytes — bigint — NOT NULL — 파일_크기_바이트
  • display_order — integer — NOT NULL — 표시_순서
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz

saved_course

  • saved_course_id — bigint — Primary key — NOT NULL — 담은_코스_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • user_id — bigint — Foreign key → app_user.user_id — NOT NULL — 사용자_식별자
  • course_id — bigint — Foreign key → course.course_id — NOT NULL — 코스_식별자
  • saved_at — DATETIME — NOT NULL — 저장_일시 | PostgreSQL: timestamptz
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz

spot_review

  • review_id — bigint — Primary key — NOT NULL — 후기_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • user_id — bigint — Foreign key → app_user.user_id — NOT NULL — 사용자_식별자
  • spot_id — bigint — Foreign key → user_spot.spot_id — NOT NULL — 스팟_식별자
  • review_content — text — NOT NULL — 후기_내용
  • visited_date — date — 방문일
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz

user_spot

  • spot_id — bigint — Primary key — NOT NULL — 스팟_식별자 | PostgreSQL: GENERATED ALWAYS AS IDENTITY
  • user_id — bigint — Foreign key → app_user.user_id — NOT NULL — 사용자_식별자
  • mountain_id — bigint — Foreign key → mountain.mountain_id — 산_식별자
  • hike_record_id — bigint — Foreign key → hike_record.hike_record_id — 등산_기록_식별자
  • spot_type — varchar(40) — NOT NULL — 스팟_유형
  • spot_location — GEOMETRY — NOT NULL — 스팟_위치 | PostgreSQL: geometry(Point,4326)
  • spot_name — text — 스팟_이름
  • spot_status — varchar(40) — NOT NULL — 스팟_상태
  • created_at — DATETIME — NOT NULL — 생성_일시 | PostgreSQL: timestamptz
  • updated_at — DATETIME — NOT NULL — 수정_일시 | PostgreSQL: timestamptz
  • deleted_at — DATETIME — 삭제_일시 | PostgreSQL: timestamptz