models

type Order struct {
	types.AutoIncID

	RelUser
	RelOrder
	OrderData

	types.CreationModificationTime
}

type OrderData struct {
	// OrderNo 订单编号
	OrderNo string `db:"order_no,width=64"`
	// Amount 订单金额
	Amount types.Decimal `db:"amount,width=22,precision=4"`
	// Currency 结算币种
	Currency enums.Currency `db:"currency"`
	// PaidAt 订单支付时间
	PaidAt sqltime.Timestamp `db:"paid_at,default=0"`
	// CanceledAt 订单取消时间
	CanceledAt sqltime.Timestamp `db:"canceled_at,default=0"`
	// Status 订单状态
	Status enums.OrderStatus `db:"status"`
}

type OrderID uint64

type OrderSnapshot struct {
	types.AutoIncID

	RelOrder
	RelProduct
	OrderSnapshotData

	types.CreationTime
}

type OrderSnapshotData struct {
	// ProductSKU 产品SKU
	ProductSKU string `db:"product_sku,width=64"`
	// ProductName 产品名称 Product.Name
	ProductName string `db:"product_name,width=256"`
	// Price 产品单价 Product.Price
	Price types.Decimal `db:"price,width=22,precision=4"`
	// Quantity 订单产品数量
	Quantity int64 `db:"quantity"`
	// Subtotal 订单金额
	Subtotal types.Decimal `db:"subtotal,width=22,precision=4"`
}

type Product struct {
	types.AutoIncID

	RelProduct
	ProductData

	types.CreationModificationDeletionTime
}

type ProductData struct {
	// SKU 库存标签
	SKU string `db:"sku"`
	// Name 产品名称
	Name string `db:"name,width=256"`
	// Description 产品描述
	Description string `db:"description"`
	// Price 单价
	Price types.Decimal `db:"price,width=22,precision=4"`
	// Currency 货币
	Currency enums.Currency `db:"currency"`
	// Status 产品销售状态
	Status enums.ProductStatus `db:"status"`
}

type ProductID int64

type RelOrder struct {
	// @rel Order.OrderID
	OrderID OrderID `db:"order_id"`
}

type RelProduct struct {
	// @rel Product.ProductID
	ProductID ProductID `db:"product_id"`
}

type RelUser struct {
	// @rel User.UserID
	UserID UserID `db:"user_id"`
}

type Shipment struct {
	types.AutoIncID

	RelOrder
	ShipmentData

	types.CreationModificationTime
}

type ShipmentData struct {
	// Carrier 物流运营商
	Carrier string `db:"carrier,width=64"`
	// TrackingNo 物流单号
	TrackingNo string `db:"tracking_no"`
	// Status 物流状态
	Status enums.ShipmentStatus `db:"status"`
	// ShippedAt 开始运输时间
	ShippedAt sqltime.Timestamp `db:"shipped_at"`
	// DeliveredAt 抵达时间
	DeliveredAt sqltime.Timestamp `db:"delivered_at"`
}

type User struct {
	types.AutoIncID

	RelUser
	UserData

	types.OperationDatetime
}

type UserData struct {
	// Username 用户名
	Username string `db:"username,width=127"`
	// Email 邮箱
	Email string `db:"email,width=127"`
	// Phone 电话
	Phone string `db:"phone,width=32"`
	// Status 用户状态
	Status enums.UserStatus `db:"status"`
}

type UserID uint64