Mission

Tables (6)

food_category (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(50)

member (Untitled)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • email — varchar(255)
  • provider — varchar(50)
  • provider_id — varchar(255)
  • point — int
  • deleted_at — timestamp

member_mission (Untitled5)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL
  • status — varchar(20)
  • review_content — varchar(100)

mission (Untitled6)

  • id — bigint — Primary key — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • title — varchar(255)
  • description — varchar(500)
  • reward_point — int

region (Untitled2)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(100)

store (Untitled3)

  • id — bigint — Primary key — NOT NULL
  • region_id — bigint — Foreign key → region.id — NOT NULL
  • food_category_id — bigint — Foreign key → food_category.id — NOT NULL
  • name — varchar(255) — NOT NULL
  • address — varchar(255)