Skip to content

Self-hosted workflows for coding-agent delivery. Orchestrate CodeBuddy, Codex and Claude Code with scripts and human approval gates. Includes Local workflows for coding assistants.

35.1 KB
Raw Blame
package repo

import (
	"agentflow/internal/domain"
	"time"
)

// gorm row models. These describe the physical tables shared by MySQL
// (mysql_schema.sql) and the sqlite test database (AutoMigrate). Domain
// entities live in a JSON payload column; only filterable/locking fields are
// real columns.
//
// Time fields are deliberately named Created/Updated (not CreatedAt/UpdatedAt)
// so gorm never auto-fills them; every writer sets them explicitly.

const (
	mysqlSyncConfigID = "default"
	mysqlSeedMarkerID = -1
)

type userRow struct {
	ID           int64      `gorm:"column:id;primaryKey;autoIncrement"`
	StaffID      int        `gorm:"column:staff_id"`
	LoginName    string     `gorm:"column:login_name;uniqueIndex:uq_users_login;size:64"`
	ChineseName  string     `gorm:"column:chinese_name;size:128"`
	DeptID       int        `gorm:"column:dept_id"`
	DeptName     string     `gorm:"column:dept_name;size:128"`
	PlatformRole string     `gorm:"column:platform_role;size:32"`
	Created      *time.Time `gorm:"column:created_at"`
	Updated      *time.Time `gorm:"column:updated_at"`
}

func (userRow) TableName() string { return "users" }

type userConfigRow struct {
	UserID                       int64      `gorm:"column:user_id;primaryKey"`
	GitToken                     *string    `gorm:"column:git_token;type:text"`
	GongfengRefreshToken         *string    `gorm:"column:gongfeng_refresh_token;type:text"`
	GongfengTokenExpiresAt       *time.Time `gorm:"column:gongfeng_token_expires_at"`
	CodeBuddyAPIKey              *string    `gorm:"column:codebuddy_api_key;type:text"`
	CodeBuddyInternetEnvironment string     `gorm:"column:codebuddy_internet_environment;size:64"`
	CodeBuddyModels              *string    `gorm:"column:codebuddy_models;type:text"`
	CodexAPIKey                  *string    `gorm:"column:codex_api_key;type:text"`
	CodexBaseURL                 *string    `gorm:"column:codex_base_url;type:text"`
	CodexModels                  *string    `gorm:"column:codex_models;type:text"`
	ClaudeCodeAPIKey             *string    `gorm:"column:claude_code_api_key;type:text"`
	ClaudeCodeBaseURL            *string    `gorm:"column:claude_code_base_url;type:text"`
	ClaudeCodeModels             *string    `gorm:"column:claude_code_models;type:text"`
	AgentCLICredentials          *string    `gorm:"column:agent_cli_credentials;type:text"`
	Created                      *time.Time `gorm:"column:created_at"`
	Updated                      *time.Time `gorm:"column:updated_at"`
}

func (userConfigRow) TableName() string { return "user_configs" }

type gitSSHKeyRow struct {
	UserID     int64  `gorm:"primaryKey;autoIncrement:false"`
	ID         string `gorm:"primaryKey;size:64"`
	Name       string `gorm:"size:80;not null"`
	Host       string `gorm:"type:text;not null"`
	PrivateKey string `gorm:"type:text;not null"`
}

func (gitSSHKeyRow) TableName() string { return "user_git_ssh_keys" }

type gitHTTPCredentialRow struct {
	UserID   int64      `gorm:"primaryKey;autoIncrement:false"`
	ID       string     `gorm:"primaryKey;size:64"`
	Name     string     `gorm:"size:80;not null"`
	Platform string     `gorm:"size:16;not null"`
	Host     string     `gorm:"size:255;not null"`
	Username string     `gorm:"size:128;not null"`
	Token    string     `gorm:"type:text;not null"`
	Created  *time.Time `gorm:"column:created_at"`
	Updated  *time.Time `gorm:"column:updated_at"`
}

func (gitHTTPCredentialRow) TableName() string { return "user_git_http_credentials" }

type apiTokenRow struct {
	ID         string     `gorm:"column:id;primaryKey;size:64"`
	UserID     int64      `gorm:"column:user_id;index:idx_api_tokens_user"`
	Name       string     `gorm:"column:name;size:128"`
	Prefix     string     `gorm:"column:prefix;size:24"`
	TokenHash  string     `gorm:"column:token_hash;uniqueIndex:uq_api_tokens_hash;size:64"`
	LastUsedAt *time.Time `gorm:"column:last_used_at"`
	ExpiresAt  *time.Time `gorm:"column:expires_at"`
	Created    time.Time  `gorm:"column:created_at"`
	RevokedAt  *time.Time `gorm:"column:revoked_at"`
}

