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