똑터뷰 ver2

테이블 (9)

BaseQuestion (Untitled2)

  • bq_id (Key) — Long — 기본 키 — NOT NULL
  • user_id (unique2) — String — 외래 키 → User.user_id — NOT NULL
  • category (Field) — Category(e) — enum으로 빼서 {인성, 기술, 내가만든)
  • content (Field2) — String
  • origin(e) (Field3) — Origin(e) — base, user, ai
  • createdAt (Field5) — LocalDateTime
  • updatedAt (Field6) — LocalDateTime

FeedbackPerQ (Untitled8)

  • fq_id (Key) — Long — 기본 키 — NOT NULL
  • inq_id (Key2) — Long — 외래 키 → QuestionAfter.inq_id — NOT NULL
  • behavefeedback (Field) — String
  • langfeedback (Field2) — String
  • createdAt (Field3) — LocalDateTime

Note (Untitled6)

  • note_id (Key) — Long — 기본 키 — NOT NULL
  • bq_id (Key4) — Long — 외래 키 → BaseQuestion.bq_id — NOT NULL
  • inq_id (Key2) — Long — 외래 키 → QuestionAfter.inq_id — NOT NULL
  • content (Field) — String
  • createdAt (Field2) — LocalDateTime
  • updatedAt (Field3) — LocalDateTime

QuestionAfter (Untitled7)

  • inq_id (Key) — Long — 기본 키 — NOT NULL
  • session_id (Key2) — Long — 외래 키 → Session.session_id — NOT NULL
  • content (Field) — String
  • isTailQ (Field2) — Boolean
  • s3key (Field3) — String
  • answer (Field4) — String
  • createdAt (Field5) — String

Resume (Untitled9)

  • user_id (unique) — String — 외래 키 → User.user_id — NOT NULL
  • s3_key (Field2) — String
  • filename (Field4) — String
  • createdAt (Field) — LocalDateTime
  • updatedAt (Field3) — LocalDateTime

SavedQuestion (Untitled3)

  • sq_id (Key3) — Long — 기본 키 — NOT NULL
  • inq_id (Key2) — Long — 외래 키 → QuestionAfter.inq_id — NOT NULL
  • bq_id (Key4) — Long — 외래 키 → BaseQuestion.bq_id — NOT NULL
  • user_id (Field2) — String
  • createdAt (Field) — LocalDateTime

ScoreAndFeedback (Untitled5)

  • score_id (Key) — Long — 기본 키 — NOT NULL
  • session_id (Key2) — Long — 외래 키 → Session.session_id — NOT NULL
  • totalScore (Field) — Int
  • suitability (Field3) — Int
  • intendunderstanding (Field5) — Int
  • problemsolving (Field6) — Int
  • accuracy (Field7) — Int
  • experience (Field8) — Int
  • logicality (Field9) — Int
  • confidence (Field10) — Int
  • speed (Field11) — Int
  • voice (Field12) — Int
  • gesture (Field13) — Int
  • attitude (Field14) — Int
  • gazing (Field15) — Int
  • general_feedback (Field2) — String
  • pro (Field16) — String
  • con (Field17) — String
  • createdAt (Field4) — LocalDateTime

Session (Untitled4)

  • session_id (Key) — Long — 기본 키 — NOT NULL
  • user_id (INDEX) — String — 외래 키 → User.user_id — NOT NULL
  • interviewType (Field) — InterviewType(e) — RESUME-BASED CUSTOMIZED
  • interviewerType (Field4) — InterviewType(e)
  • createdAt (Field3) — LocalDateTime
  • updatedAt (Field2) — LocalDateTime

User (Untitled)

  • user_id (unique) — String — 기본 키 — NOT NULL
  • name (Field) — String
  • password (Field4) — String
  • depart (Field2) — String
  • status (Field3) — Status(e) — 얘는 enum으로 빼서 student, worker 등등? 으로 나눌거같아요
  • createdAt (Field5) — LocalDateTime
  • updatedAt (Field6) — LocalDateTime
  • subscriptionEndDate (Field7) — LocalDateTime