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)