webrpc

type AddrInfo struct {
	ID    string   `json:"ID"`
	Addrs []string `json:"Addrs"`
}

type Advertisement struct {
	Slash string `json:"/"`
}

type AlertComment struct {
	ID        int64     `db:"id" json:"ID"`
	AlertID   int64     `db:"alert_id" json:"AlertID"`
	Comment   string    `db:"comment" json:"Comment"`
	CreatedBy string    `db:"created_by" json:"CreatedBy"`
	CreatedAt time.Time `db:"created_at" json:"CreatedAt"`
}

type AlertHistoryEntry struct {
	ID             int64      `db:"id" json:"ID"`
	AlertName      string     `db:"alert_name" json:"AlertName"`
	Message        string     `db:"message" json:"Message"`
	MachineName    *string    `db:"machine_name" json:"MachineName"`
	CreatedAt      time.Time  `db:"created_at" json:"CreatedAt"`
	Acknowledged   bool       `db:"acknowledged" json:"Acknowledged"`
	AcknowledgedBy *string    `db:"acknowledged_by" json:"AcknowledgedBy"`
	AcknowledgedAt *time.Time `db:"acknowledged_at" json:"AcknowledgedAt"`
	SentToPlugins  bool       `db:"sent_to_plugins" json:"SentToPlugins"`
	SentAt         *time.Time `db:"sent_at" json:"SentAt"`
	CommentCount   int        `db:"comment_count" json:"CommentCount"`
}

type AlertHistoryListResult struct {
	Alerts              []AlertHistoryEntry `json:"Alerts"`
	Total               int                 `json:"Total"`
	UnacknowledgedTotal int                 `json:"UnacknowledgedTotal"`
}

type AlertMute struct {
	ID        int64      `db:"id" json:"ID"`
	AlertName string     `db:"alert_name" json:"AlertName"`
	Pattern   *string    `db:"pattern" json:"Pattern"`
	Reason    string     `db:"reason" json:"Reason"`
	MutedBy   string     `db:"muted_by" json:"MutedBy"`
	MutedAt   time.Time  `db:"muted_at" json:"MutedAt"`
	ExpiresAt *time.Time `db:"expires_at" json:"ExpiresAt"`
	Active    bool       `db:"active" json:"Active"`
}

type AlertOngoingEntry struct {
	AlertName     string    `db:"alert_name" json:"AlertName"`
	Message       string    `db:"message" json:"Message"`
	CreatedAt     time.Time `db:"created_at" json:"CreatedAt"`
	LastUpdatedAt time.Time `db:"last_updated_at" json:"LastUpdatedAt"`
}

type AllowDeny struct {
	Wallet string `db:"wallet" json:"wallet"`
	Status bool   `db:"status" json:"status"`
}

type BalanceMgrRule struct {
	ID              int64   `json:"id"`
	SubjectAddress  string  `json:"subject_address"`
	SecondAddress   string  `json:"second_address"`
	ActionType      string  `json:"action_type"`
	SubjectType     string  `json:"subject_type"`
	LowWatermark    string  `json:"low_watermark"`
	HighWatermark   string  `json:"high_watermark"`
	TaskID          *int64  `json:"task_id,omitempty"`
	LastMsgCID      *string `json:"last_msg_cid,omitempty"`
	LastMsgSentAt   *string `json:"last_msg_sent_at,omitempty"`
	LastMsgLandedAt *string `json:"last_msg_landed_at,omitempty"`
}

type ChainStatusResponse struct {
	NetworkName    string `json:"networkName"`
	Epoch          int64  `json:"epoch"`
	SyncStatus     string `json:"syncStatus"`
	ReachableNodes int    `json:"reachableNodes"`
	TotalNodes     int    `json:"totalNodes"`
}

type ClientFilter struct {
	Name   string `db:"name" json:"name"`
	Active bool   `db:"active" json:"active"`

	Wallets []string `db:"wallets" json:"wallets"`
	Peers   []string `db:"peer_ids" json:"peers"`

	PricingFilters []string `db:"pricing_filters" json:"pricing_filters"`

	MaxDealsPerHour    int64 `db:"max_deals_per_hour" json:"max_deals_per_hour"`
	MaxDealSizePerHour int64 `db:"max_deal_size_per_hour" json:"max_deal_size_per_hour"`

	Info string `db:"additional_info" json:"info"`
}

type ContentInfo struct {
	PieceCID string `json:"piece_cid"`
	Offset   uint64 `json:"offset"`
	Size     uint64 `json:"size"`

	Err string `json:"err"`
}

type DefaultFilterBehaviourResponse struct {
	AllowDealsFromUnknownClients             bool            `json:"allow_deals_from_unknown_clients"`
	IsDealRejectedWhenCidGravityNotReachable bool            `json:"is_deal_rejected_when_cid_gravity_not_reachable"`
	IsCidGravityEnabled                      map[string]bool `json:"cid_gravity_status"`
}

type EntryInfo struct {
	PieceCID string `db:"piece_cid"`
	FromCar  bool   `db:"from_car"`

	FirstCID    NullString `db:"first_cid"`
	StartOffset NullInt64  `db:"start_offset"`
	NumBlocks   int64      `db:"num_blocks"`

	PrevCID NullString `db:"prev_cid"`

	Err  *string
	Size int64
}

type EthPendingMessage struct {
	TxHash     string     `json:"txHash"`
	SendReason string     `json:"sendReason"`
	SendTime   *time.Time `json:"sendTime"`
}

type FSPDPOffering struct {
	ServiceURL               string `json:"service_url"`
	MinPieceSizeInBytes      int64  `json:"min_size"`
	MaxPieceSizeInBytes      int64  `json:"max_size"`
	IpniPiece                bool   `json:"ipni_piece"`
	IpniIpfs                 bool   `json:"ipni_ipfs"`
	IpniPeerID               string `json:"ipni_peer_id"` // Base58 encoded PeerID
	StoragePricePerTibPerDay int64  `json:"price"`
	MinProvingPeriodInEpochs int64  `json:"min_proving_period"`
	Location                 string `json:"location"`
	PaymentTokenAddress      string `json:"payment_token_address"`
	CapacityTiB              int64  `json:"capacity_tib"`
}

