GOODY-ERD

Tables (25)

Untitled (user_notification)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • Field (title)
  • Field (content)
  • Field (screen)
  • Field (screen_id)

Untitled (bank_accounts)

  • Key — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • Field (bank_name)
  • Field (user_name)
  • Field (account_number)

Untitled (review_keyword)

  • Key (id) — Primary key — NOT NULL
  • Field (name)

Untitled2 (user_address)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • Field (user_name)
  • Field (user_phone_number)
  • Field (address)
  • Field (postal_code)

artists

  • id — Primary key — NOT NULL
  • display_name
  • kor_name
  • eng_name
  • normalized_eng_name

char_rooms

  • id — Primary key — NOT NULL
  • id (post_id) — Foreign key → posts.id — NOT NULL
  • id (inquirer_id) — Foreign key → users.id — NOT NULL
  • id (post_owner_id) — Foreign key → users.id — NOT NULL
  • Field (created_at)
  • Field (last_message_at)

chat_messages

  • id — Primary key — NOT NULL
  • chat_room_id — Foreign key → char_rooms.id — NOT NULL
  • sender_id — Foreign key → users.id — NOT NULL
  • content
  • type
  • is_read
  • sent_at

community_comments (Untitled3)

  • Key (id) — Primary key — NOT NULL
  • id (community_post_id) — Foreign key → community_posts.id — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • Field (content)
  • Field (created_at)
  • Field (is_edited)
  • Field (is_deleted)
  • Field (parent_id (self))

community_post_likes (Untitled2)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • id (community_post_id) — Foreign key → community_posts.id — NOT NULL

community_post_notification_mutes (Untitled4)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • id (community_post_id) — Foreign key → community_posts.id — NOT NULL

community_posts (Untitled)

  • id — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • id (artist_id) — Foreign key → artists.id — NOT NULL
  • Field (description)
  • Field (img_url1)
  • Field (img_url2)
  • Field (img_url3)
  • Field (img_url4)
  • Field (created_at)
  • Field (category)
  • Field (liked_count)
  • Field (comment_count)
  • Field (is_deleted)
  • Field (is_edited)

goods_categories

  • id — Primary key — NOT NULL
  • name

inquiries

  • id — Primary key — NOT NULL
  • inquirer_id — Foreign key → users.id — NOT NULL
  • post_owner_id — Foreign key → users.id — NOT NULL
  • post_id — Foreign key → posts.id — NOT NULL
  • chat_room_id — Foreign key → char_rooms.id — NOT NULL
  • status
  • total_price
  • 구매자 리뷰 작성 여부 (has_inquirer_reviewed) — Boolean
  • created_at
  • completed_at

inquiry_items

  • id — Primary key — NOT NULL
  • inquiry — Foreign key → inquiries.id — NOT NULL
  • post_item_id — Foreign key → post_items.id — NOT NULL
  • quantity
  • price

post_items

  • id — Primary key — NOT NULL
  • post_id — Foreign key → posts.id — NOT NULL
  • title
  • price
  • is_available
  • max_quantity_per_buyer
  • thumbnail_url
  • image1_url
  • image2_url
  • display_order
  • 처음 등록한 총 판매 개수 (total_quantity)
  • 거래 가능한 현재 개수 (available_quantity)

post_search_keywords

  • Key (id) — Primary key — NOT NULL
  • id (post_id) — Foreign key → posts.id — NOT NULL
  • Field2 (keyword)
  • Field (type) — IN('TITLE', 'HASHAG', 'ITEM_TITLE')

post_shipping

  • Key (id) — Primary key — NOT NULL
  • id (post_id) — Foreign key → posts.id — NOT NULL
  • Key (shipping_method_id) — Foreign key → 배송방법.Key — NOT NULL

posts

  • id — Primary key — NOT NULL
  • title
  • description
  • is_negotiable
  • thumbnail_url
  • artist_id — Foreign key → artists.id — NOT NULL
  • goods_category_id — Foreign key → goods_categories.id — NOT NULL
  • user_id — Foreign key → users.id — NOT NULL
  • status
  • post_type
  • created_at
  • updated_at
  • hashtag1
  • hashtag2
  • hashtag3
  • hashtag4
  • hashtag5
  • liked_count (Field)
  • view_count
  • chatRoom_count (Field2)

posts_image (Untitled9)

  • id — Primary key — NOT NULL
  • post_id — Foreign key → posts.id — NOT NULL
  • image_url
  • 사진 보여줄 순서 (display_order)

review_statistics

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → users.id — NOT NULL
  • Key (keyword_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (count)

reviews

  • id — Primary key — NOT NULL
  • id (inquiry_id) — Foreign key → inquiries.id — NOT NULL
  • id (reviewer_id) — Foreign key → users.id — NOT NULL
  • id (reviewee_id) — Foreign key → users.id — NOT NULL
  • rating
  • comment
  • created_at
  • Key (keyword1) — Foreign key → Untitled.Key — NOT NULL
  • Key (keyword2) — Foreign key → Untitled.Key — NOT NULL
  • Key (keyword3) — Foreign key → Untitled.Key — NOT NULL

user_favorite_artists

  • id — Primary key — NOT NULL
  • user_id — Foreign key → users.id — NOT NULL
  • artist_id — Foreign key → artists.id — NOT NULL

users

  • id — Primary key — NOT NULL
  • uuid
  • nickname
  • profile_image_url
  • email
  • oauthProvider
  • 생성일 (created_at)
  • 리뷰 점수 (review_rating)
  • 리뷰 개수 (received_review_count)
  • Field (completed_inquiry_count)
  • 인증여부 (is_verified) — Boolean
  • 채팅 가능 시작시간 (chat_available_start_time) — Number
  • 채팅가능 종료 시간 (chat_available_end_time) — Number
  • Field (status)
  • 회원탈퇴시각 (withdraw_at)

wishlists

  • id — Primary key — NOT NULL
  • user_id — Foreign key → users.id — NOT NULL
  • post_id — Foreign key → posts.id — NOT NULL

배송방법 (shipping_methods)

  • Key (id) — Primary key — NOT NULL
  • Field (name)