model

type File struct {
	gorm.Model
	Name      string `gorm:"type:varchar(160);not null;uniqueIndex"` // "shoe1.jpg", "shoe2.jpg", ...
	Category  string `gorm:"type:varchar(100);not null"`             // "image", "downloadable", ...
	FileBlob  []byte `gorm:"type:blob;not null"`
	Type      string `gorm:"type:varchar(100);not null"` // "image/jpeg", "application/pdf", ...
	Extension string `gorm:"type:varchar(10);not null"`  // "jpg", "png", "pdf", ...
	ProductID uint   `gorm:"index;not null"`             // the product this file belongs to
}

type Order struct {
	gorm.Model
	ExternalId    string      `json:"external_id" gorm:"unique;not null"` // from NOWPayments
	UserId        uint        `json:"user_id" gorm:"not null"`            // the user who made the payment
	Status        OrderStatus `json:"status" gorm:"not null"`             // waiting, confirming, confirmed, sending, partially_paid, finished, failed, expired
	ProductId     uint        `json:"product_id" gorm:"not null"`         // the product the user bought
	PriceAmount   float64     `json:"price_amount" gorm:"not null"`       // the amount the user paid (it's important to store because prices can change)
	PriceCurrency string      `json:"price_currency" gorm:"not null"`     // the currency in which we denominate the amount (e.g. usd)
	InvoiceUrl    string      `json:"invoice_url" gorm:"unique;not null"` // from NOWPayments
}

type OrderStatus string

type Post struct {
	gorm.Model
	Title     string `gorm:"type:varchar(100);not null"`
	Content   string `gorm:"type:text;not null"`
	AuthorID  uint   `gorm:"type:integer;not null"`
	Published bool   `gorm:"type:boolean;default:false"`
}

type Product struct {
	gorm.Model
	Name          string  `gorm:"type:varchar(160);not null;uniqueIndex"`                             // "Shoe #1", "Shoe #2", ...
	Description   string  `gorm:"type:text;not null"`                                                 // "A very nice shoe", ...
	Files         []File  `gorm:"foreignKey:ProductID;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"` // 1 to many; downloadables, ...
	Images        []File  `gorm:"foreignKey:ProductID;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"` // 1 to many; images for the product, ...
	PriceAmount   float64 `gorm:"type:decimal(10,2);not null"`                                        // 100.00
	PriceCurrency string  `gorm:"type:varchar(3);not null"`                                           // usd, eur, ...
}

type Token struct {
	gorm.Model
	Email string `gorm:"primaryKey"`
	Value string `gorm:"primaryKey"`
}

type User struct {
	gorm.Model
	ID    uint   `gorm:"primaryKey"`
	Email string `gorm:"unique"`
	Role  string `gorm:"type:varchar(100);not null;default:'user'"` // "user", "admin", ...
}