AIE_wordle

Tables (4)

CANDIDATE (문제_입력_후보)

  • candidate_id (Key) — NUMBER — Primary key — NOT NULL — 후보키_아이디
  • candidate_word (Field) — VARCHAR2(50) — NOT NULL — 입력_후보_단어
  • is_answer (Field2) — NUMBER — NOT NULL — 문제_정답_단어

GAME (게임)

  • game_id (Key) — INT — Primary key — NOT NULL — 게임_아이디
  • user_id (Key2) — NUMBER — Foreign key → USER.user_id — NOT NULL — 회원_아이디
  • game_date (Field) — DATE — NOT NULL — 게임_시도_날짜
  • answer (Field2) — VARCHAR(50) — NOT NULL — 날짜별_정답
  • candidate_id (Key3) — NUMBER — Foreign key → CANDIDATE.candidate_id — NOT NULL — 후보키_아이디

TRIES (시도)

  • user_id (Key2) — NUMBER — Foreign key → GAME.user_id — NOT NULL — 회원_아이디
  • game_id (Key) — INT — Foreign key → GAME.game_id — NOT NULL — 게임_아이디
  • result (Field3) — VARCHAR2(50) — NOT NULL — 최종_결과
  • first (Field) — VARCHAR2(50) — 첫번째시도
  • second (Field2) — VARCHAR2(50) — 두번째시도
  • third (Field4) — VARCHAR2(50) — 세번째시도
  • fourth (Field5) — VARCHAR2(50) — 네번째시도
  • fifth (Field6) — VARCHAR2(50) — 다섯번째시도
  • sixth (Field7) — VARCHAR2(50) — 여섯번째시도

USER (회원)

  • user_id (Key) — NUMBER — Primary key — NOT NULL — 회원_아이디
  • password (Field) — VARCHAR2(50) — NOT NULL — 회원_비밀번호
  • email (Field2) — VARCHAR2(50) — NOT NULL — 회원_이메일 주소