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