func (apiTokenRow) TableName() string { return "api_tokens" }

type projectRow struct {
	BusinessDomainID string     `gorm:"column:business_domain_id;size:64;not null;default:'';index:idx_projects_business_domain"`
	ID               string     `gorm:"column:id;primaryKey;size:64"`
	ProjectKey       string     `gorm:"column:project_key;index:idx_projects_key;size:64"`
	Name             string     `gorm:"column:name;size:255"`
	OwnerUserID      *int64     `gorm:"column:owner_user_id;index:idx_projects_owner"`
	Payload          []byte     `gorm:"column:payload;type:json"`
	Created          *time.Time `gorm:"column:created_at"`
	Updated          *time.Time `gorm:"column:updated_at"`
}

func (projectRow) TableName() string { return "projects" }

type projectMemberRow struct {
	ProjectID string     `gorm:"column:project_id;primaryKey:idx_project_members_project;size:64"`
	UserID    int64      `gorm:"column:user_id;primaryKey:idx_project_members_user"`
	Role      string     `gorm:"column:role;size:32"`
	Created   *time.Time `gorm:"column:created_at"`
}

func (projectMemberRow) TableName() string { return "project_members" }

type repositoryRow struct {
	ID        string     `gorm:"column:id;primaryKey;size:64"`
	ProjectID string     `gorm:"column:project_id;index:idx_repos_project;size:64"`
	Name      string     `gorm:"column:name;size:255"`
	Payload   []byte     `gorm:"column:payload;type:json"`
	Created   *time.Time `gorm:"column:created_at"`
	Updated   *time.Time `gorm:"column:updated_at"`
}

func (repositoryRow) TableName() string { return "repositories" }

type agentRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	Name    string     `gorm:"column:name;size:255"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (agentRow) TableName() string { return "agents" }

type ruleRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	Name    string     `gorm:"column:name;size:255"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (ruleRow) TableName() string { return "rules" }

type skillRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	Name    string     `gorm:"column:name;size:255"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (skillRow) TableName() string { return "skills" }

// skillFileRow stores one binary skill file. Content lives in a MEDIUMBLOB
// column so binary payloads never bloat the skills payload JSON.
type skillFileRow struct {
	SkillID  string     `gorm:"column:skill_id;primaryKey;size:64"`
	Path     string     `gorm:"column:path;primaryKey;size:512"`
	Content  []byte     `gorm:"column:content;type:mediumblob"`
	Size     int64      `gorm:"column:size"`
	SHA256   string     `gorm:"column:sha256;size:64"`
	UnixMode uint32     `gorm:"column:unix_mode"`
	Updated  *time.Time `gorm:"column:updated_at"`
}

func (skillFileRow) TableName() string { return "skill_files" }

type mcpFileRow struct {
	MCPID    string     `gorm:"column:mcp_id;primaryKey;size:64"`
	Path     string     `gorm:"column:path;primaryKey;size:512"`
	Content  []byte     `gorm:"column:content;type:mediumblob"`
	Size     int64      `gorm:"column:size"`
	SHA256   string     `gorm:"column:sha256;size:64"`
	UnixMode uint32     `gorm:"column:unix_mode"`
	Updated  *time.Time `gorm:"column:updated_at"`
}

func (mcpFileRow) TableName() string { return "mcp_files" }

type mcpServerRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	Name    string     `gorm:"column:name;size:255"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (mcpServerRow) TableName() string { return "mcp_servers" }

type executorRow struct {
	ID      string `gorm:"column:id;primaryKey;size:64"`
	Name    string `gorm:"column:name;size:255"`
	Kind    string `gorm:"column:kind;size:32"`
	Payload []byte `gorm:"column:payload;type:json"`
}

func (executorRow) TableName() string { return "executors" }

type dockerfileRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	Name    string     `gorm:"column:name;size:255"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (dockerfileRow) TableName() string { return "dockerfiles" }

type environmentRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	Name    string     `gorm:"column:name;size:255"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (environmentRow) TableName() string { return "environments" }

type sandboxRow struct {
	ID      string `gorm:"column:id;primaryKey;size:64"`
	Name    string `gorm:"column:name;size:255"`
	Payload []byte `gorm:"column:payload;type:json"`
}

func (sandboxRow) TableName() string { return "sandboxes" }

type workflowRow struct {
	ID       string     `gorm:"column:id;primaryKey;size:64"`
	Name     string     `gorm:"column:name;size:255"`
	Version  int        `gorm:"column:version"`
	Revision int        `gorm:"column:revision"`
	Status   string     `gorm:"column:status;index:idx_workflows_status;size:32"`
	Payload  []byte     `gorm:"column:payload;type:json"`
	Created  *time.Time `gorm:"column:created_at"`
	Updated  *time.Time `gorm:"column:updated_at"`
}

