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