travel_ERD

Tables (7)

PLACES

  • Key (place_id) — PK — Primary key — NOT NULL
  • Field (name) — NN
  • Field3 (address) — NN
  • Field (rating) — NN
  • Field (review_count) — NN
  • Field (thumbnail_url)
  • Field (uploaded_at) — NN
  • Field (tags)

PROFILES

  • Key (user_id) — PK — Primary key — NOT NULL
  • Field (name)
  • Field (email)
  • Field2 (avatar_url)
  • Field (created_at)
  • Field (updated_at)

QA_MESSAGES

  • Key (message_id) — PK — Primary key — NOT NULL
  • Key (session_id) — FK — Foreign key → QA_SESSIONS.Key — NOT NULL
  • Field (role) — NN
  • Field (content) — NN
  • Field (sent_at) — NN

QA_SESSIONS

  • Key (session_id) — PK — Primary key — NOT NULL
  • Key (user_id) — FK — Foreign key → PROFILES.Key — NOT NULL
  • Key (place_id) — FK — Foreign key → PLACES.Key — NOT NULL
  • Field (started_at) — NN

REVIEWS

  • Key (review_id) — PK — Primary key — NOT NULL
  • Key (place_id) — FK — Foreign key → PLACES.Key — NOT NULL
  • Field (summary) — NN
  • Field (tags)
  • Field (positive_count) — NN
  • Field (negative_count) — NN
  • Field (positive_ratio) — NN
  • Field (positive_keywords)
  • Field (negative_keywords)
  • Field (rating)
  • Field (review_count) — NN
  • Field (analyzed_at) — NN

Untitled (FAVORITES)

  • Key (favorite_id) — PK — Primary key — NOT NULL
  • Key (user_id) — FK — Foreign key → PROFILES.Key — NOT NULL
  • Key (place_id) — FK — Foreign key → PLACES.Key — NOT NULL
  • Field (created_at) — NN
  • Field (memo)

Untitled2 (CACHE)

  • Key (cache_id) — PK — Primary key — NOT NULL
  • Key (place_id) — FK — Foreign key → PLACES.Key — NOT NULL
  • Key (review_id) — FK — Foreign key → REVIEWS.Key — NOT NULL
  • Field (cached_at) — NN
  • Field (expires_at) — NN