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)