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