func (workflowRow) TableName() string { return "workflows" }

type syncConfigRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:32"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (syncConfigRow) TableName() string { return "sync_config" }

type scheduleJobRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	Name    string     `gorm:"column:name;size:255"`
	Enabled int        `gorm:"column:enabled"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (scheduleJobRow) TableName() string { return "schedule_jobs" }

// scheduleJobExecutionRow is one schedule job execution; the indexed columns
// mirror the payload for filtering.
type scheduleJobExecutionRow struct {
	ID        string     `gorm:"column:id;primaryKey;size:80"`
	JobID     string     `gorm:"column:job_id;size:64;index:idx_schedule_job_executions_job"`
	ProjectID string     `gorm:"column:project_id;size:64;index:idx_schedule_job_executions_project"`
	TraceID   string     `gorm:"column:trace_id;size:64;index:idx_schedule_job_executions_trace"`
	Status    string     `gorm:"column:status;size:32"`
	Payload   []byte     `gorm:"column:payload;type:json"`
	Started   *time.Time `gorm:"column:started_at;index:idx_schedule_job_executions_started"`
	Updated   *time.Time `gorm:"column:updated_at"`
}

func (scheduleJobExecutionRow) TableName() string { return "schedule_job_executions" }

// scheduleJobExecutionStatRow counts the finished executions of one job that
// started in one UTC hour. Rows outlive the 200 executions a job keeps, so the
// dashboard overview stays exact for frequent jobs.
type scheduleJobExecutionStatRow struct {
	JobID      string    `gorm:"column:job_id;primaryKey;size:64"`
	BucketHour time.Time `gorm:"column:bucket_hour;primaryKey"`
	ProjectID  string    `gorm:"column:project_id;size:64;index:idx_schedule_job_execution_stats_project"`
	Finished   int       `gorm:"column:finished;not null;default:0"`
	Success    int       `gorm:"column:success;not null;default:0"`
	Failed     int       `gorm:"column:failed;not null;default:0"`
	Timed      int       `gorm:"column:timed;not null;default:0"`
	DurationMs int64     `gorm:"column:duration_ms;not null;default:0"`
}

func (scheduleJobExecutionStatRow) TableName() string { return "schedule_job_execution_stats" }

type sharedScheduleVersionRow struct {
	ID           string     `gorm:"column:id;primaryKey;size:64"`
	SharedTaskID string     `gorm:"column:shared_task_id;size:64;uniqueIndex:idx_shared_schedule_version"`
	Version      int        `gorm:"column:version;uniqueIndex:idx_shared_schedule_version"`
	Payload      []byte     `gorm:"column:payload;type:json"`
	Created      *time.Time `gorm:"column:created_at"`
}

func (sharedScheduleVersionRow) TableName() string { return "shared_schedule_versions" }

type issueRow struct {
	ID             string     `gorm:"column:id;primaryKey;size:64"`
	ProjectID      string     `gorm:"column:project_id;index:idx_issues_project_status;size:64"`
	Number         int        `gorm:"column:number"`
	Title          string     `gorm:"column:title;size:512"`
	Status         string     `gorm:"column:status;index:idx_issues_project_status,priority:2;size:32"`
	Kind           string     `gorm:"column:kind;size:32"`
	Source         string     `gorm:"column:source;index:idx_issues_source_ext;size:32"`
	WorkflowID     string     `gorm:"column:workflow_id;size:64"`
	AssigneeUserID *int64     `gorm:"column:assignee_user_id;index:idx_issues_assignee_user"`
	ExternalID     string     `gorm:"column:external_id;index:idx_issues_source_ext,priority:2;size:128"`
	Payload        []byte     `gorm:"column:payload;type:json"`
	Created        *time.Time `gorm:"column:created_at"`
	Updated        *time.Time `gorm:"column:updated_at"`
}

func (issueRow) TableName() string { return "issues" }

type issueCommentRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	IssueID string     `gorm:"column:issue_id;index:idx_comments_issue;size:64"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Created *time.Time `gorm:"column:created_at"`
}

func (issueCommentRow) TableName() string { return "issue_comments" }

type taskRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	IssueID string     `gorm:"column:issue_id;index:idx_tasks_issue;size:64"`
	RunID   string     `gorm:"column:run_id;index:idx_tasks_run;size:64"`
	Status  string     `gorm:"column:status;size:32"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Created *time.Time `gorm:"column:created_at"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (taskRow) TableName() string { return "tasks" }

