travel_point
Tables (5)
FavoritesTable (Favorites)
- favorite_id (fid) — BIGINT — Primary key — NOT NULL
- user_id (uid) — BIGINT — Foreign key → UserTable.user_id — NOT NULL
- tour_id (tid) — BIGINT — Foreign key → TourTable.tour_id — NOT NULL
FestivalsTable (Festivals)
- festival_id (fid) — BIGINT — Primary key — NOT NULL
- festival_name (name) — VARCHAR(100)
- festival_location (location) — DOUBLE
- tour_description (description) — VARCHAR(300)
- festival_date (date) — DATETIME
ReviewTable (Review)
- review_id (rid) — BIGINT — Primary key — NOT NULL
- created_at (created) — DATETIME
- like_count (like) — INT
- description_text (description) — VARCHAR(255)
- image_url (image) — VARCHAR(255)
- user_id (uid) — BIGINT — Foreign key → UserTable.user_id — NOT NULL
- tour_id (tid) — BIGINT — Foreign key → TourTable.tour_id — NOT NULL
- festival_id (fid) — BIGINT — Foreign key → FestivalsTable.festival_id — NOT NULL
TourTable (Tour)
- tour_id (tid) — BIGINT — Primary key — NOT NULL
- tour_name (name) — VARCHAR(100)
- tour_location (location) — DOUBLE
- tour_description (description) — VARCHAR(300)
- tour_weather (weather) — ??
UserTable (user)
- user_id (uid) — BIGINT — Primary key — NOT NULL
- user_name (name) — VARCHAR(50)
- profile_image_url (profile_url) — VARCHAR(255)
- authentication_type (type) — VARCHAR(50)
- user_email (email) — VARCHAR(100)