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)