workflow

type Workflow struct {
	bun.BaseModel `bun:"table:workflows"`

	ID uuid.UUID `bun:",pk,type:uuid" json:"id"`
	// Slug is the human-facing workflow id — renameable, unlike ID.
	Slug string `bun:",notnull,unique" json:"slug"`
	// Version counts installed heads; it is 0 while only a draft exists.
	Version   int       `json:"version"`
	Spec      string    `json:"spec"`
	Draft     string    `json:"draft,omitempty"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type WorkflowVersion struct {
	bun.BaseModel `bun:"table:workflow_versions"`

	ID         uuid.UUID `bun:",pk,type:uuid" json:"id"`
	WorkflowID uuid.UUID `bun:"type:uuid,notnull" json:"workflow_id"`
	Version    int       `bun:",notnull" json:"version"`
	Spec       string    `bun:",notnull" json:"spec"`
	CreatedAt  time.Time `json:"created_at"`
}