ㄹㄹ

Tables (26)

ACCOMMODATION

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

ADMIN_AREA

  • emd_cd — CHAR(8) — Primary key — NOT NULL
  • sido_name — VARCHAR(30) — NOT NULL
  • sigungu_name — VARCHAR(30) — NOT NULL
  • dong_name — VARCHAR(30) — 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
  • post_type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

COMPANION

  • companion_seq — SMALLINT — Primary key — NOT NULL
  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • relation_code — TINYINT — NOT NULL
  • gender_code — TINYINT — NOT NULL
  • age_group_code — TINYINT — 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

POI

  • poi_id — BIGINT — Primary key — NOT NULL
  • poi_name — VARCHAR(200) — 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 — TINYINT — Foreign key → REGION.region_id — NOT NULL
  • description — TEXT — NOT NULL
  • image_url — VARCHAR(2048) — NOT NULL

POI_PREFERENCE

  • poi_id — BIGINT — Foreign key → POI.poi_id — NOT NULL
  • preference_id — BIGINT — Foreign key → PREFERENCE.preference_id — NOT NULL

POI_SOURCE_MAP

  • source_poi_id — VARCHAR(255) — Primary key — NOT NULL
  • poi_id — BIGINT — Foreign key → POI.poi_id — NOT NULL

PREFERENCE

  • preference_id — BIGINT — Primary key — NOT NULL
  • preference_code — VARCHAR(50) — NOT NULL
  • preference_name — VARCHAR(100) — NOT NULL
  • response_type — VARCHAR(30) — NOT NULL
  • min_value — INT
  • max_value — INT
  • low_label — VARCHAR(100)
  • high_label — VARCHAR(100)

PREFERENCE_OPTION

  • option_value — INT — Primary key — NOT NULL
  • preference_id — BIGINT — Foreign key → PREFERENCE.preference_id — NOT NULL
  • option_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)

REGION

  • region_id — TINYINT — Primary key — NOT NULL
  • region_code — VARCHAR(20) — NOT NULL
  • region_name — VARCHAR(20) — 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 — SMALLINT — NOT NULL
  • travel_date — DATE — NOT NULL
  • primary_region_id — TINYINT — 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 — SMALLINT — NOT NULL

SOCIAL_ACCOUNT

  • social_account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • provider — VARCHAR(20) — 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 — TINYINT — 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_ROUTE.travel_id — NOT NULL
  • route_id — BIGINT — Foreign key → TRAVEL_ROUTE.route_id — NOT NULL
  • execution_status — VARCHAR(20) — NOT NULL
  • satisfaction_score — TINYINT — NOT NULL
  • answered_at — DATETIME — NOT NULL

TRAVEL_FEEDBACK_REASON

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

TRAVEL_PREFERENCE

  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • preference_id — BIGINT — Foreign key → PREFERENCE_OPTION.preference_id — NOT NULL
  • answer_value — INT — Foreign key → PREFERENCE_OPTION.option_value — NOT NULL

TRAVEL_REGION

  • travel_id — BIGINT — Foreign key → TRAVEL.travel_id — NOT NULL
  • region_id — TINYINT — 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 — VARCHAR(1000) — 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 — TINYINT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • withdrawn_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME