Skip to content

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

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

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions