soundary

Tables (17)

account_policy (사용자_약관동의)

  • code (약관코드) — Foreign key → policy.code — NOT NULL
  • version (약관버전) — Foreign key → policy.version — NOT NULL
  • id (사용자id) — Foreign key → users.id — NOT NULL

accounts (계정)

  • id (계정id) — Primary key — NOT NULL
  • user_id (사용자id) — Foreign key → users.id — NOT NULL
  • password (비밀번호)
  • login_id (로그인 아이디)
  • account_type (가입유형)

announcement (공지사항)

  • id (공지사항Id) — Primary key — NOT NULL
  • title (제목)
  • content (내용)

audio (오디오)

  • id (오디오id) — Primary key — NOT NULL
  • id (악기id) — Foreign key → instruments.id — NOT NULL
  • s3_key (s3 key)
  • code (악기 음 값 (1 ~ 84))
  • name (음 설명)
  • Field

instruments (악기)

  • id (악기id) — Primary key — NOT NULL
  • id (상품id) — Foreign key → product.id — NOT NULL
  • instrumentName (악기명)
  • instrumentType (악기타입)

notification (알림)

  • id (알림id) — Primary key — NOT NULL
  • send_id (발신자_id)

payments (결제)

  • id (결제_id) — Primary key — NOT NULL
  • product_id (결제한상품id)
  • user_id (결제한유저아이디)
  • success_yn (성공여부)
  • fail_message (실패사유)
  • type (결제타입)
  • amount (금액)

policy (약관리스트)

  • code (약관코드) — Primary key — NOT NULL
  • version (약관버전) — Primary key — NOT NULL
  • name (약관명)
  • content (약관내용)
  • required (필수여부)
  • use_yn (사용여부)

product (상품)

  • id (상품id) — Primary key — NOT NULL
  • type (상품타입)
  • code (상품코드)
  • name (상품명)
  • price (상품가격)

project_action_history (프로젝트 액션히스토리)

  • id (프로젝트 액션히스토리id) — Primary key — NOT NULL
  • id (프로젝트id) — Foreign key → projects.id — NOT NULL
  • data (json데이터)

project_object_history (프로젝트 객체히스토리)

  • id (프로젝트 객체히스토리id) — Primary key — NOT NULL
  • id (프로젝트id) — Foreign key → projects.id — NOT NULL
  • data (json데이터)

project_socket (프로젝트 소켓 정보)

  • id (소켓 Id) — Primary key — NOT NULL
  • project_id (프로젝트id) — Foreign key → projects.id — NOT NULL
  • port (소켓 접속 포트)

projects (프로젝트)

  • id (프로젝트id) — Primary key — NOT NULL
  • public_yn (공개여부)
  • name (프로젝트명)
  • description (설명)
  • genre (장르)
  • image_url (커버이미지url)
  • data (프로젝트JSON데이터)

toss_payments (토스결제이력)

  • id (토스결제_id) — Primary key — NOT NULL
  • payments_id (결제_id) — Foreign key → payments.id — NOT NULL
  • payment_type (결제 타입)
  • order_id (주문번호)
  • payment_key (토스페이먼츠 키)

user_product (보유_상품)

  • user_id (사용자id) — Foreign key → users.id — NOT NULL
  • id (상품id) — Foreign key → product.id — NOT NULL

user_project (사용자_프로젝트)

  • id (사용자_프로젝트id) — Primary key — NOT NULL
  • user_id (사용자id) — Foreign key → users.id — NOT NULL
  • project_id (프로젝트id) — Foreign key → projects.id — NOT NULL
  • owner_yn (오너여부)

users (사용자)

  • id (사용자id) — Primary key — NOT NULL
  • profile_iamge_url (프로필이미지url)
  • alias (닉네임)
  • introduce (자기소개)
  • genre (선호장르)
  • job (직업)