Day 3 Data Structure Codex AI Architect

Codex Client Workspace ๊ธฐ๋ฐ˜ ๋ฐ์ดํ„ฐ ์„ค๊ณ„ Tasks

์Šคํƒ€ํŠธ์—…๋“ค์ด MVP ๊ฐœ๋ฐœ ๋‹จ๊ณ„์—์„œ ์ง๋ฉดํ•˜๋Š” ๋ฐ์ดํ„ฐ ๊ตฌ์กฐ ์ดํ•ด ์ฐจ์ด, ์šฉ์–ด ํŒŒํŽธํ™”, ๋ณ€๊ฒฝ ์˜ํ–ฅ ์ „ํŒŒ ๋ฌธ์ œ๋ฅผ
Codex๋ฅผ ํ™œ์šฉํ•ด ์ž๋™์œผ๋กœ ๋ถ„์„ํ•˜๊ณ  ํ•ด์†Œํ•˜๋Š” ์‹ค๋ฌด AI ํ˜‘์—… Task ๋ณด๋“œ์ž…๋‹ˆ๋‹ค.

Day 3 Startup MVP Tasks

๋ฐ์ดํ„ฐ ๊ตฌ์กฐ ์ •๋ ฌ๋ถ€ํ„ฐ ์šฉ์–ด ํ‘œ์ค€ํ™”, ๋ณ€๊ฒฝ ์˜ํ–ฅ ๊ณต์œ ๊นŒ์ง€ โ€” Codex๋ฅผ ๋ฐ์ดํ„ฐ ์„ค๊ณ„ ํŒŒํŠธ๋„ˆ๋กœ ํ™œ์šฉํ•˜๋Š” ํ•ต์‹ฌ ์›Œํฌํ”Œ๋กœ์šฐ๋ฅผ ๊ฒฝํ—˜ํ•ด๋ณด์„ธ์š”.

TASK 1
Task 1

Task 1. ๋ฐ์ดํ„ฐ ๊ตฌ์กฐ ์ดํ•ด ์ฐจ์ด ํ•ด๊ฒฐ ์‹ค์Šต

Task 01: ๊ธฐํš-๊ฐœ๋ฐœ ๊ฐ„ ๋ฐ์ดํ„ฐ ๊ตฌ์กฐ ์ดํ•ด ์ •๋ ฌ (Data Structure Alignment)

์ž์—ฐ์–ด๋กœ ์ž‘์„ฑ๋œ ๊ธฐํš ํšŒ์˜๋ก์—์„œ ํ•ต์‹ฌ ์—”ํ‹ฐํ‹ฐ์™€ ๊ด€๊ณ„(Mermaid ERD)๋ฅผ ๋„์ถœํ•˜์—ฌ, ๊ธฐํš์ž์™€ ๊ฐœ๋ฐœ์ž ๊ฐ„ ๋ฐ์ดํ„ฐ ๋ชจ๋ธ ์ดํ•ด ์ฐจ์ด๋ฅผ AI๋กœ ํ•ด์†Œํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜ERD ์Šคํ‚ค๋งˆ ๋ฐ ๋ฐ์ดํ„ฐ ๊ตฌ์กฐ ์ •์˜์„œ ์™„์„ฑ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client Workspace
์‹ค์Šต ๋ฒ”์œ„Data Structure Alignment
1๋‹จ๊ณ„ ๐Ÿ“‚ ํšŒ์˜๋ก ํŒŒ์ผ(day3_meeting_notes.md) ์ค€๋น„ ๋ฐ Codex ์—…๋กœ๋“œ
2๋‹จ๊ณ„ ๐Ÿ” Codex์— ์—”ํ‹ฐํ‹ฐ ๋„์ถœ ๋ฐ Mermaid ERD ์ƒ์„ฑ ์˜๋ขฐ
ERD Entity Mapping Data Alignment
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ erd-schema.md (๋ฐ์ดํ„ฐ ๋ช…์„ธ ๋ฐ ERD)
Task 1 ์‹ค์Šต์‹ค ์ž…์žฅ
TASK 2
Task 2

