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