umc

Tables (8)

Copy Of Restaurant (CopyOf식당)

  • restaurant_key (식당번호) — NOTNULL — Primary key — NOT NULL
  • restaurant_name (식당이름) — NOTNULL
  • category (카테고리) — NOTNULL
  • restaurant_img (식당사진) — NOTNULL
  • restaurant_info (식당소개) — NOTNULL
  • video_link (유튜브영상) — NULL
  • place (위치) — NOTNULL
  • menu (메뉴) — NOTNULL

Copy Of Review (CopyOf리뷰)

  • review_id (리뷰번호) — NOTNULL — Primary key — NOT NULL
  • user_id (유저번호) — NOTNULL — Foreign key → Copy Of User.user_id — NOT NULL
  • restaurant_key (식당번호) — NOTNULL — Foreign key → Copy Of Restaurant.restaurant_key — NOT NULL
  • like (가게평가) — NOTNULL
  • after_tv (유지중) — NOTNULL
  • keyword (키워드) — NOTNULL
  • best_menu (최고메뉴) — NOTNULL

Copy Of User (CopyOf유저)

  • user_id (유저번호) — NOTNULL — Primary key — NOT NULL
  • nickname (닉네임) — NOTNULL
  • email (이메일) — NOTNULL

Menu (메뉴)

  • menu_id (메뉴번호) — NOTNULL — Primary key — NOT NULL
  • ML_id (메뉴리스트번호) — NOTNULL — Foreign key → MenuList.ML_id — NOT NULL
  • restaurant_key (식당번호) — NOTNULL — Foreign key → MenuList.restaurant_key — NOT NULL
  • menu_img (메뉴사진) — NULL
  • menu_name (메뉴이름) — NOTNULL

MenuList (메뉴리스트)

  • ML_id (메뉴리스트번호) — NOTNULL — Primary key — NOT NULL
  • restaurant_key (식당번호) — NOTNULL — Foreign key → Restaurant.restaurant_key — NOT NULL

Restaurant (식당)

  • restaurant_key (식당번호) — NOTNULL — Primary key — NOT NULL
  • restaurant_name (식당이름) — NOTNULL
  • category (카테고리) — NOTNULL
  • restaurant_img (식당사진) — NOTNULL
  • restaurant_info (식당소개) — NOTNULL
  • video_link (유튜브영상) — NULL
  • place (위치) — NOTNULL

Review (리뷰)

  • review_id (리뷰번호) — NOTNULL — Primary key — NOT NULL
  • user_id (유저번호) — NOTNULL — Foreign key → User.user_id — NOT NULL
  • restaurant_key (식당번호) — NOTNULL — Foreign key → Restaurant.restaurant_key — NOT NULL
  • like (가게평가) — NOTNULL
  • after_tv (유지중) — NOTNULL
  • keyword (키워드) — NOTNULL
  • best_menu (최고메뉴) — NOTNULL

User (유저)

  • user_id (유저번호) — NOTNULL — Primary key — NOT NULL
  • nickname (닉네임) — NOTNULL
  • email (이메일) — NOTNULL