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