종프2-Spring

테이블 (6)

ChatRoom (채팅방)

  • chatroom_id (Key) — Long — 기본 키 — NOT NULL
  • member_id (Key2) — Long — 외래 키 → Member.member_id — NOT NULL
  • name (Field) — String
  • created_at (Field2) — LocalDate
  • updated_at (Field3) — LocalDate

LearningHistory (학습 이력)

  • learningHistory_id (Key) — Long — 기본 키 — NOT NULL
  • member_id (Key2) — Long — 외래 키 → Member.member_id — NOT NULL
  • recommended_chapter1 (Field) — enum
  • recommended_chapter2 (Field2) — enum
  • recommended_chapter3 (Field3) — enum
  • learing_level (Field4) — enum
  • goal (Field5) — String
  • updated_at (Field6) — LocalDate

Member (멤버)

  • member_id (Key) — Long — 기본 키 — NOT NULL
  • email (Field) — String
  • name (Field2) — String
  • created_at (Field3) — LocalDate
  • updated_at (Field4) — LocalDate

MemberQuestion (멤버 문제 중간 테이블)

  • memberQuestion_id (Key) — Long — 기본 키 — NOT NULL
  • question_id (Key2) — Long — 외래 키 → Question.question_id — NOT NULL
  • member_id (Key3) — Long — 외래 키 → Member.member_id — NOT NULL
  • solved_at (Field2) — LocalDate
  • correctOnFirstTry (Field4) — Boolean
  • createdAt (Field) — LocalDate
  • updated_at (Field3) — LocalDate

Message (채팅 메세지)

  • message_id (Key) — Long — 기본 키 — NOT NULL
  • chatroom_id (Key2) — Long — 외래 키 → ChatRoom.chatroom_id — NOT NULL
  • content (Field2) — String(Lob)
  • senderType (Field) — enum
  • created_at (Field3) — LocalDate

Question (문제)

  • question_id (Key) — Long — 기본 키 — NOT NULL
  • title (Field) — String
  • choice1 (Field2) — String
  • choice2 (Field3) — String
  • choice3 (Field4) — String
  • choice4 (Field5) — String
  • answer (Field6) — int
  • explaination (Field7) — String
  • aiSummary (Field11) — String
  • difficulty (Field8) — enum
  • chapter (Field9) — enum
  • created_at (Field10) — LocalDate