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