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 (직업)