Skip to content

[Fix] 알고리즘 학습 Sample 수정 #34

@rosieisor

Description

@rosieisor

💫 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

기타 사항을 입력해주세요.

Metadata

Metadata

Assignees

Labels

알고리즘 학습This issue or pull request already exists

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions