practice
테이블 (3)
UserMissionStatus
- Key — 기본 키 — NOT NULL
- user_id (User_id) — int — 외래 키 → Users.user_id — NOT NULL
- Key (Key2) — 외래 키 → 미션.Key — NOT NULL
- user_id — INT — FOREIGN KEY
- mission_id — INT — FOREIGN KEY
- mission_status — ENUM
- started_at — TIMESTAMP
- completed_at — TIMESTAMP — NULL
Users (Untitled)
- user_id (User_id) — int — 기본 키 — NOT NULL
- username — VARCHAR(255)
- password — VARCHAR(255)
- email — VARCHAR(255)
- created_at — TIMESTAMP
미션
- Key — 기본 키 — NOT NULL
- mission_id — INT
- user_id — INT
- mission_status — ENUM
- discription — text