donghaeng

Tables (11)

attraction_likes

  • like_id — bigint — Primary key — NOT NULL — PK
  • user_id — varchar(50) — Foreign key → db_user.user_id — NOT NULL — 사용자 ID
  • content_id — int — Foreign key → attractions.content_id — NOT NULL — 관광지 ID
  • created_at — timestamp — 좋아요 누른 시간

attraction_memories

  • memory_id — bigint — Primary key — NOT NULL — PK
  • user_id — varchar(50) — Foreign key → db_user.user_id — NOT NULL — 사용자 ID
  • content_id — int — Foreign key → attractions.content_id — NOT NULL — 관광지 ID
  • visit_date — date — 실제 방문일
  • memory_comment — text — 추억 메모/한줄평
  • memory_image — varchar(255) — 인증샷 이미지 경로
  • created_at — timestamp

attraction_stats

  • content_id — int — Foreign key → attractions.content_id — NOT NULL — 관광지 ID (PK, FK)
  • like_count — int — 좋아요 수
  • visit_count — int — 방문 인증 수 (확장성 고려)
  • updated_at — datetime

attractions

  • no — int — Primary key — NOT NULL
  • content_id — int — NOT NULL
  • title — varchar(500)
  • content_type_id — int — Foreign key → contenttypes.content_type_id
  • area_code — int — Foreign key → sidos.sido_code
  • si_gun_gu_code — int
  • first_image1 — varchar(100)
  • first_image2 — varchar(100)
  • map_level — int
  • latitude — decimal(20,17)
  • longitude — decimal(20,17)
  • tel — varchar(20)
  • addr1 — varchar(100)
  • addr2 — varchar(100)
  • homepage — varchar(1000)
  • overview — varchar(10000)

contenttypes

  • content_type_id — int — Primary key — NOT NULL
  • content_type_name — varchar(45)

db_user

  • user_id — varchar(50) — Primary key — NOT NULL
  • user_password — varchar(255)
  • user_name — varchar(100)
  • user_email — varchar(100)
  • user_role — varchar(100)
  • user_profile_img — varchar(255) — 프로필 이미지 경로
  • refresh — varchar(2048)
  • user_interest_location — varchar(100)

guguns

  • no — int — Primary key — NOT NULL
  • sido_code — int — Foreign key → sidos.sido_code
  • gugun_code — int
  • gugun_name — varchar(20)

my_attractions

  • my_attraction_id — int — Primary key — NOT NULL — PK
  • user_id — varchar(50) — Foreign key → db_user.user_id — NOT NULL — 사용자 ID (FK)
  • content_id — int — Foreign key → attractions.content_id — NOT NULL — 관광지 고유 ID
  • created_at — timestamp — 담은 날짜

plan_details

  • id — bigint — Primary key — NOT NULL
  • plan_id — bigint — Foreign key → plans.plan_id — NOT NULL
  • attraction_no — int — Foreign key → attractions.no — NOT NULL
  • visit_order — int — NOT NULL

plans

  • plan_id — bigint — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL — 계획 제목
  • start_date — date — 여행 시작일
  • end_date — date — 여행 종료일
  • created_at — datetime
  • updated_at — datetime
  • user_id — varchar(50) — Foreign key → db_user.user_id — NOT NULL — 작성자 ID

sidos

  • no — int — Primary key — NOT NULL
  • sido_code — int — NOT NULL
  • sido_name — varchar(20)