user

Tables (5)

categories

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL

feedbacks (Untitled)

  • id (Key) — int(11) — Primary key — NOT NULL
  • mission_id — int(11) — NOT NULL
  • success_message — varchar(50) — NOT NULL
  • retry_message — varchar(50) — NOT NULL

mission_attempts (misson_att)

  • id (Key) — int(11) — Primary key — NOT NULL
  • user_id (Field) — int(11) — NOT NULL
  • mission_id (Field2) — int(11) — NOT NULL
  • result — enum('성공','실패') — NOT NULL
  • timestamp — datetime — NOT NULL

missions (Untitled2)

  • id — int(11) — Primary key — NOT NULL
  • category_id — int(11) — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — text
  • audio_path — varchar(100)
  • id (Key) — int(11) — Foreign key → feedbacks.id — NOT NULL

users (user)

  • id — int(20) — Primary key — NOT NULL
  • username — varchar(10) — NOT NULL
  • password — varchar(25) — NOT NULL
  • name — varchar(10) — NOT NULL
  • gender — varchar(10)
  • birth — date
  • creatend_at (Field) — timestamp — NOT NULL