Day 3 Data Structure Codex AI Architect

Codex Client Workspace Data Design Tasks

A hands-on AI teamwork Task board that uses Codex to automatically analyze and fix the data structure misunderstandings, scattered terms and change ripple problems startups face during MVP development.

Day 3 Startup MVP Tasks

From aligning data structures to standardizing terms and sharing change impact β€” experience the key workflow of using Codex as a data design partner.

TASK 1
Task 1

Task 1. Resolve Data Structure Misunderstandings Lab

Task 01: Align Data Structure Understanding Between Planning and Dev (Data Structure Alignment)

Derive key entities and relationships (Mermaid ERD) from planning meeting notes written in natural language, and use AI to close the gap in how planners and developers understand the data model.

TargetERD schema and data structure doc
Key toolCodex Client Workspace
Lab scopeData Structure Alignment
Step 1 πŸ“‚ Prepare the meeting notes file (day3_meeting_notes.md) and upload to Codex
Step 2 πŸ” Ask Codex to derive entities and generate a Mermaid ERD
ERD Entity Mapping Data Alignment
Expected output erd-schema.md (data spec and ERD)
Enter Task 1 lab
TASK 2
Task 2

Task 2. Term Standardization Lab

Task 02: Fix Scattered Terms Across Domains (Terminology Standardization)

Analyze every case of mixed terms β€” like the plan (member), API spec (User), screen (customer) and DB (Member) β€” and automatically build one standard term dictionary.

TargetStandard term dictionary (Glossary)
Key toolCodex Client Workspace
Lab scopeTerminology Standardization
Step 1 πŸ“ Write and prepare a mixed-terms spec (fragmented-terms.md)
Step 2 πŸ“‹ Use Codex to produce a standard term dictionary and variable name mapping
Glossary Terminology Domain Standard
Expected output project-glossary.md (standard term dictionary)
Enter Task 2 lab
TASK 3
Task 3

Task 3. Share Change Impact Lab

Task 03: Analyze Impact of DB Schema Changes (Change Impact Analysis)

When the DB physical schema or core business logic changes, use Codex to automatically analyze the affected API specs and UI screens and write a report to share with the team.

TargetChange impact analysis report
Key toolCodex Client Workspace
Lab scopeChange Impact Analysis
Step 1 πŸ“‚ Prepare the schema change request (schema-change-request.md)
Step 2 πŸ”„ Use Codex to analyze all API/screen impact and create a sharing report
Schema Change Impact Analysis API/UI Sync
Expected output change-impact-report.md (change impact analysis)
Enter lab
SKILL 1
Skill Task 1

Skill Task 1. Derive Entities and States from Sequences

ADD-D03-T01: Identify Entities from Sequence messages

Use messages and state changes to derive key Entities like User, Video and Campaign and their states, and check whether each is persistent data.

TargetEntity & state doc
Key toolCodex Client
Lab scopeSkill Task (TECH)
Step 1 πŸ“ Analyze the Day 2 Sequence Diagrams
Step 2 βš™οΈ Define persistent data and screen data separately
Skill Task Entity Discovery TECH-DDD
Expected output 06_ENTITIES.md
Enter lab
SKILL 2
Skill Task 2

Skill Task 2. Design Relationships, Normalization and Data Ownership

ADD-D03-T02: 3NF ERD and ownership

Build Cardinality, FK and Unique constraints and a third normal form (3NF) model, and state the data owner (Owner) for each Domain.

Target3NF ERD and ownership table
Key toolCodex Client
Lab scopeSkill Task (HYBRID)
Step 1 πŸ“ Set up FK and Cardinality relationships
Step 2 βš™οΈ Resolve many-to-many and assign Domain data owners
Skill Task 3NF ERD Data Ownership
Expected output 06_ERD.md
Enter lab
SKILL 3
Skill Task 3

Skill Task 3. Domain–Flow–ERD Consistency Audit

ADD-D03-T03: Three-way check of outputs and extracting mismatches

Trace whether CRUD data in Sequences exists in the ERD and Domain responsibilities, and find missing Entities and name mismatches.

TargetDomain-Flow-ERD Audit table
Key toolCodex Client
Lab scopeSkill Task (AI)
Step 1 πŸ“ Cross-compare Sequences, ERD and Domain Map
Step 2 πŸ›‘οΈ Create a report on missing attributes and items outside ownership
Skill Task ERD Audit TECH-QA
Expected output erd-audit-report.md
Enter lab
πŸš€ Advanced Missions β€” Data Design Master Course
MISSION 1
Mission 1

Mission 1. Design Decision Record Lab

Mission 01: Auto-write a Design Decision Log (record the Why)

Use Codex to write the reasons behind database normalization and architecture decisions as a structured Design Decision Log.

TargetDesign decision record doc (DDL)
Key toolCodex Client Workspace
Lab scopeDesign Decision Log & Knowledge Mgmt
Step 1 πŸ“‚ Prepare the technical design meeting transcript
Step 2 πŸ” Ask Codex to structure the reasons for each decision
Decision Log Architecture
Expected output design-decision-log.md
Enter assignment room
MISSION 2
Mission 2

Mission 2. Exception Scenario Discovery Lab

Mission 02: Find all concurrencyΒ·integrity Edge Cases

Find concurrency errors and referential integrity risks that can happen in the defined DB schema and reference structure.

TargetException scenario report
Key toolCodex Client Workspace
Lab scopeEdge Case Discovery
Step 1 πŸ“‚ Prepare the DB physical schema doc
Step 2 πŸ›‘οΈ Use Codex to find integrity exception cases
Edge Cases Concurrency
Expected output edge-case-analysis.md
Enter assignment room
MISSION 3
Mission 3

[Assignment] Mission 3. Large-Scale Commerce Order ERD

Skill Mission 1: 3NF normalization and FK/index spec

Design third normal form (3NF) models and an ERD for order, payment, cart and coupon data in a large e-commerce system.

Target3NF ERD and index spec
Key toolCodex Client
Lab scopeSkill Task Mission (Level 1)
Step 1 πŸ“ Normalize scattered raw order data to 3NF
Step 2 βš™οΈ Build FK constraints and a Unique Index doc
Skill Mission Commerce ERD 3NF Normalization
Expected output commerce-erd-specification.md
Enter assignment room
MISSION 4
Mission 4

[Assignment] Mission 4. Logistics Delivery Data Audit

Skill Mission 2: Check global logistics ownership and Sequence consistency

Audit Domain ownership and Sequence-ERD consistency for warehouse, carrier and delivery history data on a global logistics platform.

TargetDomain ownership table & Audit report
Key toolCodex Client
Lab scopeSkill Task Mission (Level 2)
Step 1 πŸ“ Assign ownership of shipping-delivery history data
Step 2 πŸ›‘οΈ Cross-audit missing Flow-ERD attributes
Skill Mission Logistics Audit Data Ownership
Expected output logistics-domain-audit.md
Enter assignment room