who-skipped

Tables (16)

GroupMemberships (그룹권한)

  • id (PK) — int — Primary key — NOT NULL
  • userId (PK2) — int — Foreign key → Users.id — NOT NULL
  • groupId (PK3) — int — Foreign key → Groups.id — NOT NULL
  • joinedAt (Field) — TIMESTAMP

Groups (그룹)

  • id (PK) — int — Primary key — NOT NULL
  • managerId (PK2) — int — Foreign key → Users.id — NOT NULL
  • managerName (Field4) — varchar
  • name (Field) — varchar
  • description (Field2) — varchar
  • createdAt (Field5) — TIMESTAMP

Past Users (과거 유저)

  • id (PK) — int — Primary key — NOT NULL
  • name (Field4) — varchar
  • password (Field2) — varchar
  • role (Field) — ROLE
  • tier (Field8) — TIER
  • solvedCount (Field10) — int
  • streaks (Field6) — int
  • solvedCategories (Field7) — JSON
  • average_tries (Field3) — double
  • joinedAt (Field9) — TIMESTAMP

ProblemCategories (문제 태그)

  • id (PK) — int — Primary key — NOT NULL
  • problemId (FK) — unsigned-medium int — Foreign key → Problems.id
  • category (Field) — varchar

ProblemTags (문제 태그 정보)

  • id (PK) — int — Primary key — NOT NULL
  • problemId (FK1) — int — Foreign key → Problems1.id
  • tagId (FK2) — int — Foreign key → Tags.id — NOT NULL

ProblemTags (문제 태그 정보2)

  • id (PK) — int — Primary key — NOT NULL
  • problemId (FK) — int — Foreign key → Problems2.id
  • name (Field) — TYPE

Problems (문제)

  • id (PK) — unsigned-medium int — Primary key
  • title (Field) — varchar
  • tier (Field4) — TIER
  • createdAt (Field2) — TIMESTAMP

Problems(NoSQL) (문제(NoSQL))

  • id (PK) — int — Primary key — NOT NULL
  • problemId (Field3) — int
  • titleKo (Field) — varchar
  • tags (Field2) — json
  • level (Field4) — LEVEL

Problems1 (문제1)

  • id (PK) — int — Primary key
  • titleKo (Field) — varchar
  • level (Field4) — LEVEL

Problems2 (문제2)

  • id (PK) — int — Primary key
  • titleKo (Field) — varchar
  • level (Field4) — LEVEL

Problems3 (문제3)

  • id (PK) — int — Primary key — NOT NULL
  • titleKo (Field) — varchar
  • tags (Field2) — JSON
  • level (Field4) — LEVEL

SolvedProblems (맞은 문제)

  • id (PK) — int — Primary key — NOT NULL
  • id (PK2) — int — Foreign key → Users.id — NOT NULL
  • id (PK3) — unsigned-medium int — Foreign key → Problems.id

Submissions (제출내역)

  • id (PK) — int — Primary key — NOT NULL
  • name (FK) — varchar — Foreign key → Users.id — NOT NULL
  • problemId (FK2) — unsigned-medium int — Foreign key → Problems.id
  • solutionId (Field4) — bigint
  • result (Field2) — SUBMISSION_RESULT
  • memory (Field3) — unsigned-medium int
  • time (Field5) — unsigned-small int
  • language (Field6) — varchar
  • codeLength (Field7) — int
  • submittedAt (Field8) — TIMESTAMP

Tags (태그)

  • id (PK) — int — Primary key — NOT NULL
  • name (Field) — TYPE

UserBadges (유저 뱃지)

  • Key — Primary key — NOT NULL
  • id (PK) — int — Foreign key → Users.id — NOT NULL
  • badge (Field2) — BADGE

Users (유저)

  • id (PK) — int — Primary key — NOT NULL
  • name (Field4) — varchar
  • password (Field2) — varchar
  • role (Field) — ROLE
  • tier (Field8) — TIER
  • streaks (Field6) — int
  • average_tries (Field3) — double
  • solvedCount (Field10) — int
  • solvedProblemTags (Field5) — JSON
  • joinedAt (Field9) — TIMESTAMP