type FSRegistryStatus struct {
	Address      string            `json:"address"`
	ID           int64             `json:"id"`
	Active       bool              `json:"status"`
	Name         string            `json:"name"`
	Description  string            `json:"description"`
	Payee        string            `json:"payee"`
	PDPService   *FSPDPOffering    `json:"pdp_service"`
	Capabilities map[string]string `json:"capabilities"`
}

type Handler struct {
	Deps      *deps.Deps
	TaskSPIDs map[string]SpidGetter
	Stor      adt.Store
}

type HarmonyMachineDesc struct {
	MachineID   int64  `db:"machine_id"`
	Name        string `db:"machine_name"`
	MachineAddr string `db:"host_and_port"`
	Actors      string `db:"miners"`
}

type HarmonyTask struct {
	ID         int64      `db:"id"`
	Name       string     `db:"name"`
	UpdateTime time.Time  `db:"update_time"`
	PostedTime time.Time  `db:"posted_time"`
	OwnerID    NullInt64  `db:"owner_id"`
	OwnerAddr  NullString `db:"owner_addr"`
	OwnerName  NullString `db:"owner_name"`
}

type HarmonyTaskHistory struct {
	ID     int64  `db:"id"`
	TaskID int64  `db:"task_id"`
	Name   string `db:"name"`

	WorkStart time.Time `db:"work_start"`
	WorkEnd   time.Time `db:"work_end"`
	Posted    time.Time `db:"posted"`

	Took string `db:"-"`

	Result bool   `db:"result"`
	Err    string `db:"err"`

	CompletedBy     string     `db:"completed_by_host_and_port"`
	CompletedById   NullInt64  `db:"completed_by_machine"`
	CompletedByName NullString `db:"completed_by_machine_name"`

	Events []*SectorEvent `db:"-"`
}

type HarmonyTaskStats struct {
	Name       string `db:"name" json:"name"`
	Success    int    `db:"success" json:"success"`
	Failure    int    `db:"failure" json:"failure"`
	TotalCount int    `db:"total" json:"total"`
}

type IPNI struct {
	SpId       int64            `db:"sp_id" json:"sp_id"`
	PeerID     string           `db:"peer_id" json:"peer_id"`
	Head       string           `db:"head" json:"head"`
	Miner      string           `json:"miner"`
	SyncStatus []IpniSyncStatus `json:"sync_status"`
}

type IpniAd struct {
	AdCid           string     `db:"ad_cid" json:"ad_cid"`
	ContextID       []byte     `db:"context_id" json:"context_id"`
	IsRM            bool       `db:"is_rm" json:"is_rm"`
	IsSkip          bool       `db:"is_skip" json:"is_skip"`
	PreviousAd      NullString `db:"previous"`
	Previous        string     `json:"previous"`
	SpID            int64      `db:"sp_id" json:"sp_id"`
	Addresses       NullString `db:"addresses"`
	AddressesString string     `json:"addresses"`
	Entries         string     `db:"entries" json:"entries"`
	PieceCid        string     `json:"piece_cid"`
	PieceSize       int64      `json:"piece_size"`
	Miner           string     `json:"miner"`

	EntryCount int64 `json:"entry_count"`
	CIDCount   int64 `json:"cid_count"`

	AdCids     []string `db:"-" json:"ad_cids"`
	PieceCidV2 string   `db:"-" json:"piece_cid_v2"`
}

type IpniSyncStatus struct {
	Service               string    `json:"service"`
	RemoteAd              string    `json:"remote_ad"`
	PublisherAddress      string    `json:"publisher_address"`
	Address               string    `json:"address"`
	LastAdvertisementTime time.Time `json:"last_advertisement_time"`
	Error                 string    `json:"error"`
}

type MK12Deal struct {
	UUID              string          `db:"uuid" json:"uuid"`
	SpId              int64           `db:"sp_id" json:"sp_id"`
	CreatedAt         time.Time       `db:"created_at" json:"created_at"`
	SignedProposalCid string          `db:"signed_proposal_cid" json:"signed_proposal_cid"`
	ProposalSignature []byte          `db:"proposal_signature" json:"proposal_signature"`
	Proposal          json.RawMessage `db:"proposal" json:"proposal"`
	ProposalCid       string          `db:"proposal_cid" json:"proposal_cid"`
	Offline           bool            `db:"offline" json:"offline"`
	Verified          bool            `db:"verified" json:"verified"`
	StartEpoch        int64           `db:"start_epoch" json:"start_epoch"`
	EndEpoch          int64           `db:"end_epoch" json:"end_epoch"`
	ClientPeerId      string          `db:"client_peer_id" json:"client_peer_id"`
	ChainDealId       sql.NullInt64   `db:"chain_deal_id" json:"chain_deal_id"`
	PublishCid        sql.NullString  `db:"publish_cid" json:"publish_cid"`
	PieceCid          string          `db:"piece_cid" json:"piece_cid"`
	PieceSize         int64           `db:"piece_size" json:"piece_size"`
	FastRetrieval     bool            `db:"fast_retrieval" json:"fast_retrieval"`
	AnnounceToIPNI    bool            `db:"announce_to_ipni" json:"announce_to_ipni"`
	URL               sql.NullString  `db:"url" json:"url"`
	URLHeaders        json.RawMessage `db:"url_headers" json:"url_headers"`
	Error             sql.NullString  `db:"error" json:"error"`
	IsDDO             bool            `db:"is_ddo" json:"is_ddo"`

	Addr string `db:"-" json:"addr"`
}

