solosw
36 lines
2.5 KiB
Go
36 lines
2.5 KiB
Go
package models
|
||
|
||
import (
|
||
"time"
|
||
)
|
||
|
||
// SecondaryProduct 二级商品表（用户上架的商品）
|
||
type SecondaryProduct struct {
|
||
ID uint `gorm:"primaryKey;autoIncrement" json:"id"`
|
||
SellerID uint `gorm:"type:int;not null;comment:卖家用户ID" json:"seller_id" binding:"required"`
|
||
OriginalProductID *uint `gorm:"type:int;comment:原始商品ID（一级商品ID或二级商品ID）" json:"original_product_id"`
|
||
OriginalProductType uint8 `gorm:"type:tinyint;not null;comment:原始商品类型：1一级商品，2二级商品" json:"original_product_type" binding:"required"`
|
||
ProductName string `gorm:"type:varchar(200);not null;comment:商品名称" json:"product_name" binding:"required"`
|
||
ProductDescription string `gorm:"type:text;comment:商品描述" json:"product_description"`
|
||
ProductImages string `gorm:"type:text;comment:商品图片URLs，JSON格式存储" json:"product_images"`
|
||
CostPrice float64 `gorm:"type:decimal(10,2);not null;comment:成本价（用户购买时的价格）" json:"cost_price" binding:"required"`
|
||
SellingPrice float64 `gorm:"type:decimal(10,2);not null;comment:出售价格" json:"selling_price" binding:"required"`
|
||
Quantity int `gorm:"type:int;not null;default:1;comment:出售数量" json:"quantity"`
|
||
Status uint8 `gorm:"type:tinyint;not null;default:1;comment:状态：0下架，1上架，2已售出" json:"status"`
|
||
ViewCount int `gorm:"type:int;not null;default:0;comment:浏览量" json:"view_count"`
|
||
SalesCount int `gorm:"type:int;not null;default:0;" json:"sales_count"`
|
||
CreatedAt time.Time `gorm:"type:timestamp;default:CURRENT_TIMESTAMP" json:"created_at"`
|
||
UpdatedAt time.Time `gorm:"type:timestamp;default:CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" json:"updated_at"`
|
||
CategoryID uint `gorm:"type:int;not null;default:0;comment:商品分类ID" json:"category_id"`
|
||
ProductCondition string `gorm:"type varchar(255)" json:"product_condition"`
|
||
UserWarehouseID uint `gorm:"type:int;not null" json:"user_warehouse_id"`
|
||
// 关联关系
|
||
Seller User `gorm:"foreignKey:SellerID" json:"seller,omitempty"`
|
||
Category *ProductCategory `gorm:"foreignKey:CategoryID" json:"category,omitempty"`
|
||
UserWarehouse *UserWarehouse `gorm:"foreignKey:UserWarehouseID" json:"user_warehouse,omitempty"`
|
||
}
|
||
|
||
func (SecondaryProduct) TableName() string {
|
||
return "secondary_products"
|
||
}
|