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