Task 2. ์šฉ์–ด ํ‘œ์ค€ํ™” ์‹ค์Šต

Task 02: ๋„๋ฉ”์ธ๋ณ„ ์šฉ์–ด ํŒŒํŽธํ™” ํ•ด์†Œ (Terminology Standardization)

๊ธฐํš์„œ(ํšŒ์›), API ๋ช…์„ธ(User), ํ™”๋ฉด(๊ณ ๊ฐ), DB(Member)์ฒ˜๋Ÿผ ํŒŒํŽธํ™”๋œ ์šฉ์–ด ํ˜ผ์šฉ ์ƒํƒœ๋ฅผ ์ „์ˆ˜ ๋ถ„์„ํ•˜๊ณ  ํ†ตํ•ฉ ํ‘œ์ค€ ์šฉ์–ด ์‚ฌ์ „์„ ์ž๋™ ๊ตฌ์ถ•ํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜ํ‘œ์ค€ ์šฉ์–ด ์‚ฌ์ „(Glossary) ์™„์„ฑ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client Workspace
์‹ค์Šต ๋ฒ”์œ„Terminology Standardization
1๋‹จ๊ณ„ ๐Ÿ“ ์šฉ์–ด ํ˜ผ์šฉ ๋ช…์„ธ์„œ(fragmented-terms.md) ์ž‘์„ฑ ๋ฐ ์ค€๋น„
2๋‹จ๊ณ„ ๐Ÿ“‹ Codex๋กœ ํ‘œ์ค€ ์šฉ์–ด ์‚ฌ์ „ ๋ฐ ๋ณ€์ˆ˜๋ช… ๋งคํ•‘ ๋„์ถœ
Glossary Terminology Domain Standard
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ project-glossary.md (ํ‘œ์ค€ ์šฉ์–ด ์‚ฌ์ „)
Task 2 ์‹ค์Šต์‹ค ์ž…์žฅ
TASK 3
Task 3

Task 3. ๋ณ€๊ฒฝ ์˜ํ–ฅ ๊ณต์œ  ์‹ค์Šต

Task 03: DB ์Šคํ‚ค๋งˆ ๋ณ€๊ฒฝ ์‹œ ์˜ํ–ฅ ๋ฒ”์œ„ ๋ถ„์„ (Change Impact Analysis)

DB ๋ฌผ๋ฆฌ ์Šคํ‚ค๋งˆ ๋˜๋Š” ํ•ต์‹ฌ ๋น„์ฆˆ๋‹ˆ์Šค ๋กœ์ง ๋ณ€๊ฒฝ ์‹œ ์˜ํ–ฅ์„ ๋ฐ›๋Š” API ๊ทœ๊ฒฉ๊ณผ UI ํ™”๋ฉด์„ Codex๋กœ ์ž๋™ ๋ถ„์„ํ•˜๊ณ  ํŒ€ ๊ณต์œ ์šฉ ๋ฆฌํฌํŠธ๋ฅผ ์ž‘์„ฑํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜๋ณ€๊ฒฝ ์˜ํ–ฅ๋„ ๋ถ„์„ ๋ฆฌํฌํŠธ ์™„์„ฑ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client Workspace
์‹ค์Šต ๋ฒ”์œ„Change Impact Analysis
1๋‹จ๊ณ„ ๐Ÿ“‚ ์Šคํ‚ค๋งˆ ๋ณ€๊ฒฝ ์š”์ฒญ์„œ(schema-change-request.md) ์ค€๋น„
2๋‹จ๊ณ„ ๐Ÿ”„ Codex๋กœ API/ํ™”๋ฉด ์˜ํ–ฅ ๋ฒ”์œ„ ์ „์ˆ˜ ๋ถ„์„ ๋ฐ ๊ณต์œ  ๋ฆฌํฌํŠธ ์ƒ์„ฑ
Schema Change Impact Analysis API/UI Sync
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ change-impact-report.md (๋ณ€๊ฒฝ ์˜ํ–ฅ๋„ ๋ถ„์„์„œ)
์‹ค์Šต์‹ค ์ž…์žฅ
SKILL 1
Skill Task 1

