ㄹㄹ
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