// Register your model to the schema facade so that it can be discovered at runtime

func (receiver *DatabaseServiceProvider) Boot(app foundation.Application) {
	facades.Schema().Extend(schema.Extension{
		Models: []any{models.AllFeatures{}},
	})
}

// Define model
type AllFeatures struct {
	orm.Model
	SKU        string         `gorm:"column:sku_code;size:100;unique;not null;default:'SKU-001';comment:'Stock Keeping Unit'"`
	Price      uint           `gorm:"type:decimal(10,2);unsigned;index"`
	Status     string         `gorm:"type:enum('pending','active','inactive');default:'pending'"`
	Metadata   []byte         `gorm:"type:json"`
	OtherData  map[string]any `gorm:"type:json"`
	Ignored    string         `gorm:"-"`
	Relation   User           `gorm:"foreignKey:UserID"` // will be ignored as it is a relation
	Categories []User         // will be ignored as it is a relation
}

func (r *M20251130103337AllFeatures) Up() error {
	return facades.Schema().Table("comprehensive_test_models", func(table schema.Blueprint) {
		table.TimestampTz("created_at").Nullable()
		table.TimestampTz("updated_at").Nullable()
		table.BigIncrements("id")
		table.String("sku_code", 100).Default("SKU-001").Comment("Stock Keeping Unit")
		table.Decimal("price").Unsigned().Nullable()
		table.Enum("status", []any{"pending", "active", "inactive"}).Nullable().Default("pending")
		table.Json("metadata").Nullable()
		table.Json("other_data").Nullable()

		table.Index("price")
		table.Unique("sku_code")
	})
}