MIS_HW
Tables (10)
ItemAttributes
- id (Key) — VARCHAR(50) — Primary key — NOT NULL
- sellerProductItemId — INT — Foreign key
- attributeTypeName — VARCHAR(100)
- attributeValueName — VARCHAR(255)
- exposed — VARCHAR(50)
- editable — TINYINT
ItemCertifications
- id (Key) — VARCHAR(50) — Primary key — NOT NULL
- sellerProductItemId — INT — Foreign key
- certificationType — VARCHAR(50)
- certificationCode — VARCHAR(100)
ItemContents
- id — VARCHAR(50) — Primary key
- sellerProductItemId — INT — Foreign key
- contentsType — VARCHAR(50)
- content — TEXT
- detailType — VARCHAR(50)
ItemExtraProperties
- id (Key) — VARCHAR(50) — Primary key — NOT NULL
- transactionType — VARCHAR(50)
- onlineSalePriceForBooks — VARCHAR(50)
- coupangSalePrice — VARCHAR(50)
- businessType — VARCHAR(100)
- sellerProductItemId (Key2) — INT — Foreign key → ProductItems.sellerProductItemId — NOT NULL
ItemImages
- id — VARCHAR(50) — Primary key
- sellerProductItemId — INT — Foreign key
- imageOrder — INT
- imageType — VARCHAR(50)
- cdnPath — VARCHAR(255)
- vendorPath — VARCHAR(255)
ItemNotices
- id — VARCHAR(50) — Primary key
- sellerProductItemId — INT — Foreign key
- noticeCategoryName — VARCHAR(100)
- noticeCategoryDetailName — VARCHAR(100)
- content — TEXT
ItemSearchTags
- id — INT — Primary key
- tag — VARCHAR(100)
ItemSearchTags-ProductItems (ItemSerachTagProductItems)
- sellerProductItemId (Key) — INT — Foreign key → ProductItems.sellerProductItemId — NOT NULL
- id — INT — Foreign key → ItemSearchTags.id
ProductItems
- sellerProductItemId (Key) — INT — Primary key — NOT NULL
- productId — INT — Foreign key → Products.productId
- vendorItemId — INT
- itemId — INT
- itemName — VARCHAR(255)
- originalPrice — INT
- salePrice — INT
- supplyPrice — INT
- maximumBuyCount — INT
- maximumBuyForPerson — INT
- outboundShippingTimeDay — INT
- maximumBuyForPersonPeriod — INT
- unitCount — INT
- adultOnly — VARCHAR(50)
- freePriceType — VARCHAR(50)
- taxType — VARCHAR(50)
- parallelImported — VARCHAR(50)
- overseasPurchased — VARCHAR(50)
- externalVendorSku — VARCHAR(100)
- pccNeeded — TINYINT
- bestPriceGuaranteed3P — TINYINT
- emptyBarcode — TINYINT
- emptyBarcodeReason — VARCHAR(255)
- barcode — VARCHAR(100)
- saleAgentCommission — FLOAT
- modelNo — VARCHAR(100)
Products
- productId — INT — Primary key
- sellerProductId — INT
- sellerProductName — VARCHAR(255)
- displayCategoryCode — INT
- categoryId — INT
- vendorId — VARCHAR(50)
- mdId — VARCHAR(50)
- mdName — VARCHAR(100)
- saleStartedAt — DATETIME
- saleEndedAt — DATETIME
- displayProductName — VARCHAR(255)
- brand — VARCHAR(100)
- generalProductName — VARCHAR(255)
- productGroup — VARCHAR(100)
- statusName — VARCHAR(50)
- deliveryMethod — VARCHAR(50)
- deliveryCompanyCode — VARCHAR(50)
- deliveryChargeType — VARCHAR(50)
- deliveryCharge — INT
- freeShipOverAmount — INT
- deliveryChargeOnReturn — INT
- deliverySurcharge — INT
- remoteAreaDeliverable — TINYINT
- bundlePackingDelivery — INT
- unionDeliveryType — VARCHAR(50)
- returnCenterCode — VARCHAR(50)
- returnChargeName — VARCHAR(100)
- companyContactNumber — VARCHAR(20)
- returnZipCode — VARCHAR(10)
- returnAddress — VARCHAR(255)
- returnAddressDetail — VARCHAR(255)
- returnCharge — INT
- outboundShippingPlaceCode — INT
- vendorUserId — VARCHAR(100)
- requested — TINYINT
- manufacture — VARCHAR(100)
- bundleType — VARCHAR(50)