Slippy
테이블 (17)
post_tags
- post_id — bigint — 외래 키 → 게시물.id — NOT NULL
- hashtag — varchar(255)
review
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → 회원관리.id — NOT NULL
- product_id — bigint — 외래 키 → 상품관리.id — NOT NULL
- like_count — int — NOT NULL
- rating — int — NOT NULL
- created_at — datetime(6)
- content — text — NOT NULL
- image_url — varchar(255)
- is_hidden — tinyint(1) — NOT NULL
- report_count — int — NOT NULL
review_report
- id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- member_id — bigint — NOT NULL
- review_id — bigint — NOT NULL
- id (id2) — bigint — 외래 키 → review.id — NOT NULL
게시물 (post)
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → 회원관리.id — NOT NULL
- like_count — int — NOT NULL
- view_count — int — NOT NULL
- created_at — datetime(6)
- content — text — NOT NULL
- image_url — varchar(255)
- title — varchar(255) — NOT NULL
- board_type — varchar(255) — NOT NULL
- is_hidden — tinyint(1) — NOT NULL
- comment_count — int — NOT NULL
- popularity_score — double — NOT NULL
- thumbnail_url — varchar(255)
- is_pinned — tinyint(1) — NOT NULL
게시물 좋아요 (post_like)
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — NOT NULL
- post_id — bigint — NOT NULL
- id (id2) — bigint — 외래 키 → 게시물.id — NOT NULL
- id (id3) — bigint — 외래 키 → 회원관리.id — NOT NULL
댓글 및 대댓글 (comment)
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → 게시물.id — NOT NULL
- parent_id — bigint — 외래 키 → 댓글 및 대댓글.id
- post_id — bigint — 외래 키 → 회원관리.id
- created_at — datetime(6)
- review_id — bigint
- content — text — NOT NULL
- is_hidden — tinyint(1) — NOT NULL
문의하기 (inquiry)
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → 회원관리.id — NOT NULL
- content — text — NOT NULL
- created_at — datetime(6)
- reply — text
- status — enum('ANSWERED','PENDING') — NOT NULL
- title — varchar(255) — NOT NULL
브랜드스크랩 (brand_scrap)
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → 회원관리.id — NOT NULL
- seller_id — bigint — 외래 키 → 회원관리.id — NOT NULL
- created_at — datetime(6)
상품관리 (product)
- id — bigint — 기본 키 — NOT NULL
- member_id (seller_id) — bigint — 외래 키 → 회원관리.id — NOT NULL
- price — int — NOT NULL
- release_date — date
- created_at — datetime(6)
- description — text
- description_image_url — varchar(2000)
- image_url — varchar(2000)
- purchase_url — varchar(2000)
- video_url — varchar(2000)
- name — varchar(255)
- shop_name — varchar(255)
- texture — varchar(255)
- video_type — varchar(255)
- category — varchar(255)
- is_hidden — tinyint(1) — NOT NULL
- avg_rating — double
- review_count — int
- updated_at — datetime
상품찜하기 (wishlist)
- id — bigint — 기본 키 — NOT NULL
- product_id — bigint — 외래 키 → 상품관리.id — NOT NULL
- member_id — bigint — 외래 키 → 회원관리.id — NOT NULL
- created_at — datetime(6)
상품태그 (product_tag)
- id — bigint — 기본 키 — NOT NULL
- product_id — bigint — 외래 키 → 상품관리.id — NOT NULL
- tag_id — bigint — 외래 키 → 태그.id — NOT NULL
신고 (report)
- id — bigint — 기본 키 — NOT NULL
- member_id (reporter_id) — bigint — 외래 키 → 회원관리.id — NOT NULL
- created_at — datetime(6)
- reason — varchar(1000) — NOT NULL
- status — enum('PENDING','RESOLVED') — NOT NULL
- target_id — bigint — NOT NULL
- target_type — enum('POST','COMMENT','PRODUCT','REVIEW') — NOT NULL
알림 (notification)
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → 회원관리.id — NOT NULL
- created_at — datetime(6) — NOT NULL
- is_read — bit(1) — NOT NULL
- message — varchar(255) — NOT NULL
- related_url — varchar(255)
- type — enum('NEW_COMMENT','NEW_LIKE','SYSTEM_ALERT','NEW_MESSAGE','WISHLIST_UPDATE','SELLER_APPROVAL','SELLER_REJECTED','NEW_REVIEW','NEW_SELLER_APPLICATION','NEW_REPORT','NEW_INQUIRY','INQUIRY_ANSWERED') — NOT NULL
- notification_type — enum('INQUIRY_ANSWERED','NEW_COMMENT','NEW_INQUIRY','NEW_LIKE','NEW_MESSAGE','NEW_REPORT','NEW_REVIEW','NEW_SELLER_APPLICATION','SELLER_APPROVAL','SELLER_REJECTED','SYSTEM_ALERT','WISHLIST_UPDATE') — NOT NULL
좋아요 (likes)
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → 회원관리.id — NOT NULL
- target_id — bigint — NOT NULL
- target_type — enum('POST','REVIEW') — NOT NULL
태그 (tag)
- id — bigint — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
판매자승인 (seller_application)
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → 회원관리.id — NOT NULL
- introduction — text
- rejection_reason — text
- site_url — varchar(255) — NOT NULL
- status — enum('APPROVED','PENDING','REJECTED') — NOT NULL
- shop_name — varchar(255) — NOT NULL
- sns_urls — varchar(1000)
- business_number — varchar(20) — NOT NULL
회원관리 (member)
- id — bigint — 기본 키 — NOT NULL
- onboarded — tinyint(1) — NOT NULL
- created_at — datetime(6)
- email — varchar(255)
- nickname — varchar(255)
- oauth_access_token — varchar(255)
- oauth_provider — varchar(255)
- oauth_refresh_token — varchar(255)
- password — varchar(255) — NOT NULL
- username — varchar(255)
- role — enum('ADMIN','BUYER','SELLER','USER') — NOT NULL
- last_login_at — datetime(6)
- profile_image_url — varchar(255)
- shop_name — varchar(255)
- shop_url — varchar(255)
- sns_urls — varchar(1000)
- status — varchar(255) — NOT NULL
- introduction — varchar(255)
- site_url — varchar(255)
- facebook_url — varchar(255)
- instagram_url — varchar(255)
- tiktok_url — varchar(255)
- youtube_url — varchar(255)