type MK12DealPipeline struct {
	UUID              string          `db:"uuid" json:"uuid"`
	SpId              int64           `db:"sp_id" json:"sp_id"`
	Started           sql.NullBool    `db:"started" json:"started"`
	PieceCid          string          `db:"piece_cid" json:"piece_cid"`
	PieceSize         int64           `db:"piece_size" json:"piece_size"`
	RawSize           sql.NullInt64   `db:"raw_size" json:"raw_size"`
	Offline           bool            `db:"offline" json:"offline"`
	URL               sql.NullString  `db:"url" json:"url"`
	Headers           json.RawMessage `db:"headers" json:"headers"`
	CommpTaskId       sql.NullInt64   `db:"commp_task_id" json:"commp_task_id"`
	AfterCommp        sql.NullBool    `db:"after_commp" json:"after_commp"`
	PsdTaskId         sql.NullInt64   `db:"psd_task_id" json:"psd_task_id"`
	AfterPsd          sql.NullBool    `db:"after_psd" json:"after_psd"`
	PsdWaitTime       sql.NullTime    `db:"psd_wait_time" json:"psd_wait_time"`
	FindDealTaskId    sql.NullInt64   `db:"find_deal_task_id" json:"find_deal_task_id"`
	AfterFindDeal     sql.NullBool    `db:"after_find_deal" json:"after_find_deal"`
	Sector            sql.NullInt64   `db:"sector" json:"sector"`
	RegSealProof      sql.NullInt64   `db:"reg_seal_proof" json:"reg_seal_proof"`
	SectorOffset      sql.NullInt64   `db:"sector_offset" json:"sector_offset"`
	Sealed            sql.NullBool    `db:"sealed" json:"sealed"`
	ShouldIndex       sql.NullBool    `db:"should_index" json:"should_index"`
	IndexingCreatedAt sql.NullTime    `db:"indexing_created_at" json:"indexing_created_at"`
	IndexingTaskId    sql.NullInt64   `db:"indexing_task_id" json:"indexing_task_id"`
	Indexed           sql.NullBool    `db:"indexed" json:"indexed"`
	Announce          sql.NullBool    `db:"announce" json:"announce"`
	Complete          bool            `db:"complete" json:"complete"`
	CreatedAt         time.Time       `db:"created_at" json:"created_at"`
}

type MK12Pipeline struct {
	// Cache line 1 (bytes 0-64): Hot path - piece identification and early checks
	UUID      string `db:"uuid" json:"uuid"`             // 16 bytes (0-16)
	SpID      int64  `db:"sp_id" json:"sp_id"`           // 8 bytes (16-24)
	PieceCid  string `db:"piece_cid" json:"piece_cid"`   // 16 bytes (24-40)
	PieceSize int64  `db:"piece_size" json:"piece_size"` // 8 bytes (40-48)
	Offline   bool   `db:"offline" json:"offline"`       // 1 byte (48-49) - checked early for download decisions
	Started   bool   `db:"started" json:"started"`       // 1 byte (49-50) - checked early
	// Cache line 2 (bytes 64-128): Task IDs and stage tracking (NullInt64 = 16 bytes)
	CommTaskID     sql.NullInt64 `db:"commp_task_id" json:"commp_task_id"`         // 16 bytes
	PSDTaskID      sql.NullInt64 `db:"psd_task_id" json:"psd_task_id"`             // 16 bytes
	FindDealTaskID sql.NullInt64 `db:"find_deal_task_id" json:"find_deal_task_id"` // 16 bytes
	AfterCommp     bool          `db:"after_commp" json:"after_commp"`             // 1 byte
	AfterPSD       bool          `db:"after_psd" json:"after_psd"`                 // 1 byte
	AfterFindDeal  bool          `db:"after_find_deal" json:"after_find_deal"`     // 1 byte
	// Cache line 3 (bytes 128-192): Sector placement and sizing (NullInt64 = 16 bytes)
	RawSize sql.NullInt64 `db:"raw_size" json:"raw_size"`           // 16 bytes
	Sector  sql.NullInt64 `db:"sector" json:"sector"`               // 16 bytes
	Offset  sql.NullInt64 `db:"sector_offset" json:"sector_offset"` // 16 bytes
	// Cache line 4 (bytes 192-256): Timing information
	PSDWaitTime sql.NullTime `db:"psd_wait_time" json:"psd_wait_time"` // 32 bytes (NullTime)
	CreatedAt   time.Time    `db:"created_at" json:"created_at"`       // 24 bytes
	// Cache line 5+ (bytes 256+): Data URL and larger fields (NullString = 24 bytes)
	URL        sql.NullString `db:"url" json:"url"`         // 24 bytes - only for online deals
	PieceCidV2 string         `db:"-" json:"piece_cid_v2"`  // 16 bytes - computed field
	Miner      string         `json:"miner"`                // 16 bytes - display field
	Headers    []byte         `db:"headers" json:"headers"` // 24 bytes - only for online deals
	// Status bools: rarely checked ones at end
	Indexed  bool `db:"indexed" json:"indexed"`   // checked for indexing
	Announce bool `db:"announce" json:"announce"` // checked for IPNI announce
	Complete bool `db:"complete" json:"complete"` // checked for completion
}

type MK20DDOPipeline struct {
	ID               string         `db:"id" json:"id"`
	SpId             int64          `db:"sp_id" json:"sp_id"`
	Contract         string         `db:"contract" json:"contract"`
	Client           string         `db:"client" json:"client"`
	PieceCidV2       string         `db:"piece_cid_v2" json:"piece_cid_v2"`
	PieceCid         string         `db:"piece_cid" json:"piece_cid"`
	PieceSize        int64          `db:"piece_size" json:"piece_size"`
	RawSize          uint64         `db:"raw_size" json:"raw_size"`
	Offline          bool           `db:"offline" json:"offline"`
	URL              sql.NullString `db:"url" json:"url"`
	Indexing         bool           `db:"indexing" json:"indexing"`
	Announce         bool           `db:"announce" json:"announce"`
	AllocationID     sql.NullInt64  `db:"allocation_id" json:"allocation_id"`
	Duration         int64          `db:"duration" json:"duration"`
	PieceAggregation int            `db:"piece_aggregation" json:"piece_aggregation"`

	Started    bool `db:"started" json:"started"`
	Downloaded bool `db:"downloaded" json:"downloaded"`

	CommpTaskId sql.NullInt64 `db:"commp_task_id" json:"commp_task_id"`
	AfterCommp  bool          `db:"after_commp" json:"after_commp"`

	DealAggregation   int           `db:"deal_aggregation" json:"deal_aggregation"`
	AggregationIndex  int64         `db:"aggr_index" json:"aggr_index"`
	AggregationTaskID sql.NullInt64 `db:"agg_task_id" json:"agg_task_id"`
	Aggregated        bool          `db:"aggregated" json:"aggregated"`

	Sector       sql.NullInt64 `db:"sector" json:"sector"`
	RegSealProof sql.NullInt64 `db:"reg_seal_proof" json:"reg_seal_proof"`
	SectorOffset sql.NullInt64 `db:"sector_offset" json:"sector_offset"`
	Sealed       bool          `db:"sealed" json:"sealed"`

	IndexingCreatedAt sql.NullTime  `db:"indexing_created_at" json:"indexing_created_at"`
	IndexingTaskId    sql.NullInt64 `db:"indexing_task_id" json:"indexing_task_id"`
	Indexed           bool          `db:"indexed" json:"indexed"`

	Complete  bool      `db:"complete" json:"complete"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`

	Miner string `db:"-" json:"miner"`
}

