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