models

type Account struct {
	ID                uuid.UUID `gorm:"primary_key;default:uuid_generate_v4()"`
	Email             string
	Name              string
	InstallationAdmin bool `gorm:"default:false"`
}

type AccountMagicCode struct {
	ID             uuid.UUID  `gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
	Email          string     `gorm:"type:varchar(255);not null"`
	CodeHash       string     `gorm:"type:varchar(64);not null"`
	ExpiresAt      time.Time  `gorm:"not null"`
	UsedAt         *time.Time `gorm:"default:null"`
	VerifyAttempts int        `gorm:"not null;default:0"`
	CreatedAt      time.Time
}

type AccountPasswordAuth struct {
	ID           uuid.UUID `gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
	AccountID    uuid.UUID
	PasswordHash string
	CreatedAt    time.Time
	UpdatedAt    time.Time
}

type AccountProvider struct {
	ID             uuid.UUID `gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
	AccountID      uuid.UUID
	Provider       string
	ProviderID     string
	Username       string
	Email          string
	Name           string
	AvatarURL      string
	AccessToken    string
	RefreshToken   string
	TokenExpiresAt *time.Time
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type Blueprint struct {
	ID             uuid.UUID
	OrganizationID uuid.UUID
	Name           string
	Description    string
	Icon           string
	Color          string
	CreatedBy      *uuid.UUID
	CreatedAt      *time.Time
	UpdatedAt      *time.Time
	Nodes          datatypes.JSONSlice[Node]
	Edges          datatypes.JSONSlice[Edge]
	Configuration  datatypes.JSONSlice[configuration.Field]
	OutputChannels datatypes.JSONSlice[BlueprintOutputChannel]
}

type BlueprintOutputChannel struct {
	Name              string `json:"name"`
	NodeID            string `json:"node_id"`
	NodeOutputChannel string `json:"node_output_channel"`
}

type BlueprintRef struct {
	ID string `json:"id"`
}

type BrowserAction struct {
	URL         string
	Method      string
	FormFields  map[string]string
	Description string
}

type Canvas struct {
	ID                     uuid.UUID
	OrganizationID         uuid.UUID
	LiveVersionID          *uuid.UUID
	IsTemplate             bool
	VersioningEnabled      bool
	ChangeRequestApprovers datatypes.JSONSlice[CanvasChangeRequestApprover]
	Name                   string
	Description            string
	CreatedBy              *uuid.UUID
	CreatedAt              *time.Time
	UpdatedAt              *time.Time
	DeletedAt              gorm.DeletedAt `gorm:"index"`
}

type CanvasChangeRequest struct {
	ID                 uuid.UUID
	WorkflowID         uuid.UUID
	VersionID          uuid.UUID
	OwnerID            *uuid.UUID
	BasedOnVersionID   *uuid.UUID
	Title              string
	Description        string
	Status             string
	ChangedNodeIDs     datatypes.JSONSlice[string]
	ConflictingNodeIDs datatypes.JSONSlice[string]
	PublishedAt        *time.Time
	CreatedAt          *time.Time
	UpdatedAt          *time.Time
}

type CanvasChangeRequestApproval struct {
	ID                      uuid.UUID
	WorkflowID              uuid.UUID
	WorkflowChangeRequestID uuid.UUID `gorm:"column:workflow_change_request_id"`
	ApproverIndex           int
	ApproverType            string
	ApproverUserID          *uuid.UUID
	ApproverRole            *string
	ActorUserID             *uuid.UUID
	State                   string
	InvalidatedAt           *time.Time
	CreatedAt               *time.Time
	UpdatedAt               *time.Time
}

type CanvasChangeRequestApprover struct {
	Type string `json:"type"`
	User string `json:"user,omitempty"`
	Role string `json:"role,omitempty"`
}

type CanvasChangeRequestListOptions struct {
	Limit        int
	Before       *time.Time
	OwnerID      *uuid.UUID
	Statuses     []string
	IsConflicted *bool
	Query        string
}

type CanvasEvent struct {
	ID          uuid.UUID `gorm:"primaryKey;default:uuid_generate_v4()"`
	WorkflowID  uuid.UUID
	NodeID      string
	Channel     string
	CustomName  *string
	Data        datatypes.JSONType[any]
	ExecutionID *uuid.UUID
	State       string
	CreatedAt   *time.Time
}

type CanvasMemory struct {
	ID        uuid.UUID `gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
	CreatedAt time.Time
	UpdatedAt time.Time
	CanvasID  uuid.UUID
	Namespace string
	Values    datatypes.JSONType[any]
}

