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"}