type MK20PDPDealList struct {
	ID         string     `db:"id" json:"id"`
	CreatedAt  time.Time  `db:"created_at" json:"created_at"`
	PieceCidV2 NullString `db:"piece_cid_v2" json:"piece_cid_v2"`
	Processed  bool       `db:"processed" json:"processed"`
	Error      NullString `db:"error" json:"error"`
}

type MK20PDPPipeline struct {
	ID              string `db:"id" json:"id"`
	Client          string `db:"client" json:"client"`
	PieceCidV2      string `db:"piece_cid_v2" json:"piece_cid_v2"`
	Indexing        bool   `db:"indexing" json:"indexing"`
	Announce        bool   `db:"announce" json:"announce"`
	AnnouncePayload bool   `db:"announce_payload" json:"announce_payload"`

	Downloaded bool `db:"downloaded" json:"downloaded"`

	CommpTaskId NullInt64 `db:"commp_task_id" json:"commp_task_id"`
	AfterCommp  bool      `db:"after_commp" json:"after_commp"`

	DealAggregation   int       `db:"deal_aggregation" json:"deal_aggregation"`
	AggregationIndex  int64     `db:"aggr_index" json:"aggr_index"`
	AggregationTaskID NullInt64 `db:"agg_task_id" json:"agg_task_id"`
	Aggregated        bool      `db:"aggregated" json:"aggregated"`

	AddPieceTaskID NullInt64 `db:"add_piece_task_id" json:"add_piece_task_id"`
	AfterAddPiece  bool      `db:"after_add_piece" json:"after_add_piece"`

	AfterAddPieceMsg bool `db:"after_add_piece_msg" json:"after_add_piece_msg"`

	SaveCacheTaskID NullInt64 `db:"save_cache_task_id" json:"save_cache_task_id"`
	AfterSaveCache  bool      `db:"after_save_cache" json:"after_save_cache"`

	IndexingCreatedAt NullTime  `db:"indexing_created_at" json:"indexing_created_at"`
	IndexingTaskId    NullInt64 `db:"indexing_task_id" json:"indexing_task_id"`
	Indexed           bool      `db:"indexed" json:"indexed"`

	Complete  bool      `db:"complete" json:"complete"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`

	Miner string `db:"-" json:"miner"`
}

type MK20PDPPipelineFailedStats struct {
	DownloadingFailed int64
	CommPFailed       int64
	AggFailed         int64
	AddPieceFailed    int64
	SaveCacheFailed   int64
	IndexFailed       int64
}

type MK20PipelineFailedStats struct {
	DownloadingFailed int64
	CommPFailed       int64
	AggFailed         int64
	IndexFailed       int64
}

type MK20StorageDeal struct {
	Deal   *mk20.Deal `json:"deal"`
	DDOErr NullString `json:"ddoerr"`
	PDPErr NullString `json:"pdperr"`
	DDOId  NullInt64  `json:"ddoid"`
}

type MK20StorageDealList struct {
	ID         string     `db:"id" json:"id"`
	CreatedAt  time.Time  `db:"created_at" json:"created_at"`
	PieceCidV2 NullString `db:"piece_cid_v2" json:"piece_cid_v2"`
	Processed  bool       `db:"processed" json:"processed"`
	Error      NullString `db:"error" json:"error"`
	Miner      NullString `db:"miner" json:"miner"`
}

type MachineInfo struct {
	Info struct {
		Name           string
		Host           string
		ID             int64
		LastContact    string
		CPU            int64
		Memory         int64
		GPU            float64
		Layers         string
		Unschedulable  bool
		RunningTasks   int
		Tasks          string
		Miners         string
		StartupTime    *time.Time
		RestartRequest *time.Time
	}

	// Storage
	Storage []struct {
		ID            string
		URLs          string
		Weight        int64
		MaxStorage    int64
		CanSeal       bool
		CanStore      bool
		Groups        string
		AllowTo       string
		AllowTypes    string
		DenyTypes     string
		Capacity      int64
		Available     int64
		FSAvailable   int64
		Reserved      int64
		Used          int64
		AllowMiners   string
		DenyMiners    string
		LastHeartbeat time.Time
		HeartbeatErr  *string

		UsedPercent     float64
		ReservedPercent float64
	}

	// Storage URL Liveness
	StorageURLs []struct {
		StorageID      string
		URL            string
		LastChecked    time.Time
		LastLive       *time.Time
		LastDead       *time.Time
		LastDeadReason *string
	}

	// Tasks
	RunningTasks []struct {
		ID           int64
		Task         string
		Posted       string
		UpdateTime   string
		InitiatedBy  *int64
		AddedBy      int64
		PreviousTask *int64
		Retries      int64

		PoRepSector, PoRepSectorSP *int64
		PoRepSectorMiner           string
	}

	FinishedTasks []struct {
		ID      int64
		TaskID  int64
		Task    string
		Posted  string
		Start   string
		End     string
		Queued  string
		Took    string
		Result  bool
		Outcome string
		Message string
	}
}

type MachineSummary struct {
	Address      string
	ID           int64
	Name         string
	SinceContact string

	Tasks          string
	Cpu            int
	RamHumanized   string
	Gpu            int
	Layers         string
	Uptime         string
	Version        string
	Unschedulable  bool
	RestartRequest string
	Restarting     bool
	RunningTasks   int
}

type MarketBalanceStatus struct {
	Miner         string           `json:"miner"`
	MarketBalance string           `json:"market_balance"`
	Balances      []WalletBalances `json:"balances"`
}

