mission1

Tables (6)

food_category

  • id — BIGINT — Primary key — NOT NULL — Auto Incrment
  • name — VARCHAR(50)

member

  • id — BIGINT — Primary key — NOT NULL — Auto Increment
  • name — VARCHAR(50)
  • email — VARCHAR(100)
  • social_provider — VARCHAR(20)
  • deleted_at — DATETIME — NOT NULL

member_mission

  • id — BIGINT — Primary key — NOT NULL
  • completed_at — DATETIME — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — Auto Increment
  • mission_id — BIGINT — Foreign key → mission.id — NOT NULL — Auto Increment

mission

  • id — BIGINT — Primary key — NOT NULL — Auto Increment
  • title — VARCHAR(100)
  • description — VARCHAR(500)
  • store_id — BIGINT — Foreign key → store.id — NOT NULL — Auto Increment

region

  • id — BIGINT — Primary key — NOT NULL — Auto Increment
  • name — VARCHAR(50)

store

  • id — BIGINT — Primary key — NOT NULL — Auto Increment
  • name — VARCHAR(100)
  • address — VARCHAR(255)
  • rsgion_id (region_id) — BIGINT — Foreign key → region.id — NOT NULL — Auto Increment
  • food_category_id — BIGINT — Foreign key → food_category.id — NOT NULL — Auto Incrment