music_db

Tables (10)

File

  • file_id — INT — Primary key — NOT NULL
  • track_id — INT — Foreign key → Track.track_id — NOT NULL
  • type — ENUM('BEAT', 'LOOP', 'STEM', 'ZIP', 'MIDI') — NOT NULL
  • file_path — VARCHAR(255) — NOT NULL
  • quality — TINYINT — 0=일반, 1=!, 2=!!
  • created_at — DATETIME

Pack

  • pack_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • price — DECIMAL(10,2)
  • created_at — DATETIME

Pack_File

  • pack_id — INT — Foreign key → Pack.pack_id — NOT NULL
  • file_id — INT — Foreign key → File.file_id — NOT NULL

Producer

  • producer_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • instagram_id — VARCHAR(100)
  • telegram_id — VARCHAR(100)
  • email — VARCHAR(150)
  • country — CHAR(2)

Release

  • release_id — INT — Primary key — NOT NULL
  • file_id — INT — Foreign key → File.file_id — NOT NULL
  • platform — VARCHAR(100)
  • sale_type — ENUM('free','lease','exclusive','released') — NOT NULL
  • release_title — VARCHAR(150)
  • artist_name — VARCHAR(150)
  • price — DECIMAL(10,2)
  • url — VARCHAR(255)
  • released_at — DATE

Sample

  • sample_id — INT — Primary key — NOT NULL
  • track_id — INT — Foreign key → Track.track_id — NOT NULL
  • original_title — VARCHAR(150)
  • original_artist — VARCHAR(150)
  • source_url — VARCHAR(255)
  • clearance — ENUM('uncleared','pending','cleared')

Tag

  • tag_id — INT — Primary key — NOT NULL
  • tag_name — VARCHAR(100) — NOT NULL
  • category — ENUM('genre','mood','artist','flag','etc')

Track

  • track_id — INT — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • bpm — FLOAT
  • key_sig — VARCHAR(10)
  • detune — FLOAT — cent 단위, +32 = 32cent 샤프
  • created_at — DATETIME

Track_Producer

  • track_id — INT — Foreign key → Track.track_id — NOT NULL
  • producer_id — INT — Foreign key → Producer.producer_id — NOT NULL
  • role — ENUM('main','collaborator')

Track_Tag

  • track_id — INT — Foreign key → Track.track_id — NOT NULL
  • tag_id — INT — Foreign key → Tag.tag_id — NOT NULL