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