type CanvasNode struct {
	WorkflowID        uuid.UUID `gorm:"primaryKey"`
	NodeID            string    `gorm:"primaryKey"`
	ParentNodeID      *string
	Name              string
	State             string
	StateReason       *string
	Type              string
	Position          datatypes.JSONType[Position]
	Ref               datatypes.JSONType[NodeRef]
	Configuration     datatypes.JSONType[map[string]any]
	Metadata          datatypes.JSONType[map[string]any]
	IsCollapsed       bool
	WebhookID         *uuid.UUID
	AppInstallationID *uuid.UUID
	CreatedAt         *time.Time
	UpdatedAt         *time.Time
	DeletedAt         gorm.DeletedAt `gorm:"index"`
}

type CanvasNodeExecution struct {
	ID         uuid.UUID `gorm:"primaryKey;default:uuid_generate_v4()"`
	WorkflowID uuid.UUID
	NodeID     string
	CreatedAt  *time.Time
	UpdatedAt  *time.Time

	//
	// Reference to the root WorkflowEvent record that started
	// this whole execution chain.
	//
	// This gives us an easy way to find all the executions
	// for that event with a simple query.
	//
	RootEventID uuid.UUID

	//
	// Reference to the previous execution.
	// This is what allows us to build execution chains,
	// from any execution.
	//
	PreviousExecutionID *uuid.UUID

	//
	// Reference to the parent execution.
	// This is used for node executions inside of a blueprint node,
	// to reference the parent blueprint node execution.
	//
	ParentExecutionID *uuid.UUID

	//
	// The reference to a WorkflowEvent record,
	// which holds the input for this execution.
	//
	EventID uuid.UUID

	//
	// State management fields.
	//
	State         string
	Result        string
	ResultReason  string
	ResultMessage string
	CancelledBy   *uuid.UUID

	//
	// Components can store metadata about each execution here.
	// This allows them to control the behavior of each execution.
	//
	Metadata datatypes.JSONType[map[string]any]

	//
	// The configuration is copied from the node.
	// This enables us to allow node configuration updates
	// while executions are running.
	// Only new executions will use the new node configuration.
	//
	Configuration datatypes.JSONType[map[string]any]
}

type CanvasNodeExecutionKV struct {
	ID          uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()"`
	WorkflowID  uuid.UUID `gorm:"type:uuid;not null"`
	NodeID      string    `gorm:"type:varchar(128);not null"`
	ExecutionID uuid.UUID `gorm:"type:uuid;not null"`
	Key         string    `gorm:"type:text;not null"`
	Value       string    `gorm:"type:text;not null"`
	CreatedAt   *time.Time
}

type CanvasNodeQueueItem struct {
	ID         uuid.UUID `gorm:"primaryKey;default:uuid_generate_v4()"`
	WorkflowID uuid.UUID
	NodeID     string
	CreatedAt  *time.Time

	//
	// Reference to the root WorkflowEvent record that started
	// this whole execution chain.
	//
	// This gives us an easy way to find all the queue items
	// for that event with a simple query.
	//
	RootEventID uuid.UUID
	RootEvent   *CanvasEvent `gorm:"foreignKey:RootEventID"`

	//
	// The reference to a CanvasEvent record,
	// which holds the input for this queue item.
	//
	EventID uuid.UUID
}

type CanvasNodeReference struct {
	CanvasID   uuid.UUID
	CanvasName string
	NodeID     string
	NodeName   string
}

