travel

Tables (16)

BookMark (사용자 북마크)

  • bookmark_id (PK) — INT — Primary key — NOT NULL
  • user_id (유저) — INT — Foreign key → User.user_id — NOT NULL
  • place_id (여행지) — INT — Foreign key → Place.place_id — NOT NULL

Categories (모든카테고리)

  • category_id (PK) — INT — Primary key — NOT NULL
  • category_name (카테고리이름) — VARCHAR(45)
  • content_type_id (타입코드) — VARCHAR(45)

Comment (리뷰댓글)

  • comment_id (PK) — INT — Primary key — NOT NULL
  • user_id (작성자) — INT — Foreign key → User.user_id — NOT NULL
  • review_id (리뷰) — INT — Foreign key → Review.review_id — NOT NULL
  • contents (내용) — VARCHAR(100)
  • created_at (작성일) — TIMESTAMP

Follow (팔로우)

  • follow_id (PK) — INT — Primary key — NOT NULL
  • user_id (유저) — INT — Foreign key → User.user_id — NOT NULL
  • following_user_id (팔로잉) — INT
  • follower_user_id (팔로워) — INT

Keywords (모든키워드)

  • keyword_id (PK) — INT — Primary key — NOT NULL
  • name (키워드이름) — VARCHAR(45)

Picture (마이페이지 대표 사진)

  • picture_id (PK) — INT — Primary key — NOT NULL
  • user_id (유저) — INT — Foreign key → User.user_id — NOT NULL
  • region_id (지역) — INT — Foreign key → Region.region_id — NOT NULL
  • image — VARCHAR(255)

Place (여행지)

  • place_id (PK) — INT — Primary key — NOT NULL
  • category_id (카테고리) — INT — Foreign key → Categories.category_id — NOT NULL
  • region_id (지역) — INT — Foreign key → Region.region_id — NOT NULL
  • addr (주소) — VARCHAR(49)
  • title (여행지이름) — VARCHAR(49)
  • image (여행지사진) — VARCHAR(255)
  • max (x좌표) — VARCHAR(49)
  • mapy (y좌표) — VARCHAR(45)
  • score (평점) — INT
  • content_id (여행지id) — INT
  • overview (개요) — VARCHAR(500)

Place_keywords

  • place_keywords_id (PK) — INT — Primary key — NOT NULL
  • keyword_id (키워드) — INT — Foreign key → Keywords.keyword_id — NOT NULL
  • place_id (여행지) — INT — Foreign key → Place.place_id — NOT NULL

Region (지역선택)

  • region_id (PK) — INT — Primary key — NOT NULL
  • area_code (지역코드) — INT
  • do_gwangyaksi (도/광역시) — VARCHAR(45)

Review (마이페이지 여행 기록)

  • review_id (PK) — INT — Primary key — NOT NULL
  • place_id (PK2) — INT — Foreign key → Place.place_id — NOT NULL
  • user_id (PK3) — INT — Foreign key → User.user_id — NOT NULL
  • category_id (PK22) — INT — Foreign key → Place.category_id — NOT NULL
  • region_id (PK32) — INT — Foreign key → Place.region_id — NOT NULL
  • contents (게시글내용) — VARCHAR(500)
  • image (게시글이미지) — VARCHAR(255)
  • score (평점) — INT
  • created_at (게시글작성일) — TIMESTAMP
  • visited_at (여행지방문일) — VARCHAR(100)

User (사용자)

  • user_id (PK) — INT — Primary key — NOT NULL
  • id (아이디) — VARCHAR(16) — NOT NULL
  • pw (비밀번호) — VARCHAR(16) — NOT NULL
  • nickname (닉네임) — VARCHAR(20)
  • image (프로필사진) — String

User_categories (유저카테고리)

  • user_category_idㅔ (PK) — INT — Primary key — NOT NULL
  • user_id (유저) — INT — Foreign key → User.user_id — NOT NULL
  • category_id (카테고리) — INT — Foreign key → Categories.category_id — NOT NULL

User_keywords (유저키워드)

  • Key (PK) — INT — Primary key — NOT NULL
  • user_id (유저) — INT — Foreign key → User.user_id — NOT NULL
  • keyword_id (키워드) — INT — Foreign key → Keywords.keyword_id — NOT NULL

User_place (유저방문지역)

  • visited_id (PK) — INT — Primary key — NOT NULL
  • user_id (유저) — INT — Foreign key → User.user_id — NOT NULL
  • place_id (여행지) — INT — Foreign key → Place.place_id — NOT NULL
  • category_id (카테고리) — INT — Foreign key → Place.category_id — NOT NULL
  • region_id (지역) — INT — Foreign key → Place.region_id — NOT NULL

chat_bot (챗봇데이터)

  • chat_id (PK) — INT — Primary key — NOT NULL
  • review_id (PK2) — INT — Foreign key → Review.review_id — NOT NULL
  • place_id (PK22) — INT — Foreign key → Review.place_id — NOT NULL
  • user_id (PK3) — INT — Foreign key → Review.user_id — NOT NULL
  • category_id (PK222) — INT — Foreign key → Review.category_id — NOT NULL
  • region_id (PK32) — INT — Foreign key → Review.region_id — NOT NULL
  • chat_comment (챗봇내용) — VARCHAT(500)

review_like (좋아요)

  • like_id (PK) — INT — Primary key — NOT NULL
  • user_id (유저) — INT — Foreign key → User.user_id — NOT NULL
  • review_id (리뷰) — INT — Foreign key → Review.review_id — NOT NULL