캡디
테이블 (8)
Copy Of Copy Of Untitled (Paper_Detail (시험문제 메타 정보))
- Key (paperDetailIdx) — BIGINT — 기본 키 — NOT NULL
- Field (startedAt) — TIMESTAMP — NOT NULL
- Field2 (updatedAt) — TIMESTAMP — NOT NULL
- Field3 (status) — VARCHAR(1) — NOT NULL — A : Active / D : Delete
- Field4 (year) — INTEGER — NOT NULL
- Field (round) — INTEGER — NOT NULL
- Field (chapter) — INTEGER — NOT NULL
Copy Of Copy Of Untitled2 (Image (이미지 메타 정보))
- Key (imageIdx) — BIGINT — 기본 키 — NOT NULL
- Field (startedAt) — TIMESTAMP — NOT NULL
- Field2 (updatedAt) — TIMESTAMP — NOT NULL
- Field3 (status) — VARCHAR(1) — NOT NULL — A : Active / D : Delete
- Field4 (imageUrl) — VARCHAR(50) — NOT NULL
Copy Of Copy Of Untitled22 (Answer (문제풀이))
- Key (answerIdx) — BIGINT — 기본 키 — NOT NULL
- Field (startedAt) — TIMESTAMP — NOT NULL
- Field2 (updatedAt) — TIMESTAMP — NOT NULL
- Field3 (status) — VARCHAR(1) — NOT NULL — A : Active / D : Delete
- Key (userIdx) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Key (paperIdx) — BIGINT — 외래 키 → Copy Of Untitled.Key — NOT NULL
- Field4 (userAnswer) — VARCHAR(5) — NOT NULL
- Field (isCorrect) — BIT — NOT NULL
Copy Of Untitled (Paper (시험문제))
- Key (paperIdx) — BIGINT — 기본 키 — NOT NULL
- Field (startedAt) — TIMESTAMP — NOT NULL
- Field2 (updatedAt) — TIMESTAMP — NOT NULL
- Field3 (status) — VARCHAR(1) — NOT NULL — A : Active / D : Delete
- Field (number) — INTEGER
- Field4 (question) — TEXT — NOT NULL
- Field (choiceA) — VARCHAR(50) — NOT NULL
- Field (choiceB) — VARCHAR(50) — NOT NULL
- Field (choiceC) — VARCHAR(50) — NOT NULL
- Field (choiceD) — VARCHAR(50) — NOT NULL
- Field (correctAnswer) — VARCHAR(5) — NOT NULL
- Key (paperDetailIdx) — BIGINT — 외래 키 → Copy Of Copy Of Untitled.Key — NOT NULL
Copy Of Untitled2 (Statistic (통계))
- Key (statisticIdx) — BIGINT — 기본 키 — NOT NULL
- Field (startedAt) — TIMESTAMP — NOT NULL
- Field2 (updatedAt) — TIMESTAMP — NOT NULL
- Field3 (status) — VARCHAR(1) — NOT NULL — A : Active / D : Delete
- Key (userIdx) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field4 (chapter) — INTEGER — NOT NULL
- Field (solveCnt) — BIGINT — NOT NULL
- Field (correctCnt) — BIGINT
Copy Of Untitled3 (Favorite (즐겨찾기))
- Key (favoriteIdx) — BIGINT — 기본 키 — NOT NULL
- Field (startedAt) — TIMESTAMP — NOT NULL
- Field2 (updatedAt) — TIMESTAMP — NOT NULL
- Field3 (status) — VARCHAR(1) — NOT NULL — A : Active / D : Delete
- Field4
- Key (userIdx) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Key (paperIdx) — BIGINT — 외래 키 → Copy Of Untitled.Key — NOT NULL
Copy Of Untitled4 (Bookmark (북마크))
- Key (bookmarkIdx) — BIGINT — 기본 키 — NOT NULL
- Field (startedAt) — TIMESTAMP — NOT NULL
- Field2 (updatedAt) — TIMESTAMP — NOT NULL
- Field3 (status) — VARCHAR(1) — NOT NULL — A : Active / D : Delete
- Field4
- Key (userIdx) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Key (paperDetailIdx) — BIGINT — 외래 키 → Copy Of Copy Of Untitled.Key — NOT NULL
Untitled (User (회원))
- Key (userIdx) — BIGINT — 기본 키 — NOT NULL
- Field (startedAt) — TIMESTAMP — NOT NULL
- Field2 (updatedAt) — TIMESTAMP — NOT NULL
- Field3 (status) — VARCHAR(1) — NOT NULL — A : Active / D : Delete
- Field4 (email) — VARCHAR(20) — NOT NULL
- Field (password) — VARCHAR(50) — NOT NULL
- Field (nickname) — VARCHAR(20) — NOT NULL
- Field (goal) — TEXT
- Field (dDay) — VARCHAR(20)
- Key (profileImgIdx) — BIGINT — 외래 키 → Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (role) — VARCHAR(10)