ㅇㅇ - 2026-03-20 04:57:25

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
  • reward — INT
  • description — TEXT

preference

  • id — INT
  • user_id — INT — Foreign key
  • category_id — INT — Foreign key

store

  • id — INT
  • name — VARCHAR(50)
  • category_id — INT — Foreign key
  • description — TEXT
  • addr — INT — Foreign key

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
  • user_id — INT — Foreign key
  • status — ENUM('ONGOING', 'COMPLETE')