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 — 회원_이메일 주소