goody

Tables (16)

Untitled4 (chat_inquiry)

  • id (Key2) — Primary key — NOT NULL
  • inquiry_id (Key) — Foreign key → inquiries.id — NOT NULL
  • chat_room_id (Key3) — Foreign key → char_rooms.id — NOT NULL

artists (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • kor_name (Field)
  • eng_name (Field3)
  • normalized_eng_name (Field2)

char_rooms (Untitled13)

  • id (Key) — 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

chat_messages (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • chat_room_id (Key2) — Foreign key → char_rooms.id — NOT NULL
  • content (Field)
  • type (Field2)
  • is_read (Field3)
  • sent_at (Field4)

goods_categories (굿즈 카테고리)

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

inquiries (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • inquirer_id (Key2) — Foreign key → users.id — NOT NULL
  • post_owner_id (Key4) — Foreign key → users.id — NOT NULL
  • post_id (Key3) — Foreign key → posts.id — NOT NULL
  • status (Field)
  • total_price (Field2)
  • has_inquirer_reviewed (Field4)
  • has_post_owner_reviewed (Field5)
  • created_at (Field3)
  • completed_at (Field6)

inquiry_items (Untitled12)

  • id (Key) — Primary key — NOT NULL
  • inquiry (Key2) — Foreign key → inquiries.id — NOT NULL
  • post_item_id (Key3) — Foreign key → post_items.id — NOT NULL
  • quantity (Field)
  • price (Field2)

post_items (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → posts.id — NOT NULL
  • title (Field)
  • price (Field2)
  • is_available (Field3)
  • max_quantity_per_buyer (Field7)
  • thumbnail_url (Field4)
  • image1_url (Field5)
  • image2_url (Field6)
  • display_order (Field8)

post_shipping

  • id (post_id) — Foreign key → posts.id — NOT NULL
  • id (shipping_method_id) — Foreign key → shipping_methods.id — NOT NULL

posts (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • description (Field2)
  • thumbnail_url (Field3)
  • artist_id (Key2) — Foreign key → artists.id — NOT NULL
  • goods_category_id (Key3) — Foreign key → goods_categories.id — NOT NULL
  • user_id (Key5) — Foreign key → users.id — NOT NULL
  • status (Field6)
  • view_count (Field7)
  • post_type (Field8)
  • created_at (Field4)
  • updated_at (Field5)
  • hashtag1 (Field9)
  • hashtag2 (Field10)
  • hashtag3 (Field11)
  • hashtag4 (Field12)
  • hashtag5 (Field13)

posts_image (Untitled9)

  • id (Key2) — Primary key — NOT NULL
  • post_id (Key) — Foreign key → posts.id — NOT NULL
  • image_url (Field)

reviews (Untitled7)

  • id (Key) — 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 (Field)
  • comment (Field2)
  • created_at (Field3)

shipping_methods

  • id — Primary key — NOT NULL
  • name

user_favorite_artists (Untitled8)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • artist_id (Key3) — Foreign key → artists.id — NOT NULL

users (Untitled)

  • id (Key) — Primary key — NOT NULL
  • uuid (Field)
  • nickname (Field2)
  • profile_image_url (Field3)
  • email (Field4)
  • oauthProvider (Field6)
  • createdAt (Field5)
  • review_rating (Field7)
  • total_reviews (Field8)
  • is_verified (Field9)
  • chat_available_start_time (Field10) — Number
  • Field11

wishlists (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • post_id (Key3) — Foreign key → posts.id — NOT NULL