졸업프로젝트

테이블 (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