Skill Task 1. Sequence์—์„œ Entity์™€ ์ƒํƒœ ๋„์ถœ

ADD-D03-T01: Sequence ๋ฉ”์‹œ์ง€ ๊ธฐ๋ฐ˜ Entity ์‹๋ณ„

๋ฉ”์‹œ์ง€์™€ ์ƒํƒœ ๋ณ€ํ™”๋ฅผ ๊ทผ๊ฑฐ๋กœ User, Video, Campaign ๋“ฑ ํ•ต์‹ฌ Entity์™€ ์ƒํƒœ๋ฅผ ๋„์ถœํ•˜๊ณ  ์˜์† ๋ฐ์ดํ„ฐ ์—ฌ๋ถ€๋ฅผ ๊ฒ€์ฆํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜Entity & ์ƒํƒœ ์ •์˜์„œ ๋„์ถœ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client
์‹ค์Šต ๋ฒ”์œ„Skill Task (TECH)
1๋‹จ๊ณ„ ๐Ÿ“ Day 2 Sequence Diagram ๋ถ„์„
2๋‹จ๊ณ„ โš™๏ธ ์˜์† ๋ฐ์ดํ„ฐ์™€ ํ™”๋ฉด ๋ฐ์ดํ„ฐ ๋ถ„๋ฆฌ ์ •์˜
Skill Task Entity Discovery TECH-DDD
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ 06_ENTITIES.md
์‹ค์Šต์‹ค ์ž…์žฅ
SKILL 2
Skill Task 2

Skill Task 2. ๊ด€๊ณ„ยท์ •๊ทœํ™”ยท๋ฐ์ดํ„ฐ ์†Œ์œ ๊ถŒ ์„ค๊ณ„

ADD-D03-T02: 3NF ์ •๊ทœํ™” ERD ๋ฐ ์†Œ์œ ๊ถŒ ์ˆ˜๋ฆฝ

Cardinality, FK, Unique ์ œ์•ฝ ๋ฐ 3์ •๊ทœํ˜•(3NF) ๋ชจ๋ธ์„ ๊ตฌ์ถ•ํ•˜๊ณ  Domain๋ณ„ ๋ฐ์ดํ„ฐ ์†Œ์œ ๊ถŒ(Owner)์„ ๋ช…์‹œํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜3NF ERD ๋ฐ ์†Œ์œ ๊ถŒ ํ‘œ ์ž‘์„ฑ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client
์‹ค์Šต ๋ฒ”์œ„Skill Task (HYBRID)
1๋‹จ๊ณ„ ๐Ÿ“ FK ๋ฐ Cardinality ๊ด€๊ณ„ ์ˆ˜๋ฆฝ
2๋‹จ๊ณ„ โš™๏ธ ๋‹ค๋Œ€๋‹ค ํ•ด์†Œ ๋ฐ Domain ๋ฐ์ดํ„ฐ ์†Œ์œ ์ž ์ง€์ •
Skill Task 3NF ERD Data Ownership
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ 06_ERD.md
์‹ค์Šต์‹ค ์ž…์žฅ
SKILL 3
Skill Task 3

Skill Task 3. Domainโ€“Flowโ€“ERD ์ •ํ•ฉ์„ฑ Audit

ADD-D03-T03: ์‚ฐ์ถœ๋ฌผ ์‚ผ๊ฐ ๊ฒ€์ฆ ๋ฐ ๋ถˆ์ผ์น˜ ์ถ”์ถœ