type CanvasNodeRequest struct {
	ID          uuid.UUID
	WorkflowID  uuid.UUID
	NodeID      string
	ExecutionID *uuid.UUID
	State       string
	Type        string
	Spec        datatypes.JSONType[NodeExecutionRequestSpec]
	RunAt       time.Time
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type CanvasUserDraft struct {
	WorkflowID uuid.UUID `gorm:"primaryKey"`
	UserID     uuid.UUID `gorm:"primaryKey"`
	VersionID  uuid.UUID
	CreatedAt  *time.Time
	UpdatedAt  *time.Time
}

type CanvasVersion struct {
	ID          uuid.UUID
	WorkflowID  uuid.UUID
	OwnerID     *uuid.UUID
	IsPublished bool
	PublishedAt *time.Time
	Nodes       datatypes.JSONSlice[Node]
	Edges       datatypes.JSONSlice[Edge]
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type ComponentRef struct {
	Name string `json:"name"`
}

type Edge struct {
	SourceID string `json:"source_id"`
	TargetID string `json:"target_id"`
	Channel  string `json:"channel"`
}

type EmailSettings struct {
	ID            uuid.UUID `gorm:"type:uuid;primary_key;default:uuid_generate_v4()"`
	Provider      string    `gorm:"type:varchar(50);uniqueIndex"`
	SMTPHost      string
	SMTPPort      int
	SMTPUsername  string
	SMTPPassword  []byte
	SMTPFromName  string
	SMTPFromEmail string
	SMTPUseTLS    bool
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type GroupMetadata struct {
	ID          uuid.UUID `json:"id" gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
	GroupName   string    `json:"group_name" gorm:"not null;index"`
	DomainType  string    `json:"domain_type" gorm:"not null;index"`
	DomainID    string    `json:"domain_id" gorm:"not null;index"`
	DisplayName string    `json:"display_name" gorm:"not null"`
	Description string    `json:"description"`
	CreatedAt   time.Time `json:"created_at"`
	UpdatedAt   time.Time `json:"updated_at"`
}

type InstallationMetadata struct {
	ID                        int    `gorm:"primary_key"`
	InstallationID            string `gorm:"type:varchar(64)"`
	AllowPrivateNetworkAccess bool
	CreatedAt                 time.Time
	UpdatedAt                 time.Time
}

type Integration struct {
	ID               uuid.UUID `gorm:"primary_key;default:uuid_generate_v4()"`
	OrganizationID   uuid.UUID
	AppName          string
	InstallationName string
	State            string
	StateDescription string
	Configuration    datatypes.JSONType[map[string]any]
	Metadata         datatypes.JSONType[map[string]any]
	BrowserAction    *datatypes.JSONType[BrowserAction]
	CreatedAt        *time.Time
	UpdatedAt        *time.Time
	DeletedAt        gorm.DeletedAt `gorm:"index"`
}

type IntegrationInvokeAction struct {
	ActionName string `json:"action_name"`
	Parameters any    `json:"parameters"`
}

type IntegrationRequest struct {
	ID                uuid.UUID
	AppInstallationID uuid.UUID
	State             string
	Type              string
	Spec              datatypes.JSONType[IntegrationRequestSpec]
	RunAt             time.Time
	CreatedAt         time.Time
	UpdatedAt         time.Time
}

type IntegrationRequestSpec struct {
	InvokeAction *IntegrationInvokeAction `json:"invoke_action,omitempty"`
}

type IntegrationSecret struct {
	ID             uuid.UUID `gorm:"primary_key;default:uuid_generate_v4()"`
	OrganizationID uuid.UUID
	InstallationID uuid.UUID
	Name           string
	Value          []byte
	CreatedAt      *time.Time
	UpdatedAt      *time.Time
}

type IntegrationSubscription struct {
	ID             uuid.UUID `gorm:"primary_key;default:uuid_generate_v4()"`
	InstallationID uuid.UUID
	WorkflowID     uuid.UUID
	NodeID         string
	Configuration  datatypes.JSONType[any]
	CreatedAt      *time.Time
	UpdatedAt      *time.Time
}

type InvokeAction struct {
	ActionName string         `json:"action_name"`
	Parameters map[string]any `json:"parameters"`
}

type Node struct {
	ID             string         `json:"id"`
	Name           string         `json:"name"`
	Type           string         `json:"type"`
	Ref            NodeRef        `json:"ref"`
	Configuration  map[string]any `json:"configuration"`
	Metadata       map[string]any `json:"metadata"`
	Position       Position       `json:"position"`
	IsCollapsed    bool           `json:"isCollapsed"`
	IntegrationID  *string        `json:"integrationId,omitempty"`
	ErrorMessage   *string        `json:"errorMessage,omitempty"`
	WarningMessage *string        `json:"warningMessage,omitempty"`
}

type NodeExecutionRequestSpec struct {
	InvokeAction *InvokeAction `json:"invoke_action,omitempty"`
}

type NodeRef struct {
	Component *ComponentRef `json:"component,omitempty"`
	Blueprint *BlueprintRef `json:"blueprint,omitempty"`
	Trigger   *TriggerRef   `json:"trigger,omitempty"`
	Widget    *WidgetRef    `json:"widget,omitempty"`
}

type NodeSubscription struct {
	WorkflowID    uuid.UUID
	NodeID        string
	NodeType      string
	NodeRef       datatypes.JSONType[NodeRef]
	Configuration datatypes.JSONType[any]
}

type Organization struct {
	ID                       uuid.UUID `gorm:"primary_key;default:uuid_generate_v4()"`
	Name                     string    `gorm:"uniqueIndex"`
	Description              string
	AllowedProviders         datatypes.JSONSlice[string]
	VersioningEnabled        bool
	UsageSyncedAt            *time.Time
	UsageRetentionWindowDays *int32
	UsageLimitsSyncedAt      *time.Time
	CreatedAt                *time.Time
	UpdatedAt                *time.Time
	DeletedAt                gorm.DeletedAt `gorm:"index"`
}

type OrganizationAgentSettings struct {
	ID                       uuid.UUID `gorm:"type:uuid;primary_key;default:uuid_generate_v4()"`
	OrganizationID           uuid.UUID `gorm:"type:uuid;uniqueIndex"`
	AgentModeEnabled         bool
	OpenAIApiKeyCiphertext   []byte     `gorm:"column:openai_api_key_ciphertext"`
	OpenAIKeyEncryptionKeyID *string    `gorm:"column:openai_key_encryption_key_id"`
	OpenAIKeyLast4           *string    `gorm:"column:openai_key_last4"`
	OpenAIKeyStatus          string     `gorm:"column:openai_key_status"`
	OpenAIKeyValidatedAt     *time.Time `gorm:"column:openai_key_validated_at"`
	OpenAIKeyValidationError *string    `gorm:"column:openai_key_validation_error"`
	UpdatedBy                *uuid.UUID `gorm:"type:uuid"`
	CreatedAt                time.Time
	UpdatedAt                time.Time
}

type OrganizationInvitation struct {
	ID             uuid.UUID `gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
	OrganizationID uuid.UUID
	Email          string
	InvitedBy      uuid.UUID
	State          string
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type OrganizationInviteLink struct {
	ID             uuid.UUID `gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
	OrganizationID uuid.UUID `gorm:"uniqueIndex"`
	Token          uuid.UUID `gorm:"type:uuid;uniqueIndex"`
	Enabled        bool
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type Position struct {
	X int `json:"x"`
	Y int `json:"y"`
}

type RoleMetadata struct {
	ID          uuid.UUID `json:"id" gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
	RoleName    string    `json:"role_name" gorm:"not null;index"`
	DomainType  string    `json:"domain_type" gorm:"not null;index"`
	DomainID    string    `json:"domain_id" gorm:"not null;index"`
	DisplayName string    `json:"display_name" gorm:"not null"`
	Description string    `json:"description"`
	CreatedAt   time.Time `json:"created_at"`
	UpdatedAt   time.Time `json:"updated_at"`
}

type Secret struct {
	ID         uuid.UUID `gorm:"primary_key;default:uuid_generate_v4()"`
	DomainType string
	DomainID   uuid.UUID
	Name       string
	CreatedAt  *time.Time
	CreatedBy  uuid.UUID
	UpdatedAt  *time.Time
	Provider   string
	Data       []byte
}

type SecretData struct {
	Local map[string]string `json:"local"`
}

type TriggerRef struct {
	Name string `json:"name"`
}

type User struct {
	ID             uuid.UUID `gorm:"type:uuid;primary_key;default:gen_random_uuid()"`
	OrganizationID uuid.UUID
	AccountID      *uuid.UUID
	Email          *string
	Name           string
	Type           string
	Description    *string
	CreatedBy      *uuid.UUID
	TokenHash      string
	CreatedAt      time.Time
	UpdatedAt      time.Time
	DeletedAt      gorm.DeletedAt
}

type Webhook struct {
	ID                uuid.UUID `gorm:"primary_key;default:uuid_generate_v4()"`
	State             string
	Secret            []byte
	Configuration     datatypes.JSONType[any]
	Metadata          datatypes.JSONType[any]
	AppInstallationID *uuid.UUID
	RetryCount        int `gorm:"default:0"`
	MaxRetries        int `gorm:"default:3"`
	CreatedAt         *time.Time
	UpdatedAt         *time.Time
	DeletedAt         gorm.DeletedAt `gorm:"index"`
}