worldswords
Tables (6)
QUIZZES (퀴즈)
- quiz_id (퀴즈ID) — bigint — Primary key — NOT NULL
- quiz_date (퀴즈날짜) — date
- word_id (단어ID) — bigint — Foreign key → WORDS.word_id — NOT NULL
QUIZ_HISTORIES (참여기록)
- history_id (참여ID) — bigint — Primary key — NOT NULL
- participated_at (참여일시) — datetime
- is_correct (정답여부) — boolean
- user_id (유저ID) — bigint — Foreign key → USERS.user_id — NOT NULL
- quiz_id (퀴즈ID) — bigint — Foreign key → QUIZZES.quiz_id — NOT NULL
REFRESH_TOKENS (리프레시 토큰)
- token_id — bigint — Primary key — NOT NULL
- refresh_token (토큰) — varchar(500)
- issued_at (발급일시) — datetime
- expires_at (만료일시) — datetime
- revoked (무효화여부) — boolean
- device_info (기기정보) — varchar(100)
- user_id (유저ID) — UUID — Foreign key → USERS.user_id — NOT NULL
USERS (유저)
- user_id (유저ID) — bigint — Primary key — NOT NULL
- nickname (닉네임) — varchar
- google_id (구글id) — varchar(50)
- email (이메일) — vharchar(50)
- img_url (이미지 url) — varchar(300)
- status (상태) — enum
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
- deleted_at (탈퇴일시) — datetime
- last_login_at (마지막로그인) — datetime
USER_ATTEMPTS (시도)
- attempt_id (ID) — bigint — Primary key — NOT NULL
- participation_id (참여id) — bigint — Foreign key → QUIZ_HISTORIES.history_id — NOT NULL
- attempted_at (시도일시) — datetime
- user_answer (유저제출정답) — varchar
- similarity (유사도) — decimal
- is_correct (정답여부) — boolean
- rank (유사도순위) — varchar
WORDS (단어)
- word_id (단어ID) — bigint — Primary key — NOT NULL
- language_code (언어코드) — enum
- word (단어) — varchar
- vector (벡터) — blob