type runRow struct {
	Kind               string     `gorm:"column:kind;size:32"`
	ID                 string     `gorm:"column:id;primaryKey;size:64"`
	WorkflowID         string     `gorm:"column:workflow_id;index:idx_runs_workflow_updated;size:64"`
	Status             string     `gorm:"column:status;index:idx_runs_status;index:idx_runs_quota_bucket,priority:2;size:32"`
	QuotaBucket        *string    `gorm:"column:quota_bucket;size:128;index:idx_runs_quota_bucket,priority:1"`
	QuotaProjectID     *string    `gorm:"column:quota_project_id;size:64"`
	QuotaParentRunID   *string    `gorm:"column:quota_parent_run_id;size:64"`
	QuotaExempt        *bool      `gorm:"column:quota_exempt"`
	AdmissionState     string     `gorm:"column:admission_state;size:32"`
	QueueEntered       *time.Time `gorm:"column:queue_entered_at;index:idx_runs_quota_bucket,priority:3"`
	Revision           int        `gorm:"column:revision"`
	Input              string     `gorm:"column:input;type:text"`
	HumanContext       string     `gorm:"column:human_context;type:text"`
	CancelRequested    bool       `gorm:"column:cancel_requested"`
	PauseRequested     bool       `gorm:"column:pause_requested"`
	SandboxID          string     `gorm:"column:sandbox_id;size:64"`
	Repositories       []byte     `gorm:"column:repositories;type:json"`
	Repository         []byte     `gorm:"column:repository;type:json"`
	Snapshot           []byte     `gorm:"column:snapshot;type:json"`
	ExecutionContext   []byte     `gorm:"column:execution_context;type:json"`
	UsageJSON          []byte     `gorm:"column:usage_json;type:json"`
	ToolCalls          int        `gorm:"column:tool_calls"`
	TelemetrySequence  int64      `gorm:"column:telemetry_sequence"`
	LogSequence        int64      `gorm:"column:log_sequence"`
	OwnerInstanceID    string     `gorm:"column:owner_instance_id;size:255"`
	LeaseUntil         *time.Time `gorm:"column:lease_until"`
	Generation         int        `gorm:"column:execution_generation"`
	WorkspaceHost      string     `gorm:"column:workspace_host;size:255"`
	WorkspaceRoot      string     `gorm:"column:workspace_root;size:1024"`
	WorkspaceEditorID  int64      `gorm:"column:workspace_editor_id"`
	WorkspaceEditUntil *time.Time `gorm:"column:workspace_edit_until"`
	WorkspaceCleaned   *time.Time `gorm:"column:workspace_cleaned_at"`
	CleanupNotBefore   *time.Time `gorm:"column:workspace_cleanup_not_before"`
	Created            *time.Time `gorm:"column:created_at"`
	Updated            *time.Time `gorm:"column:updated_at"`
}

func (runRow) TableName() string { return "runs" }

type runNodeRow struct {
	RunID   string `gorm:"column:run_id;primaryKey;size:64"`
	NodeID  string `gorm:"column:node_id;primaryKey;size:64"`
	Status  string `gorm:"column:status;index:idx_run_nodes_status;size:32"`
	Attempt int    `gorm:"column:attempt"`
	Payload []byte `gorm:"column:payload;type:json"`
}

func (runNodeRow) TableName() string { return "run_nodes" }

