캡디

테이블 (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)