Sequence์˜ CRUD ๋ฐ์ดํ„ฐ๊ฐ€ ERD์™€ Domain ์ฑ…์ž„์— ์กด์žฌํ•˜๋Š”์ง€ ์ถ”์ ํ•˜๊ณ  ๋ˆ„๋ฝ Entity ๋ฐ ๋ช…์นญ ๋ถˆ์ผ์น˜๋ฅผ ๋„์ถœํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜Domain-Flow-ERD Audit ํ‘œ ์™„๋ฃŒ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client
์‹ค์Šต ๋ฒ”์œ„Skill Task (AI)
1๋‹จ๊ณ„ ๐Ÿ“ Sequence, ERD, Domain Map ๊ต์ฐจ ๋น„๊ต
2๋‹จ๊ณ„ ๐Ÿ›ก๏ธ ๋ˆ„๋ฝ ์†์„ฑ ๋ฐ ์†Œ์œ ๊ถŒ ์ดํƒˆ ํ•ญ๋ชฉ ๋ฆฌํฌํŠธ ์ƒ์„ฑ
Skill Task ERD Audit TECH-QA
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ erd-audit-report.md
์‹ค์Šต์‹ค ์ž…์žฅ
๐Ÿš€ ์‹ฌํ™” Mission โ€” ๋ฐ์ดํ„ฐ ์„ค๊ณ„ ๋งˆ์Šคํ„ฐ ๊ณผ์ •
MISSION 1
Mission 1

Mission 1. ์„ค๊ณ„ ์˜์‚ฌ๊ฒฐ์ • ๊ธฐ๋ก ์‹ค์Šต

Mission 01: Design Decision Log ์ž๋™ ์ž‘์„ฑ (Why ๊ธฐ๋ก)

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ •๊ทœํ™” ๋ฐ ์•„ํ‚คํ…์ฒ˜ ์˜๊ฒฐ ๋ฐฐ๊ฒฝ์„ Codex๋กœ ์ •ํ˜•ํ™”๋œ Design Decision Log๋กœ ์ž‘์„ฑํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜์„ค๊ณ„ ์˜์‚ฌ๊ฒฐ์ • ๊ธฐ๋ก ๋ฌธ์„œ(DDL) ์™„์„ฑ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client Workspace
์‹ค์Šต ๋ฒ”์œ„Design Decision Log & Knowledge Mgmt
1๋‹จ๊ณ„ ๐Ÿ“‚ ๊ธฐ์ˆ  ์„ค๊ณ„ ํšŒ์˜ ๋Œ€ํ™” ๊ธฐ๋ก ์ค€๋น„
2๋‹จ๊ณ„ ๐Ÿ” Codex์— ์˜๊ฒฐ ํ•ญ๋ชฉ ์‚ฌ์œ  ์ •ํ˜•ํ™” ์š”์ฒญ
Decision Log Architecture
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ design-decision-log.md
๊ณผ์ œ์‹ค ์ž…์žฅ
MISSION 2
Mission 2

Mission 2. ์˜ˆ์™ธ ์‹œ๋‚˜๋ฆฌ์˜ค ๋ฐœ๊ตด ์‹ค์Šต

Mission 02: ๋™์‹œ์„ฑยท๋ฌด๊ฒฐ์„ฑ Edge Case ์ „์ˆ˜ ๋„์ถœ

์ •์˜๋œ DB ์Šคํ‚ค๋งˆ์™€ ์ฐธ์กฐ ๊ตฌ์กฐ์—์„œ ๋ฐœ์ƒ ๊ฐ€๋Šฅํ•œ ๋™์‹œ์„ฑ ์˜ค๋ฅ˜ ๋ฐ ์ฐธ์กฐ ๋ฌด๊ฒฐ์„ฑ ๋ถ•๊ดด ๋ฆฌ์Šคํฌ๋ฅผ ๋ฐœ๊ตดํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜์˜ˆ์™ธ ์‹œ๋‚˜๋ฆฌ์˜ค ๋ฆฌํฌํŠธ ์™„์„ฑ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client Workspace
์‹ค์Šต ๋ฒ”์œ„Edge Case Discovery
1๋‹จ๊ณ„ ๐Ÿ“‚ DB ๋ฌผ๋ฆฌ ์Šคํ‚ค๋งˆ ์ •์˜์„œ ์ค€๋น„
2๋‹จ๊ณ„ ๐Ÿ›ก๏ธ Codex๋กœ ๋ฌด๊ฒฐ์„ฑ ์˜ˆ์™ธ ์ผ€์ด์Šค ๋„์ถœ
Edge Cases Concurrency
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ edge-case-analysis.md
๊ณผ์ œ์‹ค ์ž…์žฅ
MISSION 3
Mission 3