type MessageDetail struct {
	FromKey                 string          `db:"from_key" json:"from_key"`
	ToAddr                  string          `db:"to_addr" json:"to_addr"`
	SendReason              string          `db:"send_reason" json:"send_reason"`
	SendTaskID              int64           `db:"send_task_id" json:"send_task_id"`
	UnsignedData            []byte          `db:"unsigned_data" json:"unsigned_data"`
	UnsignedCID             string          `db:"unsigned_cid" json:"unsigned_cid"`
	Nonce                   NullInt64       `db:"nonce" json:"nonce"`
	SignedData              []byte          `db:"signed_data" json:"signed_data"`
	SignedJSON              json.RawMessage `db:"signed_json" json:"signed_json"`
	SignedCID               string          `db:"signed_cid" json:"signed_cid"`
	SendTime                NullTime        `db:"send_time" json:"send_time"`
	SendSuccess             NullBool        `db:"send_success" json:"send_success"`
	SendError               NullString      `db:"send_error" json:"send_error"`
	WaiterMachineID         NullInt64       `db:"waiter_machine_id" json:"waiter_machine_id"`
	ExecutedTSKCID          NullString      `db:"executed_tsk_cid" json:"executed_tsk_cid"`
	ExecutedTSKEpoch        NullInt64       `db:"executed_tsk_epoch" json:"executed_tsk_epoch"`
	ExecutedMsgCID          NullString      `db:"executed_msg_cid" json:"executed_msg_cid"`
	ExecutedMsgData         json.RawMessage `db:"executed_msg_data" json:"executed_msg_data"`
	ExecutedReceiptExitCode NullInt64       `db:"executed_rcpt_exitcode" json:"executed_rcpt_exitcode"`
	ExecutedReceiptReturn   []byte          `db:"executed_rcpt_return" json:"executed_rcpt_return"`
	ExecutedReceiptGasUsed  NullInt64       `db:"executed_rcpt_gas_used" json:"executed_rcpt_gas_used"`

	ValueStr string `db:"-" json:"value_str"`
	FeeStr   string `db:"-" json:"fee_str"`
}

type MessageQueueSummary struct {
	FilPendingCount int                  `json:"filPendingCount"`
	EthPendingCount int                  `json:"ethPendingCount"`
	FilPending      []PendingMessageItem `json:"filPending"`
	EthPending      []EthPendingMessage  `json:"ethPending"`
}

type NetBandwidthSummary struct {
	TotalIn  int64   `json:"totalIn"`
	TotalOut int64   `json:"totalOut"`
	RateIn   float64 `json:"rateIn"`
	RateOut  float64 `json:"rateOut"`
}

type NetNodeSummary struct {
	Node         string              `json:"node"`
	Epoch        int64               `json:"epoch"`
	PeerCount    int                 `json:"peerCount"`
	Bandwidth    NetBandwidthSummary `json:"bandwidth"`
	Reachability NetReachability     `json:"reachability"`
}

type NetReachability struct {
	Status      string   `json:"status"`
	PublicAddrs []string `json:"publicAddrs"`
}

type NetSummaryResponse struct {
	Epoch        int64               `json:"epoch"`
	PeerCount    int                 `json:"peerCount"`
	Bandwidth    NetBandwidthSummary `json:"bandwidth"`
	Reachability NetReachability     `json:"reachability"`
	NodeCount    int                 `json:"nodeCount"`
	Nodes        []NetNodeSummary    `json:"nodes"`
}

type NullBool = webrpctypes.NullBool

type NullInt64 = webrpctypes.NullInt64

type NullString = webrpctypes.NullString

type NullTime = webrpctypes.NullTime

type PDPDashboardFinancial struct {
	Income30dUsdfc      string `json:"income30dUsdfc"`
	IncomeSubtitle      string `json:"incomeSubtitle"`
	AccruedUnsettled    string `json:"accruedUnsettledUsdfc"`
	Expense30dFil       string `json:"expense30dFil"`
	Expense30dUsdfc     string `json:"expense30dUsdfc"`
	Expense30dUsdfcNote string `json:"expense30dUsdfcNote"`
}

type PDPDashboardSummary struct {
	DataUnderProofBytes int64                `json:"dataUnderProofBytes"`
	DataSetCount        int                  `json:"dataSetCount"`
	PieceCount          int                  `json:"pieceCount"`
	ProvingSuccessRate  float64              `json:"provingSuccessRate"`
	ProvingSuccessCount int                  `json:"provingSuccessCount"`
	ProvingFailureCount int                  `json:"provingFailureCount"`
	FaultedPeriods30d   int                  `json:"faultedPeriods30d"`
	ProvingActivity     []ProvingActivityDay `json:"provingActivity"`
}

type PDPDataSetDetail struct {
	ID                        int64      `json:"id"`
	ObjectCount               int64      `json:"objectCount"`
	SizeBytes                 int64      `json:"sizeBytes"`
	FirstUploadAt             *time.Time `json:"firstUploadAt,omitempty"`
	LifespanSeconds           *int64     `json:"lifespanSeconds,omitempty"`
	ProveAtEpoch              *int64     `json:"proveAtEpoch,omitempty"`
	ChallengeWindow           *int64     `json:"challengeWindow,omitempty"`
	ProvingPeriod             *int64     `json:"provingPeriod,omitempty"`
	UnrecoverableFailureEpoch *int64     `json:"unrecoverableFailureEpoch,omitempty"`
	InitReady                 bool       `json:"initReady"`
	Service                   string     `json:"service"`
	HeadEpoch                 int64      `json:"headEpoch"`
	ProvingStatus             string     `json:"provingStatus"`
	ExploreURL                string     `json:"exploreUrl,omitempty"`
}

type PDPDataSetInteraction struct {
	Kind      string    `json:"kind"`
	TxHash    string    `json:"txHash,omitempty"`
	TaskID    *int64    `json:"taskId,omitempty"`
	Success   *bool     `json:"success,omitempty"`
	Err       string    `json:"err,omitempty"`
	Timestamp time.Time `json:"timestamp"`
	Detail    string    `json:"detail,omitempty"`
}

type PDPDataSetListResult struct {
	Items []PDPDataSetSummary `json:"items"`
	Total int                 `json:"total"`
}

type PDPDataSetPayments struct {
	Payer             string `json:"payer"`
	Payee             string `json:"payee"`
	ServiceProvider   string `json:"serviceProvider"`
	PdpRailID         string `json:"pdpRailId"`
	PdpEndEpoch       string `json:"pdpEndEpoch"`
	PaymentsRemaining *int64 `json:"paymentsRemaining,omitempty"`
	AvailableFunds    string `json:"availableFunds"`
	FundedUntilEpoch  string `json:"fundedUntilEpoch"`
	LockupPeriod      string `json:"lockupPeriod"`
	PaymentRate       string `json:"paymentRate"`
	ProvenThisPeriod  *bool  `json:"provenThisPeriod,omitempty"`
	HeadEpoch         int64  `json:"headEpoch"`
	Error             string `json:"error,omitempty"`
}

