음악 연주 및 피드백 데이터
테이블 (5)
MusicPiece
- music_id — ID — 기본 키 — NOT NULL
- title — VARCHAR(200)
- instrument — VARCHAR(50)
Performance
- performance_id — ID — 기본 키 — NOT NULL
- user_id — ID — 외래 키 → User.user_id — NOT NULL
- music_id — ID — 외래 키 → MusicPiece.music_id — NOT NULL
- audio_file_path — VARCHAR(255)
- recorded_at — DATETIME
Segment
- segment_id — ID — 기본 키 — NOT NULL
- start_time — INT
- end_time — INT
- performance_id — ID — 외래 키 → Performance.performance_id — NOT NULL
Untitled5 (Feedback)
- Key (feedback_id) — ID — 기본 키 — NOT NULL
- segment_id — ID — 외래 키 → Segment.segment_id — NOT NULL
- Field (melody) — VARCHAR(250)
- Field (rhythm) — VARCHAR(250)
- Field (harmony) — VARCHAR(250)
- Field (expression) — VARCHAR(250)
- Field (practice_tips) — VARCHAR(250)
- Field (compliments) — VARCHAR(250)
User
- user_id — ID — 기본 키 — NOT NULL
- disability_type — VARCHAR(50)
- created_at — DATETIME