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