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