test

Tables (7)

Untitled (food_category)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(50)

Untitled (area)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (address) — VARCHAR(50)

Untitled (store)

  • Key — INT — Primary key — NOT NULL
  • Key (category_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (addr) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(50)
  • Field (description) — TEXT

Untitled (preference)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (category_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — INT — Foreign key → user.Key — NOT NULL

Untitled (mission)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (reward) — INT
  • Field (description) — TEXT

user

  • Key (id) — INT — Primary key — NOT NULL
  • Field (nickname) — VARCHAR(50)
  • Field (phone_num) — VARCHAR[30]
  • Field (gender) — ENUM('M', 'F', 'NONE')
  • Field (email) — VARCHAR(100)
  • Field2 (birth_date) — DATE
  • Field (address) — VARCHAR(100)
  • Field (point) — INT
  • Field (status) — ENUM('ACTIVE', 'INACTIVE')
  • Field (created_at) — DATETIME(6)
  • Field (updated_at) — DATETIME(6)

user_mission

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