type PDPDataSetSummary struct {
	ID                        int64      `json:"id" db:"id"`
	ObjectCount               int64      `json:"objectCount" db:"object_count"`
	SizeBytes                 int64      `json:"sizeBytes" db:"size_bytes"`
	FirstUploadAt             *time.Time `json:"firstUploadAt,omitempty" db:"first_upload_at"`
	ProveAtEpoch              *int64     `json:"proveAtEpoch,omitempty" db:"prove_at_epoch"`
	ChallengeWindow           *int64     `json:"challengeWindow,omitempty" db:"challenge_window"`
	UnrecoverableFailureEpoch *int64     `json:"unrecoverableFailureEpoch,omitempty" db:"unrecoverable_proving_failure_epoch"`
	ProvingStatus             string     `json:"provingStatus"`
}

type PDPGuideDNSStatus struct {
	OK               bool   `json:"ok"`
	DomainConfigured bool   `json:"domainConfigured"`
	DomainName       string `json:"domainName,omitempty"`
	ServiceURL       string `json:"serviceURL,omitempty"`
	HTTPEnabled      bool   `json:"httpEnabled"`
	Reachable        bool   `json:"reachable"`
	ReachableDetail  string `json:"reachableDetail,omitempty"`
	SuggestTunnel    bool   `json:"suggestTunnel"`
	TunnelInstalled  bool   `json:"tunnelInstalled"`
	TunnelRunning    bool   `json:"tunnelRunning"`
	TunnelDetail     string `json:"tunnelDetail,omitempty"`
	Detail           string `json:"detail,omitempty"`
}

type PDPGuideRegistryStatus struct {
	OK         bool   `json:"ok"`
	Registered bool   `json:"registered"`
	ProviderID int64  `json:"providerId,omitempty"`
	Name       string `json:"name,omitempty"`
	Detail     string `json:"detail,omitempty"`
}

type PDPGuideStatus struct {
	Wallet   PDPGuideWalletStatus   `json:"wallet"`
	Storage  PDPGuideStorageStatus  `json:"storage"`
	DNS      PDPGuideDNSStatus      `json:"dns"`
	Registry PDPGuideRegistryStatus `json:"registry"`
}

type PDPGuideStorageStatus struct {
	OK               bool   `json:"ok"`
	PathCount        int    `json:"pathCount"`
	AvailableBytes   int64  `json:"availableBytes"`
	CapacityBytes    int64  `json:"capacityBytes"`
	AvailableHuman   string `json:"availableHuman"`
	CapacityHuman    string `json:"capacityHuman"`
	MeetsMinimum     bool   `json:"meetsMinimum"`
	MeetsRecommended bool   `json:"meetsRecommended"`
	DocsURL          string `json:"docsURL"`
	Detail           string `json:"detail,omitempty"`
}

type PDPGuideWalletStatus struct {
	OK           bool   `json:"ok"`
	Configured   bool   `json:"configured"`
	Address      string `json:"address,omitempty"`
	FilAddress   string `json:"filAddress,omitempty"`
	Balance      string `json:"balance,omitempty"`
	BalanceKnown bool   `json:"balanceKnown"`
	Funded       bool   `json:"funded"`
	ActorExists  bool   `json:"actorExists"`
	Detail       string `json:"detail,omitempty"`
}

type PDPOwnerAddress struct {
	Address string `db:"address" json:"address"`
}

type PDPProvingFailure struct {
	DataSetID                 int64      `json:"dataSetId"`
	TaskID                    *int64     `json:"taskId,omitempty"`
	Err                       string     `json:"err"`
	WorkEnd                   *time.Time `json:"workEnd,omitempty"`
	UnrecoverableFailureEpoch *int64     `json:"unrecoverableFailureEpoch,omitempty"`
	ProveAtEpoch              *int64     `json:"proveAtEpoch,omitempty"`
	ChallengeWindow           *int64     `json:"challengeWindow,omitempty"`
	Reason                    string     `json:"reason"`
}

type PDPProvingStatus struct {
	HeadEpoch               int64  `json:"headEpoch"`
	NextProveAtEpoch        *int64 `json:"nextProveAtEpoch"`
	NextDeadlineEpoch       *int64 `json:"nextDeadlineEpoch"`
	EpochsUntilNextSession  *int64 `json:"epochsUntilNextSession"`
	SecondsUntilNextSession *int64 `json:"secondsUntilNextSession"`
	ActiveDataSetCount      int    `json:"activeDataSetCount"`
	InWindowCount           int    `json:"inWindowCount"`
	OverdueCount            int    `json:"overdueCount"`
	// SessionState: "in-window", "upcoming", "overdue", or "idle"
	SessionState string `json:"sessionState"`
}

type PDPProvingTimelineEvent struct {
	TaskID    int64     `json:"taskId" db:"task_id"`
	DataSetID int64     `json:"dataSetId" db:"data_set"`
	Success   bool      `json:"success" db:"result"`
	Err       string    `json:"err" db:"err"`
	WorkEnd   time.Time `json:"workEnd" db:"work_end"`
}

type PDPService struct {
	ID        int64  `db:"id" json:"id"`
	Name      string `db:"service_label" json:"name"`
	PubKey    []byte `db:"pubkey"`   // Stored as bytes in DB, converted to PEM string in JSON
	PubKeyStr string `json:"pubkey"` // PEM string for JSON response
}

type ParkedPieceRef struct {
	RefID       int64           `db:"ref_id" json:"ref_id"`
	PieceID     int64           `db:"piece_id" json:"piece_id"`
	DataURL     sql.NullString  `db:"data_url" json:"data_url"`
	DataHeaders json.RawMessage `db:"data_headers" json:"data_headers"`
}

