ssafy
Tables (17)
Bookmark (북마크)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Key (problem_id) — bigint — Foreign key → Problem.Key — NOT NULL
- Field (is_bookmarked) — boolean — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Comment (면접문제 답변에 대한 댓글)
- Key (id) — bigint — Primary key — NOT NULL
- Key (interview_answer_id) — bigint — Foreign key → Interview_Answer.Key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field (content) — varchar — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Device_Token (멤버의 디바이스 토큰)
- Key (id) — bigint — Primary key — NOT NULL
- id (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field2 (token) — varchar — NOT NULL
- Field3 (created_at) — datetime — NOT NULL
- Field4 (modifited_at) — datetime — NOT NULL
Exam (모의고사)
- Key (id) — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field (round) — bigint — NOT NULL
- Field (score) — bigint — NOT NULL
- Field (difficulty_level) — varchar — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Exam_Problem (모의고사에 대한 문제)
- Key (id) — bigint — Primary key — NOT NULL
- Key (exam_id) — Foreign key → Exam.Key — NOT NULL
- Key (problem_id) — bigint — Foreign key → Problem.Key — NOT NULL
- Field (member_checked_answer) — bigint — NOT NULL — 멤버가 체크한 정답(?)
- Field (answer_status) — boolean — NOT NULL — 문제별 채점 결과 T,F로 저장
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Interest_Subject (멤버의 관심 주제)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field (subject) — varchar — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Interview (면접문제)
- Key (id) — Primary key — NOT NULL
- Field (question) — varchar — NOT NULL
- Field (answer) — varchar — NOT NULL — 모범답안
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
- Field (subject) — varchar — NOT NULL — enum으로 관리됨
Interview_Answer (멤버의 면접문제 답변)
- Key (id) — bigint — Primary key — NOT NULL
- Key (interview_id) — bigint — Foreign key → Interview.Key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field (grade) — varchar — NOT NULL — 자료형 변경될 수 있음
- Field (answer) — varchar — NOT NULL — 유저 답안
- Field (strength) — varchar — NOT NULL — AI 답변 저장
- Field (weakness) — varcbar — NOT NULL — AI 답변 저장
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Interview_Hint (면접문제 힌트(키워드))
- Key (id) — bigint — Primary key — NOT NULL
- Key (interview_id) — bigint — Foreign key → Interview.Key — NOT NULL
- Field (keyword) — varchar — NOT NULL — 각 문제에 대한 힌트 제공
Likes (면접문제 답변에 대한 좋아요)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Key (member_interview_id) — bigint — Foreign key → Interview_Answer.Key — NOT NULL
- Field (is_liked) — boolean — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Member (멤버)
- id — bigint — Primary key — NOT NULL
- Field (name) — varchar(20) — NOT NULL
- Field (email) — varchar(30) — NOT NULL
- Field (role) — varchar(10) — NOT NULL
- Field (auth_provider) — varchar(10) — NOT NULL
- Field (provider_id) — varchar(30) — NOT NULL
- Field (profile_image_url) — varchar — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Member_Exam_Statistic (멤버의 과목별 정답률)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field (total_count) — bigint — NOT NULL
- Field (wrong_count) — bigint — NOT NULL
- Field (subject) — varchar — NOT NULL — enum으로 관리
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Member_Game_Result (멤버의 카드 게임 결과)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field (win_count) — bigint
- Field (total_count) — bigint
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Member_History (멤버 날짜 변경 사항)
- Key — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field (is_today_solved) — boolean
- Field (created_at) — datetime — NOT NULL
- Field (modifired_at) — datetime — NOT NULL
Problem (문제)
- Key (id) — bigint — Primary key — NOT NULL
- Field (problem_type) — varchar — NOT NULL — enum으로 관리됨
- Field (question) — varchar — NOT NULL
- Field (subject) — varchar — NOT NULL — enum으로 관리됨
- Field (answer) — varchar — NOT NULL
- Field (correct_rate) — int — NOT NULL — 문제 푼 기록 없으면 default로 -1
- Field (total_count) — int — NOT NULL
- Field (correct_count) — int — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
Problem_Option (객관식 문제 보기)
- Key (problem_option_id) — bigint — Primary key — NOT NULL
- Key (problem_id) — bigint — Foreign key → Problem.Key — NOT NULL
- Field (content) — varchar — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — datetime — NOT NULL
problem_answer
- Key (id) — bigint — Primary key — NOT NULL
- Key (problem_id) — bigint — Foreign key → Problem.Key — NOT NULL
- Field (answer) — varchar(255) — NOT NULL