-
Notifications
You must be signed in to change notification settings - Fork 0
[Fix] 알고리즘 학습 Sample 수정 #34
Copy link
Copy link
Open
Labels
알고리즘 학습This issue or pull request already existsThis issue or pull request already exists
Description
💫 ISSUE
알고리즘 학습 Sample 수정
✏️ Description
회원별 퀴즈 맞춘 이력 테이블의 더미 데이터 추가했습니다.
📖 To Do
- 회원별 퀴즈 맞춘 이력 Sample 추가
-- Member_Algo_Correct_Quiz_History 예시 INSERT
INSERT INTO Member_Algo_Correct_Quiz_History (member_id, algo_quiz_question_id)
VALUES
-- member_id = 1
(1, 1),(1, 2),(1, 3), -- roadmap_id=1 count=3
(1, 4),(1, 5), -- roadmap_id=2 count=2
(1, 6), -- roadmap_id=4 count=1
-- member_id = 2
(2, 1),(2, 2), -- roadmap_id=1 count=2
(2, 7), -- roadmap_id=3 count=1
(2, 8),(2, 9), -- roadmap_id=5 count=2
(2, 10), -- roadmap_id=7 count=1
(2, 11),(2, 12),(2, 13),-- roadmap_id=9 count=3
-- member_id = 3
(3, 4), -- roadmap_id=2 count=1
(3, 14), -- roadmap_id=6 count=1
-- member_id = 4
(4, 1),(4, 2),(4, 3), -- roadmap_id=1 count=3
(4, 4),(4, 5), -- roadmap_id=2 count=2
(4, 6), -- roadmap_id=4 count=1
(4, 11),(4, 12), -- roadmap_id=9 count=2
-- member_id = 6
(6, 1),(6, 2), -- roadmap_id=1 count=2
(6, 7), -- roadmap_id=3 count=1
(6, 8), -- roadmap_id=5 count=1
-- member_id = 7
(7, 4),(7, 5), -- roadmap_id=2 count=2
(7, 10), -- roadmap_id=7 count=1
-- member_id = 9
(9, 1),(9, 2),(9, 3), -- roadmap_id=1 count=3
(9, 4),(9, 5),(9, 6),(9, 7), -- roadmap_id=2 count=4
(9, 8),(9, 9), -- roadmap_id=4 count=2
(9, 10), -- roadmap_id=5 count=1
(9, 11),(9, 12),(9, 13), -- roadmap_id=9 count=3
-- member_id = 10
(10, 1),(10, 2), -- roadmap_id=1 count=2
(10, 6),(10, 7), -- roadmap_id=4 count=2
(10, 14); -- roadmap_id=6 count=1
💡 ETC
기타 사항을 입력해주세요.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
알고리즘 학습This issue or pull request already existsThis issue or pull request already exists