type ParkedPieceState struct {
	ID              int64            `db:"id" json:"id"`
	PieceCID        string           `db:"piece_cid" json:"piece_cid"`
	PiecePaddedSize int64            `db:"piece_padded_size" json:"piece_padded_size"`
	PieceRawSize    int64            `db:"piece_raw_size" json:"piece_raw_size"`
	Complete        bool             `db:"complete" json:"complete"`
	CreatedAt       time.Time        `db:"created_at" json:"created_at"`
	TaskID          sql.NullInt64    `db:"task_id" json:"task_id"`
	CleanupTaskID   sql.NullInt64    `db:"cleanup_task_id" json:"cleanup_task_id"`
	Refs            []ParkedPieceRef `json:"refs"`
}

type ParsedResponse struct {
	AddrInfo              AddrInfo       `json:"AddrInfo"`
	LastAdvertisement     Advertisement  `json:"LastAdvertisement"`
	LastAdvertisementTime time.Time      `json:"LastAdvertisementTime"`
	Publisher             AddrInfo       `json:"Publisher"`
	ExtendedProviders     map[string]any `json:"ExtendedProviders"`
	FrozenAt              string         `json:"FrozenAt"`
	LastError             string         `json:"LastError"`
}

type PendingMessage struct {
	Message string    `json:"message"`
	AddedAt time.Time `json:"added_at"`
}

type PendingMessageItem struct {
	MessageCid string    `db:"message_cid" json:"messageCid"`
	AddedAt    time.Time `db:"added_at" json:"addedAt"`
}

type PendingMessages struct {
	Messages []PendingMessage `json:"messages"`
	Total    int              `json:"total"`
}

type PieceDeal struct {
	// Cache line 1 (0-64 bytes): Hot path - identification fields used together
	ID    string `db:"id" json:"id"`       // 16 bytes - used with SpId (line 621-623)
	SpId  int64  `db:"sp_id" json:"sp_id"` // 8 bytes - checked early (line 614), used with ID (line 617)
	Miner string `json:"miner"`            // 16 bytes - set based on SpId (line 615, 625)
	// Cache line 2: Additional 8-byte types grouped together
	ChainDealId int64 `db:"chain_deal_id" json:"chain_deal_id"` // 8 bytes
	Sector      int64 `db:"sector_num" json:"sector"`           // 8 bytes
	Length      int64 `db:"piece_length" json:"length"`         // 8 bytes
	RawSize     int64 `db:"raw_size" json:"raw_size"`           // 8 bytes
	// NullInt64 (16 bytes)
	Offset NullInt64 `db:"piece_offset" json:"offset"` // 16 bytes
	// Cache line 3 (64+ bytes): Bools grouped together at the end to minimize padding
	MK20       bool `db:"-" json:"mk20"`                  // Used with ID check (line 621-623) - hot path
	BoostDeal  bool `db:"boost_deal" json:"boost_deal"`   // Less frequently accessed
	LegacyDeal bool `db:"legacy_deal" json:"legacy_deal"` // Less frequently accessed
}

type PieceDealDetailEntry struct {
	MK12 []PieceInfoMK12Deals `json:"mk12"`
	MK20 []PieceInfoMK20Deals `json:"mk20"`
}

type PieceInfo struct {
	// Cache line 1 (0-64 bytes): Hot path - piece identification used together
	PieceCidv2 string   `json:"piece_cid_v2"` // 16 bytes - used together with PieceCid (line 584)
	PieceCid   string   `json:"piece_cid"`    // 16 bytes - used with PieceCidv2 (line 584)
	Size       int64    `json:"size"`         // 8 bytes - used with PieceCid (line 587, 604)
	IPNIAd     []string `json:"ipni_ads"`     // 24 bytes - used for results
	// Cache line 2 (64+ bytes): Display
	CreatedAt time.Time `json:"created_at"` // 24 bytes - used for display
	IndexedAT time.Time `json:"indexed_at"` // 24 bytes - used for display
	Indexed   bool      `json:"indexed"`    // Used for display
	// Cache line 3
	Deals []PieceDeal `json:"deals"` // 24 bytes - used for results
}

type PieceInfoMK12Deals struct {
	Deal     *MK12Deal         `json:"deal"`
	Pipeline *MK12DealPipeline `json:"mk12_pipeline,omitempty"`
}

type PieceInfoMK20Deals struct {
	Deal        *MK20StorageDeal `json:"deal"`
	DDOPipeline *MK20DDOPipeline `json:"mk20_ddo_pipeline,omitempty"`
	PDPPipeline *MK20PDPPipeline `json:"mk20_pdp_pipeline,omitempty"`
}

type PieceSummary struct {
	Total       int64     `db:"total" json:"total"`
	Indexed     int64     `db:"indexed" json:"indexed"`
	Announced   int64     `db:"announced" json:"announced"`
	LastUpdated time.Time `db:"last_updated" json:"last_updated"`
}

type PipelineStage = webrpctypes.PipelineStage

type PipelineStats = webrpctypes.PipelineStats

type PriceFilter struct {
	Name string `db:"name" json:"name"`

	MinDur int `db:"min_duration_days" json:"min_dur"`
	MaxDur int `db:"max_duration_days" json:"max_dur"`

	MinSize int64 `db:"min_size" json:"min_size"`
	MaxSize int64 `db:"max_size" json:"max_size"`

	Price    int64 `db:"price" json:"price"`
	Verified bool  `db:"verified" json:"verified"`
}

type ProvingActivityDay struct {
	Date    string `json:"date"`
	Success int    `json:"success"`
	Failed  int    `json:"failed"`
	Faulted int    `json:"faulted"`
}

type RpcInfo struct {
	Address   string
	CLayers   []string
	Reachable bool
	SyncState string
	Version   string
}

type SectorEvent struct {
	SpID         uint64 `db:"sp_id"`
	SectorNumber uint64 `db:"sector_number"`

	Addr address.Address `db:"-"`
}

type SingletonInfo struct {
	TaskName      string     `db:"task_name" json:"TaskName"`
	TaskID        NullInt64  `db:"task_id" json:"TaskID"`
	LastRunTime   *time.Time `db:"last_run_time" json:"LastRunTime"`
	RunNowRequest bool       `db:"run_now_request" json:"RunNowRequest"`
}

type SpidGetter interface {
	GetSpid(db *harmonydb.DB, taskID int64) string
}

type StorageAsk struct {
	SpID          int64 `db:"sp_id"`
	Price         int64 `db:"price"`
	VerifiedPrice int64 `db:"verified_price"`
	MinSize       int64 `db:"min_size"`
	MaxSize       int64 `db:"max_size"`
	CreatedAt     int64 `db:"created_at"`
	Expiry        int64 `db:"expiry"`
	Sequence      int64 `db:"sequence"`
	Miner         string
}

