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