ㅇㅇ

Tables (25)

ACCOMMODATION

  • accommodation_id — BIGINT — Primary key — NOT NULL
  • source_id — VARCHAR(100) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(500) — NOT NULL
  • latitude — DECIMAL(10,7) — NOT NULL
  • longitude — DECIMAL(10,7) — NOT NULL

ADMIN_AREA

  • sgg_cd — VARCHAR(20) — Primary key — NOT NULL
  • sido_name — VARCHAR(50) — NOT NULL
  • sigungu_name — VARCHAR(50) — NOT NULL
  • dong_name — VARCHAR(100) — NOT NULL

AUTH_SESSION

  • session_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • refresh_token_hash — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL

CODE

  • code_value — VARCHAR(50) — Primary key — NOT NULL
  • group_code — VARCHAR(30) — Foreign key → CODE_GROUP.group_code — NOT NULL
  • code_name — VARCHAR(100) — NOT NULL

CODE_GROUP

  • group_code — VARCHAR(30) — Primary key — NOT NULL
  • group_name — VARCHAR(100) — NOT NULL

COMMUNITY_COMMENT

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → COMMUNITY_POST.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

COMMUNITY_POST

  • post_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id
  • post_type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

COMPANION

  • companion_seq — INT — Primary key — NOT NULL
  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • relation_code — VARCHAR(50) — NOT NULL
  • gender_code — VARCHAR(50) — NOT NULL
  • age_group_code — VARCHAR(50) — NOT NULL

EMAIL_VERIFICATION

  • verification_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • purpose — VARCHAR(30) — NOT NULL
  • code_verifier — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • failed_count — INT — NOT NULL
  • used_at — DATETIME
  • created_at — DATETIME — NOT NULL

POI

  • poi_id — BIGINT — Primary key — NOT NULL
  • poi_name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(500) — NOT NULL
  • latitude — DECIMAL(10,7) — NOT NULL
  • longitude — DECIMAL(10,7) — NOT NULL
  • category_code — VARCHAR(50) — NOT NULL
  • region_id — BIGINT — Foreign key → REGION.region_id — NOT NULL
  • description — TEXT — NOT NULL
  • image_url — VARCHAR(1000) — NOT NULL

POI_SOURCE_MAP

  • source_system — VARCHAR(50) — Primary key — NOT NULL
  • source_version — VARCHAR(50) — Primary key — NOT NULL
  • source_poi_id — VARCHAR(100) — Primary key — NOT NULL
  • poi_id — BIGINT — Foreign key → POI.poi_id — NOT NULL

RECOMMENDATION_REQUEST

  • request_id — BIGINT — Primary key — NOT NULL
  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • input_version — INT — NOT NULL
  • model_version — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

RECOMMENDATION_RESULT

  • request_id — BIGINT — Foreign key → RECOMMENDATION_REQUEST.request_id — NOT NULL
  • poi_id — BIGINT — Foreign key → POI.poi_id — NOT NULL
  • rank_no — INT — NOT NULL
  • score — DECIMAL(12,6) — NOT NULL

REGION

  • region_id — BIGINT — Primary key — NOT NULL
  • region_code — VARCHAR(20) — NOT NULL
  • region_name — VARCHAR(50) — NOT NULL

ROUTE_DAY

  • route_day_id — BIGINT — Primary key — NOT NULL
  • route_id — BIGINT — Foreign key → TRAVEL_ROUTE.route_id — NOT NULL
  • day_no — INT — NOT NULL
  • travel_date — DATE — NOT NULL
  • primary_region_id — BIGINT — Foreign key → REGION.region_id — NOT NULL

ROUTE_SPOT

  • route_spot_id — BIGINT — Primary key — NOT NULL
  • route_day_id — BIGINT — Foreign key → ROUTE_DAY.route_day_id — NOT NULL
  • poi_id — BIGINT — Foreign key → POI.poi_id — NOT NULL
  • visit_order — INT — NOT NULL

SOCIAL_ACCOUNT

  • social_account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

TRAVEL

  • travel_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • travel_no — INT — NOT NULL
  • travel_name — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • region_mode — VARCHAR(20) — NOT NULL
  • age_group_snapshot — VARCHAR(50) — NOT NULL
  • gender_snapshot — VARCHAR(50) — NOT NULL
  • input_version — INT — NOT NULL
  • adopted_route_id — BIGINT — Foreign key → TRAVEL_ROUTE.route_id
  • adopted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

TRAVEL_BOOKMARK

  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • poi_id — BIGINT — Foreign key → POI.poi_id — NOT NULL

TRAVEL_FEEDBACK

  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • route_id — BIGINT — Foreign key → TRAVEL_ROUTE.route_id — NOT NULL
  • execution_status — VARCHAR(20) — NOT NULL
  • satisfaction_score — TINYINT
  • answered_at — DATETIME — NOT NULL

TRAVEL_FEEDBACK_REASON

  • travel_id — BIGINT — Foreign key → TRAVEL_FEEDBACK.travel_id — NOT NULL
  • reason_text — VARCHAR(50) — NOT NULL

TRAVEL_PREFERENCE

  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • travel_style_1 — TINYINT — NOT NULL
  • travel_style_2 — TINYINT — NOT NULL
  • travel_style_3 — TINYINT — NOT NULL
  • travel_style_4 — TINYINT — NOT NULL
  • travel_style_5 — TINYINT — NOT NULL
  • travel_style_6 — TINYINT — NOT NULL
  • travel_motive — VARCHAR(50) — NOT NULL
  • user_mission — VARCHAR(255) — NOT NULL
  • income_code — TINYINT — NOT NULL

TRAVEL_REGION

  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • region_id — BIGINT — Foreign key → REGION.region_id — NOT NULL

TRAVEL_ROUTE

  • route_id — BIGINT — Primary key — NOT NULL
  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • route — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

USER

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender_code — VARCHAR(50)
  • status — VARCHAR(30) — NOT NULL
  • withdrawn_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME