ART.SEUNGA

Tables (3)

Products (Untitled)

  • bigint (id) — Primary key — NOT NULL
  • name — 상품명
  • varchar (internal_code) — 자체상품코드
  • enum (status) — 등록상태
  • datetime (created_at)
  • datetime (updated_at)
  • Field

product_shipping_info (Untitled2)

  • bigint (id) — Primary key — NOT NULL
  • bigint (shipping_setting_type) — 배송설정유형 — Foreign key → Products.bigint — NOT NULL
  • int (id2) — Foreign key → shipping_templates.int — NOT NULL
  • int (shipping_template_id)
  • enum (status) — 등록상태
  • datetime (created_at)
  • datetime (updated_at)

shipping_templates (Untitled3)

  • int (id) — Primary key — NOT NULL
  • int (seller_id)
  • varchar (name) — 템플릿명
  • enum (shipping_method) — 배송방법
  • enum (shipping_fee_type) — 배송비유형
  • Field (total_weight_kg) — 총중량