test

Tables (7)

area

  • id — INT
  • address — VARCHAR(50) — NOT NULL

food_category

  • id — INT
  • name — VARCHAR(50) — NOT NULL

mission

  • id — INT
  • store_id — INT — Foreign key → store.id
  • reward — INT
  • description — TEXT

preference

  • id — INT
  • user_id — INT — Foreign key → user.id
  • category_id — INT — Foreign key → food_category.id

store

  • id — INT
  • name — VARCHAR(50)
  • category_id — INT — Foreign key → food_category.id
  • description — TEXT
  • addr — INT — Foreign key → area.id

user

  • id — INT
  • email — VARCHAR(100)
  • nickname — VARCHAR(50)
  • phone_num — VARCHAR(20)
  • gender — ENUM('MALE', 'FEMALE', 'NONE')
  • birth_date — DATE
  • address — VARCHAR(100)
  • point — INT
  • status — ENUM('ACTIVE', 'INACTIVE')
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

user_mission

  • id — INT
  • store_id — INT — Foreign key → store.id
  • user_id — INT — Foreign key → user.id
  • status — ENUM('ONGOING', 'COMPLETE')