내가갑이야 오픈

테이블 (19)

board

  • board_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • board_type — VARCHAR(50) — NOT NULL — 게시판 유형
  • board_genre — VARCHAR(50) — 음악 장르
  • like_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • deleted — TINYINT — NOT NULL — 0: 정상, 1: 삭제
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

board_like

  • board_like_id — BIGINT — 기본 키 — NOT NULL
  • board_id — BIGINT — 외래 키 → board.board_id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

board_song

  • id — BIGINT — 기본 키 — NOT NULL
  • board_id — BIGINT — 외래 키 → board.board_id — NOT NULL
  • song_id — BIGINT — 외래 키 → song.id — NOT NULL
  • order_index — INT — NOT NULL

collabo_playlist_participant

  • id — BIGINT — 기본 키 — NOT NULL
  • playlist_id — BIGINT — 외래 키 → playlist.id — NOT NULL
  • song_id (id2) — BIGINT — 외래 키 → song.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

goods

  • goods_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • stock — INT — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • image_url — VARCHAR(512)
  • created_at — DATETIME — NOT NULL

goods_order

  • order_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • total_amount — INT — NOT NULL
  • status — VARCHAR(50) — NOT NULL — PENDING / PAID / DELIVERED / CANCELLED
  • delivery_address — VARCHAR(500) — NOT NULL
  • receiver_name — VARCHAR(100) — NOT NULL
  • receiver_phone — VARCHAR(20) — NOT NULL
  • toss_order_id — VARCHAR(255) — 토스페이먼츠 주문 ID
  • carrier_id — VARCHAR(100) — 택배사 코드
  • tracking_number — VARCHAR(100) — 운송장 번호
  • created_at — DATETIME — NOT NULL

order_item

  • order_item_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → goods_order.order_id — NOT NULL
  • goods_id — BIGINT — 외래 키 → goods.goods_id — NOT NULL
  • quantity — INT — NOT NULL
  • price — INT — NOT NULL — 주문 당시 단가

playlist

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — VARCHAR(500)
  • genre — VARCHAR(100)
  • image_url — VARCHAR(512)
  • type — VARCHAR(50) — NOT NULL — RECOMMENDED / SHARED / COLLABORATIVE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

playlist_song

  • id — BIGINT — 기본 키 — NOT NULL
  • song_id — BIGINT — 외래 키 → song.id — NOT NULL
  • playlist_id — BIGINT — 외래 키 → playlist.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

point_history

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • amount — INT — NOT NULL — 변동 포인트 (음수 가능)
  • point_type — VARCHAR(50) — NOT NULL — 적립 / 사용 / 만료
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reply

  • reply_id — BIGINT — 기본 키 — NOT NULL
  • board_id — BIGINT — 외래 키 → board.board_id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • like_count — INT — NOT NULL
  • deleted — TINYINT — NOT NULL — 0: 정상, 1: 삭제
  • parent_reply_id — BIGINT — 대댓글 부모 reply_id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reply_like

  • reply_like_id — BIGINT — 기본 키 — NOT NULL
  • reply_id — BIGINT — 외래 키 → reply.reply_id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

review

  • id — BIGINT — 기본 키 — NOT NULL
  • playlist_id — BIGINT — 외래 키 → playlist.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL — 한줄평
  • rating — INT — NOT NULL — 0~5 사이의 값
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

song

  • id — BIGINT — 기본 키 — NOT NULL
  • track_name — VARCHAR(255) — NOT NULL
  • artist_name — VARCHAR(255) — NOT NULL
  • genre_name — VARCHAR(100) — NOT NULL
  • img_url — VARCHAR(512)
  • preview_url — VARCHAR(512)
  • duration_ms — BIGINT
  • release_date — DATE
  • created_at — DATETIME — NOT NULL

user_login_log

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • ip — VARCHAR(45) — NOT NULL
  • login_type — VARCHAR(50) — NOT NULL — LOCAL / SOCIAL
  • login_at — DATETIME — NOT NULL

user_point

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • total_point — INT — NOT NULL
  • grade — VARCHAR(50) — NOT NULL — BRONZE / SILVER / GOLD / PLATINUM
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_social_accounts

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL — GOOGLE / KAKAO / NAVER
  • provider_id — VARCHAR(255) — NOT NULL
  • connected_at — DATETIME — NOT NULL
  • disconnected_at — DATETIME

users

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • birth_date — DATE
  • phone_number — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • address_detail — VARCHAR(255)
  • img_url — VARCHAR(512)
  • ci — VARCHAR(255) — 본인인증 CI값
  • role — VARCHAR(50) — NOT NULL — USER / ADMIN
  • state — TINYINT — NOT NULL — 0: 비활성, 1: 활성
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

알림 (notification)

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • board_id — BIGINT
  • message — VARCHAR(500) — NOT NULL
  • is_read — TINYINT — NOT NULL — 0: 미읽음, 1: 읽음
  • created_at — DATETIME — NOT NULL