졸업프로젝트
테이블 (4)
KeywordMonthlySummary (keyword)
- keyword_id (PK) — Long — 기본 키 — NOT NULL
- place_id (PK4) — Long — 외래 키 → Place.place_id — NOT NULL
- month — String
- family_count (familyCount) — int
- couple_count (coupleCount) — int
- friend_count (friendCount) — int
- alone_count (aloneCount) — int
- healing_count (healingCount) — int
- walk_count (walkCount) — int
- picnic_count (picnicCount) — int
- hiking_count (hikingCount) — int
- beach_count (beachCount) — int
- tour_count (tourCount) — int
- shopping_count (shoppingCount) — int
- museum_count (museumCount) — int
- kids_count (kidsCount) — int
- food_count (foodCount) — int
- flower_count (flowerCount) — int
- night_view_count (nightViewCount) — int
- exercise_count (exerciseCount) — int
Place (place)
- place_id (PK) — Long — 기본 키 — NOT NULL
- region — varchar
- name — varchar
- address — varchar
- latitude — double precision
- longitude — double precision
- photo_url (photoUrl) — varchar
Review (reviews)
- review_id (PK) — Long — 기본 키 — NOT NULL
- saMonthlySummary_id (PK2) — Long — 외래 키 → SAMonthlySummary.saMonthlySummary_id — NOT NULL
- keyword_id (PK3) — Long — 외래 키 → KeywordMonthlySummary.keyword_id — NOT NULL
- month — int
- date — varchar
- content — varchar
- mood — Enum
- transport — Enum
- congestion — Enum
- infra — Enum
- keyword — varchar
SAMonthlySummary (saMonthlySummary)
- saMonthlySummary_id (PK) — Long — 기본 키 — NOT NULL
- place_id (PK2) — Long — 외래 키 → Place.place_id — NOT NULL
- month — int
- mood_positive_number (moodPositiveNumber) — int
- mood_negative_number (moodNegativeNumber) — int
- mood_netural_number (moodNeturalNumber) — int
- transport_positive_number (transportPositiveNumber) — int
- transport_negative_number (transportNegativeNumber) — int
- transport_neutral_number (transportNeutralNumber) — int
- congestion_positive_number (congestionPositiveNumber) — int
- congestion_negative_number (congestionNegativeNumber) — int
- congestion_neutral_number (congestionNeutralNumber) — int
- infra_positive_number (infraPositiveNumber) — int
- infra_negative_number (infraNegativeNumber) — int
- infra_neutral_number (infraNeutralNumber) — int