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