DB for mvp(umc_4thMission)

Tables (7)

Alarm (Untitled4)

  • alarm_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • cafe_id (Key22) — Foreign key → User.cafe_id — NOT NULL
  • mission_id (Key222) — Foreign key → User.mission_id — NOT NULL
  • user_id (Key2222) — Foreign key → User.user_id — NOT NULL
  • mission_id (Field)
  • review_id (Field2)
  • alarm_activate (Field3)

FnQ (Untitled3)

  • user_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • cafe_id (Key22) — Foreign key → User.cafe_id — NOT NULL
  • mission_id (Key222) — Foreign key → User.mission_id — NOT NULL
  • user_id (Key2222) — Foreign key → User.user_id — NOT NULL
  • topic (Field)
  • created_date (Field2)
  • content (Field3)
  • image (Field4)
  • faq_type (Field5)
  • faq_completeYN (Field6)
  • Field7

Image (Untitled6)

  • image_id (Key) — Primary key — NOT NULL
  • review_id (Key2) — Foreign key → Review.review_id — NOT NULL
  • user_id (Key22) — Foreign key → Review.user_id — NOT NULL
  • cafe_id (Key222) — Foreign key → Review.cafe_id — NOT NULL
  • mission_id (Key2222) — Foreign key → Review.mission_id — NOT NULL
  • user_id (Key22222) — Foreign key → Review.user_id — NOT NULL
  • alarm_id (Key3) — Foreign key → Review.alarm_id — NOT NULL
  • user_id (Key23) — Foreign key → Review.user_id — NOT NULL
  • cafe_id (Key223) — Foreign key → Review.cafe_id — NOT NULL
  • mission_id (Key2223) — Foreign key → Review.mission_id — NOT NULL
  • user_id (Key222222) — Foreign key → Review.user_id — NOT NULL
  • user_id (Key4) — Foreign key → FnQ.user_id — NOT NULL
  • user_id (Key24) — Foreign key → FnQ.user_id — NOT NULL
  • cafe_id (Key224) — Foreign key → FnQ.cafe_id — NOT NULL
  • mission_id (Key2224) — Foreign key → FnQ.mission_id — NOT NULL
  • user_id (Key22223) — Foreign key → FnQ.user_id — NOT NULL

Mission (Untitled2)

  • mission_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • cafe_id (Key22) — Foreign key → User.cafe_id — NOT NULL
  • mission_id (Key222) — Foreign key → User.mission_id — NOT NULL
  • user_id (Key2222) — Foreign key → User.user_id — NOT NULL
  • cafe_id (Field)
  • cost (Field2)
  • success_YN (Field3)
  • ceo_id (Field4)

Restaurant (Untitled5)

  • cafe_id (Key) — Primary key — NOT NULL
  • mission_id (Key2) — Foreign key → Mission.mission_id — NOT NULL
  • user_id (Key22) — Foreign key → Mission.user_id — NOT NULL
  • cafe_id (Key222) — Foreign key → Mission.cafe_id — NOT NULL
  • mission_id (Key2222) — Foreign key → Mission.mission_id — NOT NULL
  • user_id (Key22222) — Foreign key → Mission.user_id — NOT NULL

Review (Untitled)

  • review_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • cafe_id (Key22) — Foreign key → User.cafe_id — NOT NULL
  • mission_id (Key222) — Foreign key → User.mission_id — NOT NULL
  • user_id (Key2222) — Foreign key → User.user_id — NOT NULL
  • alarm_id (Key3) — Foreign key → Alarm.alarm_id — NOT NULL
  • user_id (Key23) — Foreign key → Alarm.user_id — NOT NULL
  • cafe_id (Key223) — Foreign key → Alarm.cafe_id — NOT NULL
  • mission_id (Key2223) — Foreign key → Alarm.mission_id — NOT NULL
  • user_id (Key22222) — Foreign key → Alarm.user_id — NOT NULL
  • rating (Field)
  • food_catg (Field2)
  • cafe_name (Field3)
  • cafe_id (Field4)
  • content (Field5)
  • image (Field6)

User

  • user_id (Key) — Primary key — NOT NULL
  • cafe_id (Key2) — Foreign key → Restaurant.cafe_id — NOT NULL
  • mission_id (Key22) — Foreign key → Restaurant.mission_id — NOT NULL
  • user_id (Key222) — Foreign key → Restaurant.user_id — NOT NULL
  • name (varchar(100))
  • gender (Field2)
  • birth (Field3)
  • address (Field4)
  • email (Field5)
  • phone (Field6)
  • point (Field7)