capstone

Tables (6)

Place (place)

  • id (contents_id) — int — Primary key — NOT NULL
  • 장소 이름 (title) — varchar
  • 소개 (introduction) — varchar
  • 주소 (address) — varchar
  • 도로명주소 (road_address) — varchar
  • 전화번호 (phone_num) — varchar
  • 장소 컨셉 (context) — varchar
  • 사진아이디 (photo_id) — int — Foreign key → photo.사진아이디 — NOT NULL
  • 감성 분석 점수 (Sentiment_score) — int

Review (review)

  • review_id — int — Primary key — NOT NULL
  • id (contents_id) — int — Foreign key → Place.id — NOT NULL
  • 리뷰 (review_contents) — varchar

Untitled2

  • review_id — int — Foreign key → Review.review_id — NOT NULL
  • id (contents_id) — int — Foreign key → Review.id — NOT NULL
  • emotion1 — varchar
  • emotiom2 — varchar
  • emotion3 — varchar

photo

  • 사진아이디 (photo_id) — int — Primary key — NOT NULL
  • Image_path (image_path) — varchar
  • 썸네일 주소 (thumbnail_path) — varchar

place_generate_context (Untitled3)

  • 생성된 문장 (generate_context) — varchar
  • id (contents_id) — int — Foreign key → Place.id — NOT NULL

place_keyword (Untitled)

  • id (contents_id) — int — Foreign key → Place.id — NOT NULL
  • keyword1 — varchar
  • keyword2 — varchar
  • keyword3 — varchar