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)