soundbrew
Tables (13)
album (Untitled3)
- album_id (앨범 ID) — Primary key — NOT NULL
- album_name (앨범명)
- album_info (앨범 설명)
cart (장바구니)
- cart_id (장바구니 id) — Primary key — NOT NULL
- user_id (회원번호) — Foreign key → user.user_id — NOT NULL
- create_at (생성일)
cartitem (장바구니(아이템))
- cart_item_id (장바구니(아이템) id) — Primary key — NOT NULL
- cart_id (장바구니 id) — Foreign key → cart.cart_id — NOT NULL
- user_id (회원번호) — Foreign key → cart.user_id — NOT NULL
- item_price (음원 가격)
- item_id (음원 id)
category (Untitled4)
- category_id (카테고리 id) — Primary key — NOT NULL
- category_name (카테고리명)
download (다운로드)
- download_id (고유 ID) — Primary key — NOT NULL
- user_id (회원번호) — Foreign key → user.user_id — NOT NULL
- music_id (음악 고유 ID) — Foreign key → music.music_id — NOT NULL
- download_at (다운로드 날짜)
file (파일)
- file_id (파일 ID) — Primary key — NOT NULL
- question_id (고유 ID) — Foreign key → question.question_id — NOT NULL
- file_type (파일 확장자)
- file_path (파일 경로)
music (Untitled2)
- music_id (음악 고유 ID) — Primary key — NOT NULL
- album_id (앨범 ID) — Foreign key → album.album_id — NOT NULL
- category_id (카테고리 id) — Foreign key → category.category_id — NOT NULL
- title (음원 제목)
- catagory (카테고리)
- price (가격)
- file_path (음악 경로)
- license_type (라이센스)
- create_at (생성날짜)
music_tag (Untitled11)
- music_tag_id (테이블 ID) — Primary key — NOT NULL
- music_id (음악 고유 ID) — Foreign key → music.music_id — NOT NULL
- tag_id (태그 ID) — Foreign key → tag.tag_id — NOT NULL
question (Untitled6)
- question_id (고유 ID) — Primary key — NOT NULL
- category_id (카테고리 id) — Foreign key → category.category_id — NOT NULL
- category (카테고리)
- title (제목)
- writer (작성자)
- content (내용)
- create_at (작성일)
- update_at (수정일)
subscription (Untitled)
- role_id (역할 번호) — Primary key — NOT NULL
- role_name (역할 이름)
- role_description (역할 설명)
tag (Untitled9)
- tag_id (태그 ID) — Primary key — NOT NULL
- tag_name (태그 명)
user (사용자)
- user_id (회원번호) — Primary key — NOT NULL
- email (이메일)
- password (비밀번호)
- username (이름)
- create_at (계정 생성일)
- update_at (계정 수정일)
- birth (생년월일)
- subscription (구독 상태)
user_subscription (Untitled5)
- subscription_id (고유 ID) — Primary key — NOT NULL
- user_id (회원번호) — Foreign key → user.user_id — NOT NULL
- role_id (역할 넘버) — Foreign key → subscription.role_id — NOT NULL