models

type Category struct {
	ID          int64                 `db:"id"`
	Name        string                `db:"name"`
	Slug        string                `db:"slug"`
	Description core.Optional[string] `db:"description"`
	ParentID    core.Optional[int64]  `db:"parent_id"`
	Active      bool                  `db:"active"`
	CreatedAt   time.Time             `db:"created_at"`
	UpdatedAt   time.Time             `db:"updated_at"`
}

type Order struct {
	core.Model
	UserID      int64                 `db:"user_id"`
	Status      string                `db:"status"`
	Total       float64               `db:"total"`
	Notes       core.Optional[string] `db:"notes"`
	ShippedAt   core.Optional[int64]  `db:"shipped_at"`
	DeliveredAt core.Optional[int64]  `db:"delivered_at"`
	Cancelled   bool                  `db:"cancelled"`
}

type Product struct {
	core.Model
	Name        string                 `db:"name"`
	SKU         string                 `db:"sku"`
	Description core.Optional[string]  `db:"description"`
	Price       float64                `db:"price"`
	Discount    core.Optional[float64] `db:"discount"`
	Stock       int                    `db:"stock"`
	MinStock    core.Optional[int]     `db:"min_stock"`
	Active      bool                   `db:"active"`
	Featured    core.Optional[bool]    `db:"featured"`
}

type User struct {
	core.Model
	Name      string                 `db:"name"`
	Email     string                 `db:"email"`
	Username  string                 `db:"username"`
	Bio       core.Optional[string]  `db:"bio"`
	Age       core.Optional[int]     `db:"age"`
	Verified  bool                   `db:"verified"`
	Premium   core.Optional[bool]    `db:"premium"`
	LastLogin core.Optional[int64]   `db:"last_login"`
	Rating    core.Optional[float64] `db:"rating"`
}