[๊ณผ์ œ] Mission 3. ์ปค๋จธ์Šค ๋Œ€๊ทœ๋ชจ ์ฃผ๋ฌธ ERD

Skill Mission 1: 3NF ์ •๊ทœํ™” ๋ฐ FK/์ธ๋ฑ์Šค ๋ช…์„ธ

๋Œ€๊ทœ๋ชจ ์ด์ปค๋จธ์Šค ์‹œ์Šคํ…œ์˜ ์ฃผ๋ฌธ, ๊ฒฐ์ œ, ์žฅ๋ฐ”๊ตฌ๋‹ˆ, ์ฟ ํฐ ์ ์šฉ ๋ฐ์ดํ„ฐ์˜ ์ œ3์ •๊ทœํ˜•(3NF) ๋ชจ๋ธ๋ง ๋ฐ ERD๋ฅผ ์„ค๊ณ„ํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜3NF ERD ๋ฐ ์ธ๋ฑ์Šค ๋ช…์„ธ ์™„๋ฃŒ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client
์‹ค์Šต ๋ฒ”์œ„Skill Task Mission (Level 1)
1๋‹จ๊ณ„ ๐Ÿ“ ํŒŒํŽธํ™”๋œ ์ฃผ๋ฌธ ์›๋ณธ ๋ฐ์ดํ„ฐ 3NF ์ •๊ทœํ™”
2๋‹จ๊ณ„ โš™๏ธ FK ์ œ์•ฝ ๋ฐ Unique Index ์ •์˜์„œ ๊ตฌ์ถ•
Skill Mission Commerce ERD 3NF Normalization
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ commerce-erd-specification.md
๊ณผ์ œ์‹ค ์ž…์žฅ
MISSION 4
Mission 4

[๊ณผ์ œ] Mission 4. ๋ฌผ๋ฅ˜ ๋ฐฐ์†ก ๋ฐ์ดํ„ฐ Audit

Skill Mission 2: ๊ธ€๋กœ๋ฒŒ ๋ฌผ๋ฅ˜ ์†Œ์œ ๊ถŒ ๋ฐ Sequence ์ •ํ•ฉ์„ฑ ๊ฒ€์ฆ

๊ธ€๋กœ๋ฒŒ ๋ฌผ๋ฅ˜ ๋ฐฐ์†ก ํ”Œ๋žซํผ์˜ ์ฐฝ๊ณ , ์šด์†ก์—…์ฒด, ๋ฐฐ์†ก ์ด๋ ฅ ๋ฐ์ดํ„ฐ์˜ Domain ์†Œ์œ ๊ถŒ ๋ฐ Sequence-ERD ์ •ํ•ฉ์„ฑ์„ ์˜ค๋””ํŒ…ํ•ฉ๋‹ˆ๋‹ค.

๋ชฉํ‘œ ์ˆ˜์น˜Domain ์†Œ์œ ๊ถŒ ํ‘œ & Audit ๋ฆฌํฌํŠธ ์ž‘์„ฑ
ํ•ต์‹ฌ ๋„๊ตฌCodex Client
์‹ค์Šต ๋ฒ”์œ„Skill Task Mission (Level 2)
1๋‹จ๊ณ„ ๐Ÿ“ ๋ฌผ๋ฅ˜ ์ถœ๊ณ -๋ฐฐ์†ก ์ด๋ ฅ ๋ฐ์ดํ„ฐ ์†Œ์œ ๊ถŒ ์ง€์ •
2๋‹จ๊ณ„ ๐Ÿ›ก๏ธ Flow-ERD ๋ˆ„๋ฝ ์†์„ฑ ๊ต์ฐจ ์˜ค๋””ํŒ… ์™„๋ฃŒ
Skill Mission Logistics Audit Data Ownership
์˜ˆ์ƒ ์‚ฐ์ถœ๋ฌผ logistics-domain-audit.md
๊ณผ์ œ์‹ค ์ž…์žฅ