KH-ONETOP

Tables (5)

Bookmark (즐겨찾기)

  • bookmarkId (Key) — Long — Primary key — NOT NULL
  • userId (유저 ID) — Long — Foreign key → User.userId — NOT NULL
  • examId (시험 ID) — Long — Foreign key → Exam.examId — NOT NULL

Exam (시험)

  • examId (Key) — Primary key — NOT NULL
  • name (시험이름) — String — NOT NULL
  • issuer (발급처) — String
  • url (홈페이지) — String
  • isPublic (시험 종류) — Boolean — NOT NULL
  • userId (작성자 ID) — Long

ExamTimeStamp (시험일정)

  • examTimeStampId (Key) — Long — Primary key — NOT NULL
  • examId (시험 ID) — Long — Foreign key → Exam.examId — NOT NULL
  • turn (회차) — String
  • examDate (시험일자) — LocalDateTime
  • regStartDate (정규접수시작일) — LocalDateTime
  • regEndDate (정규접수종료일) — LocaDateTime
  • addRegStartDate (추가접수시작일) — LocalDateTime
  • addRegEndDate (추가접수종료일) — LocalDateTime
  • resultDate (결과발표일) — LocalDateTime

Score (자격증)

  • scoreId (Key) — Long — Primary key — NOT NULL
  • userId (유저 ID) — Long — NOT NULL
  • name (자격증 명) — String — NOT NULL
  • score (성적) — String — NOT NULL
  • studentCode (수험번호) — String — NOT NULL
  • issuer (발급처) — String
  • isEffective (유효성) — Boolean — NOT NULL
  • acquisitionDate (취득날짜) — LocalDate — NOT NULL
  • expirationDate (유효날짜) — LocalDate

User (유저)

  • userId (Key) — Long — Primary key — NOT NULL
  • email (이메일) — String — NOT NULL
  • password (비밀번호) — String — NOT NULL
  • name (이름) — String — NOT NULL
  • nickname (닉네임) — String — NOT NULL