Zanewar Database don E-Commerce oda tare da Halayen Samfur da Farashi da yawa

Anan ga ƙirar bayanai don sashin oda 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: Orders

• OrderID Maɓalli na farko, lamba ta musamman
• UserID Teburin masu amfani da maɓalli na waje
• TotalAmount: Decimal
• OrderDate: Kwanan wata

Tebur: OrderItems

• OrderItemID Maɓalli na farko, lamba ta musamman
• OrderID Teburin umarni na maɓalli na ƙasashen waje
• ProductID Teburin samfuran maɓalli na ƙasashen waje
• VariantID: Maɓallin maɓalli na waje na nuni SamfuraBambancin tebur
• Quantity: lamba
• Price: Decimal
• Subtotal: Decimal

Tebur: Products

• ProductID Maɓalli na farko, lamba ta musamman
• Name: Zare
• Description: Rubutu
• 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, OrderItems  tebur ɗin ya ƙunshi bayani game da kowane abu a cikin tsari, gami da cikakkun bayanai game da samfur, bambance-bambancen samfur, yawa, farashi, da jimla.