UMC_0_week

Tables (11)

event

  • id (Key) — Primary key — NOT NULL
  • start_date (Field)
  • end_date (Field2)
  • title (Field3)
  • comment (Field4)

food

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

member

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • gender (Field2)
  • birth (Field3)
  • adress (Field4)
  • kakao (Field5)
  • naver (Field6)
  • apple (Field7)
  • google (Field8)
  • inactive_date (Field9)
  • created_at (Field10)
  • updated_at (Field11)
  • mission_count (Field12)
  • adress_detail (Field13)
  • have_point (Field14)
  • event_notification (Field15)
  • review_notification (Field16)
  • qna_notification (Field17)
  • phone_number (Field18)

member_food

  • id (Key) — Foreign key → member.id — NOT NULL
  • id (Key2) — Foreign key → food.id — NOT NULL

mission

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • comment (Field2)
  • adress (Field3)
  • is_complete (Field4)
  • on_going (Field5)
  • created_at (Field6)
  • updated_at (Field7)
  • id (Key2) — Foreign key → store.id — NOT NULL
  • give_point (Field8)

mission_member

  • id (Key) — Foreign key → member.id — NOT NULL
  • id (Key2) — Foreign key → mission.id — NOT NULL

notification

  • id (Key) — Primary key — NOT NULL
  • type (Field) — 이벤트, 리뷰, 문의내역
  • id (Key2) — Foreign key → review.id — NOT NULL
  • id (Key3) — Foreign key → mission.id — NOT NULL
  • id (Key4) — Foreign key → event.id — NOT NULL

notification_member

  • id (Key) — Foreign key → notification.id — NOT NULL
  • id (Key2) — Foreign key → member.id — NOT NULL
  • created_at (Field)

qna

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • comment (Field2)
  • id (Key2) — Foreign key → member.id — NOT NULL
  • created_at (Field3)
  • updated_at (Field4)

review

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → member.id — NOT NULL
  • comment (Field)
  • star (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • answer (Field5)

store

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • comment (Field2)
  • average_star (Field3)
  • id (Key2) — Foreign key → review.id — NOT NULL