type StorageDealList struct {
	ID         string     `db:"uuid" json:"id"`
	MinerID    int64      `db:"sp_id" json:"sp_id"`
	CreatedAt  time.Time  `db:"created_at" json:"created_at"`
	PieceCidV1 string     `db:"piece_cid" json:"piece_cid"`
	PieceSize  int64      `db:"piece_size" json:"piece_size"`
	RawSize    NullInt64  `db:"raw_size"`
	PieceCidV2 string     `json:"piece_cid_v2"`
	Processed  bool       `db:"processed" json:"processed"`
	Error      NullString `db:"error" json:"error"`
	Miner      string     `json:"miner"`
}

type StorageDealSummary struct {
	ID                string         `db:"uuid" json:"id"`
	MinerID           int64          `db:"sp_id" json:"sp_id"`
	Sector            NullInt64      `db:"sector_num" json:"sector"`
	CreatedAt         time.Time      `db:"created_at" json:"created_at"`
	SignedProposalCid string         `db:"signed_proposal_cid" json:"signed_proposal_cid"`
	Offline           bool           `db:"offline" json:"offline"`
	Verified          bool           `db:"verified" json:"verified"`
	StartEpoch        int64          `db:"start_epoch" json:"start_epoch"`
	EndEpoch          int64          `db:"end_epoch" json:"end_epoch"`
	ClientPeerId      string         `db:"client_peer_id" json:"client_peer_id"`
	ChainDealId       NullInt64      `db:"chain_deal_id" json:"chain_deal_id"`
	PublishCid        NullString     `db:"publish_cid" json:"publish_cid"`
	PieceCid          string         `db:"piece_cid" json:"piece_cid"`
	PieceSize         int64          `db:"piece_size" json:"piece_size"`
	RawSize           sql.NullInt64  `db:"raw_size"`
	FastRetrieval     bool           `db:"fast_retrieval" json:"fast_retrieval"`
	AnnounceToIpni    bool           `db:"announce_to_ipni" json:"announce_to_ipni"`
	Url               sql.NullString `db:"url"`
	URLS              string         `json:"url"`
	Header            []byte         `db:"url_headers"`
	UrlHeaders        http.Header    `json:"url_headers"`
	DBError           sql.NullString `db:"error"`
	Error             string         `json:"error"`
	Miner             string         `json:"miner"`
	Indexed           sql.NullBool   `db:"indexed" json:"indexed"`
	IsDDO             bool           `db:"is_ddo" json:"is_ddo"`
	PieceCidV2        string         `json:"piece_cid_v2"`
}

type StoragePathInfo struct {
	StorageID     string     `db:"storage_id"`
	URLs          *string    `db:"urls"`
	Weight        *int64     `db:"weight"`
	MaxStorage    *int64     `db:"max_storage"`
	CanSeal       *bool      `db:"can_seal"`
	CanStore      *bool      `db:"can_store"`
	Groups        *string    `db:"groups"`
	AllowTo       *string    `db:"allow_to"`
	AllowTypes    *string    `db:"allow_types"`
	DenyTypes     *string    `db:"deny_types"`
	Capacity      *int64     `db:"capacity"`
	Available     *int64     `db:"available"`
	FSAvailable   *int64     `db:"fs_available"`
	Reserved      *int64     `db:"reserved"`
	Used          *int64     `db:"used"`
	LastHeartbeat *time.Time `db:"last_heartbeat"`
	HeartbeatErr  *string    `db:"heartbeat_err"`
	AllowMiners   string     `db:"allow_miners"`
	DenyMiners    string     `db:"deny_miners"`

	// Computed fields for UI (not from DB)
	LocalPath       string   `json:"LocalPath,omitempty"`
	PathType        string   `json:"PathType,omitempty"`
	CapacityStr     string   `json:"CapacityStr,omitempty"`
	AvailableStr    string   `json:"AvailableStr,omitempty"`
	FSAvailableStr  string   `json:"FSAvailableStr,omitempty"`
	ReservedStr     string   `json:"ReservedStr,omitempty"`
	UsedStr         string   `json:"UsedStr,omitempty"`
	MaxStorageStr   string   `json:"MaxStorageStr,omitempty"`
	UsedPercent     float64  `json:"UsedPercent,omitempty"`
	ReservedPercent float64  `json:"ReservedPercent,omitempty"`
	HealthStatus    string   `json:"HealthStatus,omitempty"`
	HealthOK        bool     `json:"HealthOK,omitempty"`
	URLList         []string `json:"URLList,omitempty"`
	HostList        []string `json:"HostList,omitempty"`
	GroupList       []string `json:"GroupList,omitempty"`
	AllowToList     []string `json:"AllowToList,omitempty"`
	AllowTypesList  []string `json:"AllowTypesList,omitempty"`
	DenyTypesList   []string `json:"DenyTypesList,omitempty"`
	AllowMinersList []string `json:"AllowMinersList,omitempty"`
	DenyMinersList  []string `json:"DenyMinersList,omitempty"`
}

type TaskHistorySummary struct {
	Name   string
	TaskID int64

	Posted, Start, Queued, Took string

	Result bool
	Err    string

	CompletedBy string
}

type TaskStatus struct {
	TaskID   int64   `json:"task_id"`
	Status   string  `json:"status"` // "pending", "running", "done", "failed"
	OwnerID  *int64  `json:"owner_id,omitempty"`
	Name     string  `json:"name"`
	PostedAt *string `json:"posted_at,omitempty"`
}

type TaskSummary struct {
	ID             int64
	Name           string
	SpID           string
	SincePosted    time.Time `db:"since_posted"`
	Owner, OwnerID *string

	// db ignored
	SincePostedStr string `db:"-"`

	Miner string
}

type UploadStatus struct {
	ID     string            `json:"id"`
	Status mk20.UploadStatus `json:"status"`
}

type WalletBalances struct {
	Address string `json:"address"`
	Balance string `json:"balance"`
}

type WalletInfoShort struct {
	IDAddress       string `json:"id_address"`
	KeyAddress      string `json:"key_address"`
	Balance         string `json:"balance"`
	PendingMessages int    `json:"pending_messages"`
}

type WebRPC = Handler