close

Zane Bayanan Bayanai don E-Commerce Bambance-bambancen Samfura da Farashi

Anan ga ƙirar bayanai don sashin samfur a cikin e-commerce, tare da yanayin cewa samfur na iya samun bambance-bambance masu yawa da farashi daban-daban:

Tebur: Products

  • ProductID(ID na samfur): Maɓalli na farko, lamba ta musamman
  • Name(Sunan samfur): Zaren
  • Description: Rubutu
  • CreatedAt: Kwanan wata da lokaci
  • UpdatedAt: Kwanan wata da lokaci

Tebur: Categories

  • CategoryID(Kashi ID): Maɓalli na farko, lamba ta musamman
  • Name(Sunan Nau'in): Zaren

Tebur: ProductVariants

  • VariantID(Bambancin ID): Maɓalli na farko, lamba ta musamman
  • ProductID Teburin samfuran maɓalli na ƙasashen waje
  • Name(Sunan Bambanci): Zaren(misali, Launi, Girma)
  • Value(Bambancin Ƙimar): Kirtani(misali, Ja, XL)

Tebur: Prices

  • PriceID(ID na farashin): Maɓalli na farko, lamba ta musamman
  • VariantID: Maɓallin maɓalli na waje na nuni SamfuraBambancin tebur
  • Price: Decimal
  • Currency: igiya(misali, USD, VND)

Tebur: ProductImages

  • ImageID(ID na Hoto): Maɓalli na farko, lamba ta musamman
  • ProductID Teburin samfuran maɓalli na ƙasashen waje
  • ImageURL: Zare

Tebur: Reviews

  • ReviewID Maɓalli na farko, lamba ta musamman
  • ProductID Teburin samfuran maɓalli na ƙasashen waje
  • Rating: Integer(yawanci daga 1 zuwa 5)
  • Comment: Rubutu
  • CreatedAt: Kwanan wata da lokaci

A cikin wannan ƙira, ProductVariants  teburin ya ƙunshi bayani game da bambance-bambancen samfuri daban-daban, kamar launi, girman. Teburin Prices yana adana bayanan farashi don kowane bambance-bambancen samfur. Kowane bambance-bambancen na iya samun farashi da yawa dangane da agogo daban-daban.

Lura cewa ƙirar bayanai na iya bambanta dangane da takamaiman buƙatun aikin da yadda kuke son sarrafa samfura da farashi.