음악 연주 및 피드백 데이터

테이블 (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