new chan
Tables (18)
app_user
- user_id — BIGINT — Primary key — NOT NULL
- country_id — BIGINT — Foreign key → country.country_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- preferred_language_code — VARCHAR(10) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
brand
- brand_id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → category.category_id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- description — JSON
- logo_url — VARCHAR(1000)
- status — VARCHAR(20) — NOT NULL
- tel — VARCHAR(20)
category
- category_id — BIGINT — Primary key — NOT NULL
- parent_category_id — BIGINT — Foreign key → category.category_id
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL — {"ko":"여성패션","en":"Women"}
- depth — INT — NOT NULL
celebrity_brand
- celebrity_brand_id — BIGINT — Primary key — NOT NULL
- brand_id — BIGINT — Foreign key → brand.brand_id — NOT NULL
- celebrity_name — VARCHAR(50) — NOT NULL
- celebrity_image_url — VARCHAR(1000)
comment
- comment_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- user_id — BIGINT — Foreign key → app_user.user_id — NOT NULL
- contents — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
country
- country_id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(10) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- default_language_code — VARCHAR(10) — NOT NULL
- domain_host — VARCHAR(255) — NOT NULL
- status — VARCHAR(20) — NOT NULL
course
- course_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → app_user.user_id — 시스템 추천 코스는 NULL
- source_course_id — BIGINT — Foreign key → course.course_id — 복사해온 원본 코스
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- creation_type — VARCHAR(10) — NOT NULL
- share_code — VARCHAR(10) — NOT NULL
- view_count — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
course_place
- course_place_id — BIGINT — Primary key — NOT NULL
- course_id — BIGINT — Foreign key → course.course_id — NOT NULL
- place_id — BIGINT — Foreign key → place.place_id — NOT NULL
- visit_order — INT — NOT NULL
- recommendation_reason — TEXT
- visit_status — VARCHAR(30) — NOT NULL
- visited_at — DATETIME
floor
- floor_id — BIGINT — Primary key — NOT NULL
- floor_code — VARCHAR(30) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- sort_order — INT — NOT NULL
news_feed
- news_feed_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- slug — VARCHAR(500) — NOT NULL
- representative_image_url — VARCHAR(1000)
- body — LONGTEXT — NOT NULL
- created_at — DATETIME — NOT NULL
place
- place_id — BIGINT — Primary key — NOT NULL
- floor_id — BIGINT — Foreign key → floor.floor_id — NOT NULL
- brand_id — BIGINT — Foreign key → brand.brand_id — NOT NULL
- category_id — BIGINT — Foreign key → category.category_id
- navigation_key — VARCHAR(100) — NOT NULL
- place_type — VARCHAR(30) — NOT NULL
- name — VARCHAR(200) — NOT NULL
- description — VARCHAR(1000)
- business_hours — JSON
- image_url — VARCHAR(1000)
- operation_status — VARCHAR(30) — NOT NULL
popup
- popup_id — BIGINT — Primary key — NOT NULL
- place_id — BIGINT — Foreign key → place.place_id — NOT NULL
- brand_id — BIGINT — Foreign key → brand.brand_id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- description — VARCHAR(1000)
- image_url — VARCHAR(1000)
- starts_at — DATETIME — NOT NULL
- ends_at — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
post
- post_id — BIGINT — Primary key — NOT NULL
- course_id — BIGINT — Foreign key → course.course_id — 코스 공유 없이 글만 쓸 수 있음
- user_id — BIGINT — Foreign key → app_user.user_id — NOT NULL
- content — TEXT — NOT NULL
- likes_count — INT — NOT NULL
- save_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
post_image
- post_image_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- object_key — VARCHAR(500) — NOT NULL — S3 객체 키 (버킷명/도메인 제외)
- sort_order — INT — NOT NULL
product
- product_id — BIGINT — Primary key — NOT NULL
- brand_id — BIGINT — Foreign key → brand.brand_id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- image_url — VARCHAR(1000)
- product_url — VARCHAR(1000)
trend_rank
- trend_rank_id — BIGINT — Primary key — NOT NULL
- trend_snapshot_id — BIGINT — Foreign key → trend_snapshot.trend_snapshot_id — NOT NULL
- trend_type_id — BIGINT — Foreign key → trend_type.trend_type_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- ranking — INT — NOT NULL
- interest_score — DECIMAL(10, 4)
- is_visible — BOOLEAN — NOT NULL
trend_snapshot
- trend_snapshot_id — BIGINT — Primary key — NOT NULL
- country_id — BIGINT — Foreign key → country.country_id — NOT NULL
- period_start — DATE — NOT NULL
- period_end — DATE — NOT NULL
- period_type — VARCHAR(30) — NOT NULL
- collected_at — DATETIME — NOT NULL
trend_type
- trend_type_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL — {"ko":"가수","en":"Singer"}