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
- 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)