catalog

Tables (4)

Goods (상품)

  • 상품ID (_id) — Primary key — NOT NULL
  • 제품ID (itemId) — Foreign key → Items.제품ID — NOT NULL
  • 셀러ID (sellerId)
  • shopId
  • Field (status)
  • name
  • imageUrl
  • Field (mainGoodsOptionId)
  • Field (purchasableCount)
  • Field (metadata)
  • Field (delivery)
  • Field (version)
  • Field (createdAt)
  • Field (updatedAt)
  • Field (syncedAt)
  • Field (createdBy)
  • Field (updatedBy)

GoodsOptions (상품 옵션)

  • 옵션ID (_id) — Primary key — NOT NULL
  • 상품ID (goodsId) — Foreign key → Goods.상품ID — NOT NULL
  • 제품ID (itemId) — Foreign key → Goods.제품ID — NOT NULL
  • 메인 여부 (isMain) — boolean
  • 옵션값 (optionValues)
  • 이미지 Urls (imageUrls)
  • 메타 (metadata)
  • 옵션타입 (type)
  • 우선순위 (position)
  • 옵션상태 (status)
  • 재고상태 (stockStatus)
  • 버전 (version)
  • Field (createdAt)
  • Field (updatedAt)
  • Field (createdBy)
  • Field (updatedBy)

Items (제품)

  • 제품ID (_id) — Primary key — NOT NULL
  • 미입점여부 (isUnlisted) — boolean
  • 브랜드ID (brandId)
  • Field (adminCategoryId)
  • 이름 (name)
  • Field (imageUrl)
  • Field (isDiscontinued)
  • Field (optionProperty)
  • Field (metadata)
  • Field (country)
  • Field (status)
  • Field (version)
  • Field (createdAt)
  • Field (updatedAt)
  • Field (syncedAt)
  • Field (createdBy)
  • Field (updatedBy)

productions (레거시 상품)

  • 제품ID (id) — int — Primary key — NOT NULL
  • Field (main_category) — int
  • Field (sub_category) — int
  • 이름 (name) — varchar(255)
  • 가격 (cost) — int
  • Field (size_width) — int
  • Field (size_length) — int
  • int (size_height) — int
  • Field (url) — text
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (style1) — int
  • Field (style2) — int
  • Field (style3) — int
  • Field (brand_id) — int
  • Field (view_count) — int
  • Field (outbound_click_count) — int
  • Field (on_hide) — tinyint(1)
  • Field (image_url) — varchar(255)
  • Field (user_id) — int
  • Field (selling_cost) — int
  • 재고 (stock) — int
  • Field (is_need_assembling) — tinyint(1)
  • Field (assembling_fee) — int
  • Field (can_delivery_to_jeju) — tinyint(1)
  • Field (can_delivery_to_backwoods) — tinyint(1)
  • Field (unique_code) — varchar(255)
  • Field (after_service_phone_number) — varchar(255)
  • Field (after_service_message) — text
  • Field (delivery_method) — int
  • Field (option_is_package) — tinyint(1) — NOT NULL
  • Field (delivery_type) — int
  • Field (delivery_fee) — int — NOT NULL
  • Field (delivery_fee_backwoods) — int — NOT NULL
  • Field (deliver_free_threshold) — int — NOT NULL
  • Field (pay_at) — int
  • Field (selling_address) — varchar(255)
  • Field (cancel_delivery_fee) — int
  • Field (exchange_delivery_fee) — int
  • Field (cancel_exchange_address) — varchar(255)
  • Field (can_cancel_after_delivery) — tinyint(1)
  • Field (need_memo) — tinyint(1)
  • Field (management_code) — varchar(255)
  • Field (noti_type) — int
  • Field (noti_model) — text
  • Field (noti_material) — text
  • Field (noti_color) — text
  • Field (noti_size_weight) — text
  • Field (noti_component) — text
  • Field (noti_manufacturer) — text
  • Field (noti_origin) — text
  • Field (noti_caution) — text
  • Field (noti_qa_criteria) — text
  • Field (noti_as) — text
  • Field (noti_model_c_at) — text
  • Field (noti_kc_no) — text
  • Field (noti_spec) — text
  • Field (noti_extra_cost) — text
  • Field (share_count) — int
  • Field (delivery_group_id) — int
  • … +3