Ƙirar Database don E-Commerce Siyayyar Siyayya tare da Bambancin Samfura

Anan ga ƙirar bayanai don sashin siyayya a cikin e-commerce, tare da samfuran da ke da halaye da yawa da farashi masu yawa:

Tebur: Users

• UserID Maɓalli na farko, lamba ta musamman
• Username: Zare
• Email: Zare
• Password: Zare
• CreatedAt: Kwanan wata da lokaci
• UpdatedAt: Kwanan wata da lokaci

Tebur: Carts

• CartID Maɓalli na farko, lamba ta musamman
• UserID Teburin masu amfani da maɓalli na waje
• CreatedAt: Kwanan wata da lokaci
• UpdatedAt: Kwanan wata da lokaci

Tebur: CartItems

• CartItemID Maɓalli na farko, lamba ta musamman
• CartID: Tebur na maɓalli na waje
• ProductID Teburin samfuran maɓalli na ƙasashen waje
• VariantID: Maɓallin maɓalli na waje na nuni SamfuraBambancin tebur
• Quantity: lamba
• CreatedAt: Kwanan wata da lokaci
• UpdatedAt: Kwanan wata da lokaci

Tebur: Products

• ProductID Maɓalli na farko, lamba ta musamman
• Name: Zare
• Description: Rubutu
• StockQuantity: lamba
• CreatedAt: Kwanan wata da lokaci
• UpdatedAt: Kwanan wata da lokaci

Tebur: ProductVariants

• VariantID Maɓalli na farko, lamba ta musamman
• ProductID Teburin samfuran maɓalli na ƙasashen waje
• Name: igiya(misali, Launi, Girma)
• Value: igiya(misali, ja, XL)

Tebur: VariantPrices

• PriceID 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)

A cikin wannan ƙira, CartItems tebur ɗin zai yi nuni da ProductVariants tebur don gano takamaiman bambance-bambancen samfurin a cikin keken. Teburin VariantPrices  yana adana bayanan farashi don kowane bambance-bambancen samfur dangane da agogo daban-daban.

Kamar koyaushe, ana iya daidaita ƙirar bayanai don dacewa da ƙayyadaddun buƙatun aikinku da yadda kuke son sarrafa keken siyayya da samfuran.