UMC-week01

Tables (7)

Alarm (Untitled7)

  • id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → User.id — NOT NULL
  • 알림내용 (Field)

Mission (Untitled2)

  • id (PK) — Primary key — NOT NULL
  • shop_id (FK) — Foreign key → Shop.id — NOT NULL
  • reward (Field)
  • dueDate (Field2)
  • 미션내용 (Field3)

MissionDetail (Untitled3)

  • id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → User.id — NOT NULL
  • shop_id (FK2) — Foreign key → Mission.shop_id — NOT NULL
  • mission_id (FK3) — Foreign key → Mission.id — NOT NULL
  • status (Field)
  • 구분번호 (Field2)

Review (Untitled6)

  • id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → User.id — NOT NULL
  • shop_id (FK2) — Foreign key → Shop.id — NOT NULL
  • 리뷰내용 (Field)
  • 별점 (Field2)

Shop (Untitled4)

  • id (PK) — Primary key — NOT NULL
  • category (Field)
  • address (Field2)

User (Untitled)

  • id (PK) — Primary key — NOT NULL
  • username (Field)
  • gender (Field2)
  • birthday (Field3)
  • address (Field4)
  • point (Field5)
  • agreement (Field6)

UserFood (Untitled5)

  • id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → User.id — NOT NULL
  • preferFood (Field)