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)