michelin

Tables (7)

favorite

  • favorite_id — Primary key — NOT NULL
  • profile_id (user_id) — Foreign key → profile.profile_id — NOT NULL
  • restaurant_id (retaurant_id) — Foreign key → restaurant.restaurant_id — NOT NULL

media

  • media_id — Primary key — NOT NULL
  • title
  • duration
  • file_path
  • restaurant_id (retaurant_id) — Foreign key → restaurant.restaurant_id — NOT NULL

profile (user)

  • profile_id (user_id) — Primary key — NOT NULL
  • id (Key) — Foreign key → user.id — NOT NULL
  • profile_name (user_name)

restaurant

  • restaurant_id (retaurant_id) — Primary key — NOT NULL
  • restaurant_name
  • location
  • cuisine_type
  • rating
  • phone_number
  • price
  • image

user (Untitled)

  • id (Key) — Primary key — NOT NULL
  • pw (Field)

visit

  • visit_id — Primary key — NOT NULL
  • profile_id (user_id) — Foreign key → profile.profile_id — NOT NULL
  • restaurant_id (retaurant_id) — Foreign key → restaurant.restaurant_id — NOT NULL
  • visit_count
  • preference

watch

  • watch_id — Primary key — NOT NULL
  • media_id — Foreign key → media.media_id — NOT NULL
  • profile_id (user_id) — Foreign key → profile.profile_id — NOT NULL
  • progress