내가갑이야 오픈
테이블 (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