종프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