똑터뷰 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