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