AIE_과제

테이블 (5)

attempts_details (Untitled5)

  • detail_id (primary) — int — 기본 키 — NOT NULL
  • attempted_number (Field) — int
  • attemp_id (primary2) — int — 외래 키 → game_attempts.attemp_id — NOT NULL
  • guessed_word (Field2) — str
  • Field3 — str

daily_games (Untitled3)

  • game_id (primary) — int — 기본 키 — NOT NULL
  • game_date (Field) — date
  • target_id (primary2) — int — 외래 키 → target_words.target_id — NOT NULL

game_attempts (Untitled2)

  • attemp_id (primary) — int — 기본 키 — NOT NULL
  • status (Field) — char
  • user_tries (Field2) — int
  • started_at (Field3) — date
  • completed_at (Field4) — date
  • game_id (primary2) — int — 외래 키 → daily_games.game_id — NOT NULL
  • user_id (primary3) — int — 외래 키 → users.user_id — NOT NULL

target_words (Untitled4)

  • target_id (primary) — int — 기본 키 — NOT NULL
  • word_name (Field) — str
  • difficulty (Field2) — str
  • Field3

users (Untitled)

  • user_id (primary) — int — 기본 키 — NOT NULL
  • email (Field) — str
  • password (Field2)