Global

Tables (10)

Channel Integrations (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • global_product_id (Key2) — BIGINT — Foreign key → global product.global_product_id — NOT NULL
  • channel_id (FK) — BIGINT — Foreign key → Integration Channels.id — NOT NULL
  • status (Field2) — ENUM(LISTED, REJECTED)

Integration Channels (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • channel_name (Field) — VARCHAR
  • country (Field2) — VARCHAR

Product (상품 테이블)

  • goodsno (PK) — BIGINT — Primary key — NOT NULL
  • seller_id (FK) — BIGINT — Foreign key → Seller.seller_id — NOT NULL

Seller (셀러 테이블)

  • seller_id (PK) — BIGINT — Primary key — NOT NULL
  • Field

Seller Channel Settings (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Field

external_product (크롤링 상품)

  • goodsno (Key) — BIGINT — Primary key — NOT NULL

global product (글로벌 상품 테이블)

  • global_product_id (Key) — BIGINT — Primary key — NOT NULL
  • goodsno (PK2) — BIGINT — Foreign key → Product.goodsno — NOT NULL
  • goodsno (Key2) — BIGINT — Foreign key → external_product.goodsno — NOT NULL
  • source_type (Field) — ENUM

global_product_images (글로벌 상품 이미지)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • global_product_id (PK) — BIGINT — Foreign key → global product.global_product_id — NOT NULL
  • image_url (Field) — VARCHAR
  • display_order (Field2) — INT

global_product_translations (글로벌 상품 번역)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • global_product_id (Key2) — BIGINT — Foreign key → global product.global_product_id — NOT NULL
  • language_code (Field) — VARCHAR
  • name (Field2) — VARCHAR

seller (Untitled4)