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