type runEventRow struct {
	RunID   string     `gorm:"column:run_id;primaryKey;size:64"`
	Seq     int64      `gorm:"column:seq;primaryKey"`
	EventID string     `gorm:"column:event_id;size:64"`
	NodeID  string     `gorm:"column:node_id;size:64"`
	Type    string     `gorm:"column:type;size:64"`
	Message string     `gorm:"column:message;type:text"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Ts      *time.Time `gorm:"column:ts"`
}

func (runEventRow) TableName() string { return "run_events" }

type runTelemetryRow struct {
	RunID   string `gorm:"column:run_id;primaryKey;size:64"`
	Seq     int64  `gorm:"column:seq;primaryKey"`
	Payload []byte `gorm:"column:payload;type:json"`
}

func (runTelemetryRow) TableName() string { return "run_telemetry" }

type runLogRow struct {
	RunID   string `gorm:"column:run_id;primaryKey;size:64"`
	Seq     int64  `gorm:"column:seq;primaryKey"`
	Payload []byte `gorm:"column:payload;type:json"`
}

func (runLogRow) TableName() string { return "run_logs" }

type runArtifactRow struct {
	ID            string     `gorm:"column:id;primaryKey;size:64"`
	RunID         string     `gorm:"column:run_id;index:idx_artifacts_run;size:64"`
	NodeID        string     `gorm:"column:node_id;size:64"`
	Attempt       int        `gorm:"column:attempt"`
	Name          string     `gorm:"column:name;size:128"`
	Path          string     `gorm:"column:path;size:512"`
	MediaType     string     `gorm:"column:media_type;size:128"`
	SizeBytes     int64      `gorm:"column:size_bytes"`
	SHA256        string     `gorm:"column:sha256;size:64"`
	RepositoryDir string     `gorm:"column:repository_dir;size:128"`
	Content       string     `gorm:"column:content;type:text"`
	Created       *time.Time `gorm:"column:created_at"`
}

func (runArtifactRow) TableName() string { return "run_artifacts" }

type runEvalRow struct {
	ID        string     `gorm:"column:id;primaryKey;size:64"`
	RunID     string     `gorm:"column:run_id;index:idx_run_evals_run_created,priority:1;size:64"`
	Status    string     `gorm:"column:status;size:32"`
	Score     int        `gorm:"column:score"`
	Passed    bool       `gorm:"column:passed"`
	Model     string     `gorm:"column:model;size:128"`
	CreatedBy int64      `gorm:"column:created_by"`
	Payload   []byte     `gorm:"column:payload;type:json"`
	Created   *time.Time `gorm:"column:created_at;index:idx_run_evals_run_created,priority:2"`
	Finished  *time.Time `gorm:"column:finished_at"`
}

func (runEvalRow) TableName() string { return "run_evals" }

type runPreviewRow struct {
	ID                string     `gorm:"column:id;primaryKey;size:64"`
	RunID             string     `gorm:"column:run_id;uniqueIndex:uq_run_previews_run;size:64"`
	ProjectID         string     `gorm:"column:project_id;index:idx_run_previews_project;size:64"`
	Kind              string     `gorm:"column:kind;size:32"`
	Status            string     `gorm:"column:status;index:idx_run_previews_status_expiry;size:32"`
	SourcePath        string     `gorm:"column:source_path;size:1024"`
	StorageKey        string     `gorm:"column:storage_key;size:1024"`
	ContentSHA256     string     `gorm:"column:content_sha256;size:64"`
	CompressedSize    int64      `gorm:"column:compressed_size"`
	ExpandedSize      int64      `gorm:"column:expanded_size"`
	FileCount         int        `gorm:"column:file_count"`
	EntryFile         string     `gorm:"column:entry_file;size:512"`
	SPAFallback       bool       `gorm:"column:spa_fallback"`
	BackendURL        string     `gorm:"column:backend_url;size:1024"`
	OwnerRunnerID     string     `gorm:"column:owner_runner_id;size:64"`
	ScreenshotKey     string     `gorm:"column:screenshot_key;size:1024"`
	ErrorText         string     `gorm:"column:error_text;type:text"`
	UploadTokenHash   string     `gorm:"column:upload_token_hash;size:64"`
	UploadMaxBytes    int64      `gorm:"column:upload_max_bytes"`
	UploadExpiresAt   *time.Time `gorm:"column:upload_expires_at"`
	ArchiveLeaseUntil *time.Time `gorm:"column:archive_lease_until"`
	LastAccessedAt    *time.Time `gorm:"column:last_accessed_at"`
	ExpiresAt         *time.Time `gorm:"column:expires_at;index:idx_run_previews_status_expiry,priority:2"`
	Created           *time.Time `gorm:"column:created_at;index:idx_run_previews_project,priority:2"`
	Updated           *time.Time `gorm:"column:updated_at"`
}

func (runPreviewRow) TableName() string { return "run_previews" }

type previewSessionRow struct {
	ID             string     `gorm:"column:id;primaryKey;size:64"`
	PreviewID      string     `gorm:"column:preview_id;index:idx_preview_sessions_preview;size:64"`
	TokenHash      string     `gorm:"column:token_hash;uniqueIndex:uq_preview_sessions_hash;size:64"`
	BackendURL     string     `gorm:"column:backend_url;size:1024"`
	ExpiresAt      *time.Time `gorm:"column:expires_at"`
	Created        *time.Time `gorm:"column:created_at"`
	LastAccessedAt *time.Time `gorm:"column:last_accessed_at"`
	RevokedAt      *time.Time `gorm:"column:revoked_at"`
}

func (previewSessionRow) TableName() string { return "preview_sessions" }

type previewBlobRow struct {
	SHA256  string     `gorm:"column:sha256;primaryKey;size:64"`
	Content []byte     `gorm:"column:content;type:longblob"`
	Size    int64      `gorm:"column:size"`
	Created *time.Time `gorm:"column:created_at"`
}

func (previewBlobRow) TableName() string { return "preview_blobs" }

type mrDeliveryStateRow struct {
	MRProject    string     `gorm:"column:mr_project;primaryKey;size:255"`
	MRIID        int        `gorm:"column:mr_iid;primaryKey"`
	MRURL        string     `gorm:"column:mr_url;size:512"`
	State        string     `gorm:"column:state;index:idx_mr_delivery_refresh;size:32"`
	TargetBranch string     `gorm:"column:target_branch;size:255"`
	IssueID      string     `gorm:"column:issue_id;index:idx_mr_delivery_issue;size:64"`
	MergedAt     *time.Time `gorm:"column:merged_at;index:idx_mr_delivery_merged_at"`
	CheckedAt    *time.Time `gorm:"column:checked_at"`
	RegisteredBy *int64     `gorm:"column:registered_by"`
	Created      *time.Time `gorm:"column:created_at"`
	Updated      *time.Time `gorm:"column:updated_at"`
}

func (mrDeliveryStateRow) TableName() string { return "mr_delivery_states" }

type definitionRevisionRow struct {
	ID       string     `gorm:"column:id;primaryKey;size:128"`
	Kind     string     `gorm:"column:kind;index:idx_rev_entity;size:32"`
	EntityID string     `gorm:"column:entity_id;index:idx_rev_entity,priority:2;size:64"`
	Version  int        `gorm:"column:version"`
	Revision int        `gorm:"column:revision"`
	Name     string     `gorm:"column:name;size:255"`
	Payload  []byte     `gorm:"column:payload;type:json"`
	Created  *time.Time `gorm:"column:created_at"`
}

func (definitionRevisionRow) TableName() string { return "definition_revisions" }

type runnerRow struct {
	ID               string     `gorm:"column:id;primaryKey;size:64"`
	Name             string     `gorm:"column:name;size:255"`
	Status           string     `gorm:"column:status;index:idx_runners_status;size:32"`
	OS               string     `gorm:"column:os;size:32"`
	Arch             string     `gorm:"column:arch;size:32"`
	RunnerVersion    string     `gorm:"column:runner_version;size:64"`
	Labels           []byte     `gorm:"column:labels;type:json"`
	MaxConcurrency   int        `gorm:"column:max_concurrency"`
	RunLimit         *int       `gorm:"column:run_limit"`
	OwnerUserID      *int64     `gorm:"column:owner_user_id;index:idx_runners_owner"`
	SessionTokenHash string     `gorm:"column:session_token_hash;index:idx_runners_session;size:64"`
	SessionExpiresAt *time.Time `gorm:"column:session_expires_at"`
	Runtimes         []byte     `gorm:"column:runtimes;type:json"`
	LastSeenAt       *time.Time `gorm:"column:last_seen_at"`
	Created          *time.Time `gorm:"column:created_at"`
	Updated          *time.Time `gorm:"column:updated_at"`
}

func (runnerRow) TableName() string { return "runners" }

type runnerTaskRow struct {
	ID           string     `gorm:"column:id;primaryKey;size:64"`
	RunnerID     string     `gorm:"column:runner_id;index:idx_runner_tasks_runner;size:64"`
	Provider     string     `gorm:"column:provider;index:idx_runner_tasks_dispatch,priority:2;size:64"`
	Status       string     `gorm:"column:status;index:idx_runner_tasks_dispatch;index:idx_runner_tasks_lease;size:32"`
	LeaseOwner   string     `gorm:"column:lease_owner;size:64"`
	LeaseUntil   *time.Time `gorm:"column:lease_until;index:idx_runner_tasks_lease,priority:2"`
	DesiredState string     `gorm:"column:desired_state;size:32"`
	Attempt      int        `gorm:"column:attempt"`
	MaxAttempts  int        `gorm:"column:max_attempts"`
	Payload      []byte     `gorm:"column:payload;type:json"`
	Created      *time.Time `gorm:"column:created_at"`
	Updated      *time.Time `gorm:"column:updated_at"`
}

func (runnerTaskRow) TableName() string { return "runner_tasks" }

type runnerTaskEventRow struct {
	TaskID string     `gorm:"column:task_id;primaryKey;size:64"`
	Seq    int64      `gorm:"column:seq;primaryKey"`
	Type   string     `gorm:"column:type;size:32"`
	Data   string     `gorm:"column:data;type:text"`
	Ts     *time.Time `gorm:"column:ts"`
}

func (runnerTaskEventRow) TableName() string { return "runner_task_events" }

type userRunnerPrefRow struct {
	UserID          int64      `gorm:"column:user_id;primaryKey"`
	DefaultRunnerID string     `gorm:"column:default_runner_id;size:64"`
	Updated         *time.Time `gorm:"column:updated_at"`
}

func (userRunnerPrefRow) TableName() string { return "user_runner_prefs" }

// assistantPreferenceRow: a missing row means switches are off and messages queue.
type assistantPreferenceRow struct {
	UserID         int64      `gorm:"column:user_id;primaryKey;autoIncrement:false"`
	ProactiveRoles bool       `gorm:"column:proactive_roles;not null;default:false"`
	ProactiveSOPs  bool       `gorm:"column:proactive_sops;not null;default:false"`
	SteerOnSend    bool       `gorm:"column:steer_on_send;not null;default:false"`
	Instructions   string     `gorm:"column:instructions;type:text"`
	UpdatedAt      *time.Time `gorm:"column:updated_at"`
}

func (assistantPreferenceRow) TableName() string { return "assistant_preferences" }

type assistantSessionRow struct {
	ID        string     `gorm:"column:id;primaryKey;size:64"`
	UserID    int64      `gorm:"column:user_id;index:idx_assistant_sessions_user_updated"`
	ProjectID string     `gorm:"column:project_id;size:64"`
	Title     string     `gorm:"column:title;size:128"`
	Model     string     `gorm:"column:model;size:128"`
	Source    string     `gorm:"column:source;size:32;index:idx_assistant_sessions_source"`
	TaskID    string     `gorm:"column:task_id;size:64"`
	Payload   []byte     `gorm:"column:payload;type:json"`
	Created   *time.Time `gorm:"column:created_at"`
	Updated   *time.Time `gorm:"column:updated_at;index:idx_assistant_sessions_user_updated,priority:2"`
}

func (assistantSessionRow) TableName() string { return "assistant_sessions" }

type assistantTaskRow struct {
	ID          string     `gorm:"column:id;primaryKey;size:64"`
	UserID      int64      `gorm:"column:user_id;index:idx_assistant_tasks_user"`
	ProjectID   string     `gorm:"column:project_id;size:64"`
	Name        string     `gorm:"column:name;size:255"`
	Enabled     int        `gorm:"column:enabled;index:idx_assistant_tasks_due"`
	IntervalSec int        `gorm:"column:interval_sec"`
	LastRunAt   *time.Time `gorm:"column:last_run_at;index:idx_assistant_tasks_due,priority:2"`
	Payload     []byte     `gorm:"column:payload;type:json"`
	Created     *time.Time `gorm:"column:created_at"`
	Updated     *time.Time `gorm:"column:updated_at"`
}

func (assistantTaskRow) TableName() string { return "assistant_tasks" }

type engineInstanceRow struct {
	InstanceID    string    `gorm:"column:instance_id;primaryKey;size:255"`
	Role          string    `gorm:"column:role;size:32"`
	ControlURL    string    `gorm:"column:control_url;size:512"`
	WorkspaceHost string    `gorm:"column:workspace_host;size:255"`
	HeartbeatAt   time.Time `gorm:"column:heartbeat_at"`
	LeaseUntil    time.Time `gorm:"column:lease_until;index:idx_engine_instances_live"`
}

func (engineInstanceRow) TableName() string { return "engine_instances" }

type genericTemplateRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	Name    string     `gorm:"column:name;size:255"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (genericTemplateRow) TableName() string { return "generic_templates" }

type chatRoomRow struct {
	ID        string     `gorm:"column:id;primaryKey;size:64"`
	ProjectID string     `gorm:"column:project_id;index:idx_chat_rooms_project;size:64"`
	Name      string     `gorm:"column:name;size:128"`
	CreatedBy int64      `gorm:"column:created_by"`
	Payload   []byte     `gorm:"column:payload;type:json"`
	Created   *time.Time `gorm:"column:created_at"`
	Updated   *time.Time `gorm:"column:updated_at"`
}

func (chatRoomRow) TableName() string { return "chat_rooms" }

type chatMessageRow struct {
	ID      string `gorm:"column:id;primaryKey;size:64"`
	RoomID  string `gorm:"column:room_id;index:idx_chat_messages_room;size:64"`
	UserID  int64  `gorm:"column:user_id"`
	Kind    string `gorm:"column:kind;size:32"`
	IssueID string `gorm:"column:issue_id;size:64"`
	// ThreadID is empty for the main timeline.
	ThreadID string     `gorm:"column:thread_id;size:64;index:idx_chat_messages_thread"`
	Payload  []byte     `gorm:"column:payload;type:json"`
	Created  *time.Time `gorm:"column:created_at;index:idx_chat_messages_room,priority:2"`
}

func (chatMessageRow) TableName() string { return "chat_messages" }

type requirementSpaceRow struct {
	ID        string     `gorm:"column:id;primaryKey;size:64"`
	ProjectID string     `gorm:"column:project_id;index:idx_requirement_spaces_project;size:64"`
	IssueID   string     `gorm:"column:issue_id;index:idx_requirement_spaces_issue;size:64"`
	Payload   []byte     `gorm:"column:payload;type:json"`
	Created   *time.Time `gorm:"column:created_at"`
	Updated   *time.Time `gorm:"column:updated_at"`
}

func (requirementSpaceRow) TableName() string { return "requirement_spaces" }

type spaceMemberRow struct {
	SpaceID string     `gorm:"column:space_id;primaryKey;size:64"`
	UserID  int64      `gorm:"column:user_id;primaryKey;autoIncrement:false"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Created *time.Time `gorm:"column:created_at"`
}

func (spaceMemberRow) TableName() string { return "space_members" }

type spaceArtifactRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	SpaceID string     `gorm:"column:space_id;index:idx_space_artifacts_space;size:64"`
	Kind    string     `gorm:"column:kind;size:32"`
	Version int        `gorm:"column:version"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Created *time.Time `gorm:"column:created_at"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (spaceArtifactRow) TableName() string { return "space_artifacts" }

type spaceArtifactRevisionRow struct {
	ArtifactID string     `gorm:"column:artifact_id;primaryKey;size:64"`
	Version    int        `gorm:"column:version;primaryKey;autoIncrement:false"`
	SpaceID    string     `gorm:"column:space_id;size:64"`
	Payload    []byte     `gorm:"column:payload;type:json"`
	Created    *time.Time `gorm:"column:created_at"`
}

func (spaceArtifactRevisionRow) TableName() string { return "space_artifact_revisions" }

type spaceThreadRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	SpaceID string     `gorm:"column:space_id;index:idx_space_threads_space;size:64"`
	RunID   string     `gorm:"column:run_id;size:64"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Created *time.Time `gorm:"column:created_at"`
}

func (spaceThreadRow) TableName() string { return "space_threads" }

// knowledgeSettingsRow keeps the upstream token in its own column so the JSON
// payload can be logged or diffed without leaking the credential.
type knowledgeSettingsRow struct {
	ID      string     `gorm:"column:id;primaryKey;size:64"`
	Payload []byte     `gorm:"column:payload;type:json"`
	Token   *string    `gorm:"column:token;type:text"`
	Updated *time.Time `gorm:"column:updated_at"`
}

func (knowledgeSettingsRow) TableName() string { return "knowledge_settings" }

type knowledgeSubmissionRow struct {
	ID         string     `gorm:"column:id;primaryKey;size:64"`
	ProjectID  string     `gorm:"column:project_id;index:idx_knowledge_submissions_project;size:64"`
	RunID      string     `gorm:"column:run_id;index:idx_knowledge_submissions_run;size:64"`
	ArtifactID string     `gorm:"column:artifact_id;index:idx_knowledge_submissions_artifact;size:64"`
	Status     string     `gorm:"column:status;index:idx_knowledge_submissions_status;size:32"`
	Payload    []byte     `gorm:"column:payload;type:json"`
	Created    *time.Time `gorm:"column:created_at"`
	Updated    *time.Time `gorm:"column:updated_at"`
}

func (knowledgeSubmissionRow) TableName() string { return "knowledge_submissions" }

// allModels lists every table for the sqlite test schema (AutoMigrate).
func allModels() []any {
	return []any{domain.BotUserBinding{}, domain.BotBindingChallenge{}, domain.BotConnection{}, domain.BotConversation{}, domain.BotInteraction{}, notificationBotRow{}, botCredentialRow{}, domain.NotificationDelivery{},
		userRow{}, localAccountRow{}, userConfigRow{}, gitSSHKeyRow{}, gitHTTPCredentialRow{}, authIntegrationRow{}, platformCodeBuddyKeyRow{}, apiTokenRow{}, genericTemplateRow{},
		insightSourceRow{}, insightExecutionRow{},
		projectRow{}, projectMemberRow{}, repositoryRow{}, businessDomainRow{}, businessDomainAssignmentRow{},
		agentRow{}, ruleRow{}, skillRow{}, skillFileRow{}, mcpServerRow{}, mcpFileRow{}, executorRow{},
		dockerfileRow{}, environmentRow{}, sandboxRow{},
		workflowRow{}, syncConfigRow{}, scheduleJobRow{}, scheduleJobExecutionRow{}, scheduleJobExecutionStatRow{}, sharedScheduleVersionRow{},
		issueRow{}, issueCommentRow{}, taskRow{},
		runAdmissionLockRow{}, runRow{}, runNodeRow{}, runEventRow{}, runTelemetryRow{}, runLogRow{}, runArtifactRow{}, runEvalRow{},
		runPreviewRow{}, previewSessionRow{}, previewBlobRow{}, WorkspaceCheckpoint{}, workspaceCheckpointChunk{},
		mrDeliveryStateRow{}, definitionRevisionRow{},
		runnerRow{}, runnerTaskRow{}, runnerTaskEventRow{}, userRunnerPrefRow{},
		assistantSessionRow{}, assistantTaskRow{}, assistantGenerationRow{}, assistantSessionReadRow{}, assistantPreferenceRow{}, assistantDiagnosticsRow{},
		chatRoomRow{}, chatMessageRow{},
		requirementSpaceRow{}, spaceMemberRow{}, spaceArtifactRow{}, spaceArtifactRevisionRow{}, spaceThreadRow{},
		engineInstanceRow{},
		knowledgeSettingsRow{}, knowledgeSubmissionRow{},
		pageFeedbackRow{}, pageFeedbackImageRow{},
	}
}