dbtypes

type AssignedBlob struct {
	Root       []byte `db:"root"`
	Commitment []byte `db:"commitment"`
	Slot       uint64 `db:"slot"`
	Blob       *Blob  `db:"blob"`
}

type AssignedSlot struct {
	Slot     uint64 `db:"slot"`
	Proposer uint64 `db:"proposer"`
	Block    *Slot  `db:"block"`
}

type Blob struct {
	Commitment []byte  `db:"commitment"`
	Proof      []byte  `db:"proof"`
	Size       uint32  `db:"size"`
	Blob       *[]byte `db:"blob"`
}

type BlobAssignment struct {
	Root       []byte `db:"root"`
	Commitment []byte `db:"commitment"`
	Slot       uint64 `db:"slot"`
}

type BlockBlobCount struct {
	Root         []byte `db:"root"`
	EthBlockHash []byte `db:"eth_block_hash"`
	BlobCount    uint64 `db:"blob_count"`
}

type BlockFilter struct {
	Graffiti             string
	InvertGraffiti       bool
	ExtraData            string
	InvertExtraData      bool
	ProposerIndex        *uint64
	ProposerName         string
	InvertProposer       bool
	WithOrphaned         uint8
	WithMissing          uint8
	MinSyncParticipation *float32
	MaxSyncParticipation *float32
	MinExecTime          *uint32
	MaxExecTime          *uint32
	MinTxCount           *uint64
	MaxTxCount           *uint64
	MinBlobCount         *uint64
	MaxBlobCount         *uint64
	Slot                 *uint64  // Filter by specific slot number
	BlockRoot            []byte   // Filter by specific block root
	ForkIds              []uint64 // Filter by fork IDs
}

type BlockHead struct {
	Slot       uint64 `db:"slot"`
	Root       []byte `db:"root"`
	ParentRoot []byte `db:"parent_root"`
	ForkId     uint64 `db:"fork_id"`
}

type BlockStatus struct {
	Root   []byte     `db:"root"`
	Status SlotStatus `db:"status"`
}

type ConsolidationRequest struct {
	SlotNumber    uint64  `db:"slot_number"`
	SlotRoot      []byte  `db:"slot_root"`
	SlotIndex     uint64  `db:"slot_index"`
	Orphaned      bool    `db:"orphaned"`
	ForkId        uint64  `db:"fork_id"`
	SourceAddress []byte  `db:"source_address"`
	SourceIndex   *uint64 `db:"source_index"`
	SourcePubkey  []byte  `db:"source_pubkey"`
	TargetIndex   *uint64 `db:"target_index"`
	TargetPubkey  []byte  `db:"target_pubkey"`
	TxHash        []byte  `db:"tx_hash"`
	BlockNumber   uint64  `db:"block_number"`
	Result        uint8   `db:"result"`
}

type ConsolidationRequestFilter struct {
	MinSlot          uint64
	MaxSlot          uint64
	PublicKey        []byte
	SourceAddress    []byte
	MinSrcIndex      uint64
	MaxSrcIndex      uint64
	SrcValidatorName string
	MinTgtIndex      uint64
	MaxTgtIndex      uint64
	TgtValidatorName string
	WithOrphaned     uint8
}

type ConsolidationRequestTx struct {
	BlockNumber   uint64  `db:"block_number"`
	BlockIndex    uint64  `db:"block_index"`
	BlockTime     uint64  `db:"block_time"`
	BlockRoot     []byte  `db:"block_root"`
	ForkId        uint64  `db:"fork_id"`
	SourceAddress []byte  `db:"source_address"`
	SourcePubkey  []byte  `db:"source_pubkey"`
	SourceIndex   *uint64 `db:"source_index"`
	TargetPubkey  []byte  `db:"target_pubkey"`
	TargetIndex   *uint64 `db:"target_index"`
	TxHash        []byte  `db:"tx_hash"`
	TxSender      []byte  `db:"tx_sender"`
	TxTarget      []byte  `db:"tx_target"`
	DequeueBlock  uint64  `db:"dequeue_block"`
}

type ConsolidationRequestTxFilter struct {
	MinDequeue       uint64
	MaxDequeue       uint64
	PublicKey        []byte
	SourceAddress    []byte
	MinSrcIndex      uint64
	MaxSrcIndex      uint64
	SrcValidatorName string
	MinTgtIndex      uint64
	MaxTgtIndex      uint64
	TgtValidatorName string
	WithOrphaned     uint8
}

type DBEngineType int

type Deposit struct {
	Index                 *uint64 `db:"deposit_index"`
	SlotNumber            uint64  `db:"slot_number"`
	SlotIndex             uint64  `db:"slot_index"`
	SlotRoot              []byte  `db:"slot_root"`
	Orphaned              bool    `db:"orphaned"`
	PublicKey             []byte  `db:"publickey"`
	WithdrawalCredentials []byte  `db:"withdrawalcredentials"`
	Amount                uint64  `db:"amount"`
	ForkId                uint64  `db:"fork_id"`
}

type DepositFilter struct {
	MinIndex      uint64
	MaxIndex      uint64
	PublicKey     []byte
	ValidatorName string
	MinAmount     uint64
	MaxAmount     uint64
	WithOrphaned  uint8
}

type DepositIndexerState struct {
	FinalBlock   uint64 `json:"final_block"`
	HeadBlock    uint64 `json:"head_block"`
	DepositIndex uint64 `json:"deposit_index"`
}

type DepositTx struct {
	Index                 uint64 `db:"deposit_index"`
	BlockNumber           uint64 `db:"block_number"`
	BlockTime             uint64 `db:"block_time"`
	BlockRoot             []byte `db:"block_root"`
	PublicKey             []byte `db:"publickey"`
	WithdrawalCredentials []byte `db:"withdrawalcredentials"`
	Amount                uint64 `db:"amount"`
	Signature             []byte `db:"signature"`
	ValidSignature        uint8  `db:"valid_signature"`
	Orphaned              bool   `db:"orphaned"`
	TxHash                []byte `db:"tx_hash"`
	TxSender              []byte `db:"tx_sender"`
	TxTarget              []byte `db:"tx_target"`
	ForkId                uint64 `db:"fork_id"`
}

type DepositTxFilter struct {
	MinIndex          uint64
	MaxIndex          uint64
	Address           []byte
	TargetAddress     []byte
	PublicKey         []byte
	PublicKeys        [][]byte
	WithdrawalAddress []byte
	ValidatorName     string
	MinAmount         uint64
	MaxAmount         uint64
	WithOrphaned      uint8
	WithValid         uint8
}

type DepositWithTx struct {
	Deposit
	BlockNumber    *uint64 `db:"block_number"`
	BlockTime      *uint64 `db:"block_time"`
	BlockRoot      []byte  `db:"block_root"`
	ValidSignature *uint8  `db:"valid_signature"`
	TxHash         []byte  `db:"tx_hash"`
	TxSender       []byte  `db:"tx_sender"`
	TxTarget       []byte  `db:"tx_target"`
}

type Epoch struct {
	Epoch                 uint64  `db:"epoch"`
	ValidatorCount        uint64  `db:"validator_count"`
	ValidatorBalance      uint64  `db:"validator_balance"`
	Eligible              uint64  `db:"eligible"`
	VotedTarget           uint64  `db:"voted_target"`
	VotedHead             uint64  `db:"voted_head"`
	VotedTotal            uint64  `db:"voted_total"`
	BlockCount            uint16  `db:"block_count"`
	OrphanedCount         uint16  `db:"orphaned_count"`
	AttestationCount      uint64  `db:"attestation_count"`
	DepositCount          uint64  `db:"deposit_count"`
	ExitCount             uint64  `db:"exit_count"`
	WithdrawCount         uint64  `db:"withdraw_count"`
	WithdrawAmount        uint64  `db:"withdraw_amount"`
	AttesterSlashingCount uint64  `db:"attester_slashing_count"`
	ProposerSlashingCount uint64  `db:"proposer_slashing_count"`
	BLSChangeCount        uint64  `db:"bls_change_count"`
	EthTransactionCount   uint64  `db:"eth_transaction_count"`
	BlobCount             uint64  `db:"blob_count"`
	EthGasUsed            uint64  `db:"eth_gas_used"`
	EthGasLimit           uint64  `db:"eth_gas_limit"`
	SyncParticipation     float32 `db:"sync_participation"`
}

type ExplorerState struct {
	Key   string `db:"key"`
	Value string `db:"value"`
}

type Fork struct {
	ForkId     uint64 `db:"fork_id"`
	BaseSlot   uint64 `db:"base_slot"`
	BaseRoot   []byte `db:"base_root"`
	LeafSlot   uint64 `db:"leaf_slot"`
	LeafRoot   []byte `db:"leaf_root"`
	ParentFork uint64 `db:"parent_fork"`
}

type IndexerForkState struct {
	ForkId    uint64 `json:"fork_id"`
	Finalized uint64 `json:"finalized"`
}

type IndexerPruneState struct {
	Epoch uint64 `json:"epoch"`
}

type IndexerSyncState struct {
	Epoch uint64 `json:"epoch"`
}

type MevBlock struct {
	SlotNumber     uint64 `db:"slot_number"`
	BlockHash      []byte `db:"block_hash"`
	BlockNumber    uint64 `db:"block_number"`
	BuilderPubkey  []byte `db:"builder_pubkey"`
	ProposerIndex  uint64 `db:"proposer_index"`
	Proposed       uint8  `db:"proposed"`
	SeenbyRelays   uint64 `db:"seenby_relays"`
	FeeRecipient   []byte `db:"fee_recipient"`
	TxCount        uint64 `db:"tx_count"`
	GasUsed        uint64 `db:"gas_used"`
	BlockValue     []byte `db:"block_value"`
	BlockValueGwei uint64 `db:"block_value_gwei"`
}

type MevBlockFilter struct {
	MinSlot       uint64
	MaxSlot       uint64
	MinIndex      uint64
	MaxIndex      uint64
	ProposerName  string
	BuilderPubkey []byte
	Proposed      []uint8
	MevRelay      []uint8
}

type OrphanedBlock struct {
	Root      []byte `db:"root"`
	HeaderVer uint64 `db:"header_ver"`
	HeaderSSZ []byte `db:"header_ssz"`
	BlockVer  uint64 `db:"block_ver"`
	BlockSSZ  []byte `db:"block_ssz"`
}

type OrphanedEpoch struct {
	Epoch                 uint64  `db:"epoch"`
	DependentRoot         []byte  `db:"dependent_root"`
	EpochHeadRoot         []byte  `db:"epoch_head_root"`
	EpochHeadForkId       uint64  `db:"epoch_head_fork_id"`
	ValidatorCount        uint64  `db:"validator_count"`
	ValidatorBalance      uint64  `db:"validator_balance"`
	Eligible              uint64  `db:"eligible"`
	VotedTarget           uint64  `db:"voted_target"`
	VotedHead             uint64  `db:"voted_head"`
	VotedTotal            uint64  `db:"voted_total"`
	BlockCount            uint16  `db:"block_count"`
	OrphanedCount         uint16  `db:"orphaned_count"`
	AttestationCount      uint64  `db:"attestation_count"`
	DepositCount          uint64  `db:"deposit_count"`
	ExitCount             uint64  `db:"exit_count"`
	WithdrawCount         uint64  `db:"withdraw_count"`
	WithdrawAmount        uint64  `db:"withdraw_amount"`
	AttesterSlashingCount uint64  `db:"attester_slashing_count"`
	ProposerSlashingCount uint64  `db:"proposer_slashing_count"`
	BLSChangeCount        uint64  `db:"bls_change_count"`
	EthTransactionCount   uint64  `db:"eth_transaction_count"`
	BlobCount             uint64  `db:"blob_count"`
	EthGasUsed            uint64  `db:"eth_gas_used"`
	EthGasLimit           uint64  `db:"eth_gas_limit"`
	SyncParticipation     float32 `db:"sync_participation"`
}

type SearchAheadEpochsResult []struct {
	Epoch uint64 `db:"epoch"`
}

type SearchAheadExecBlocksResult []struct {
	Slot       uint64     `db:"slot"`
	Root       []byte     `db:"root"`
	ExecHash   []byte     `db:"eth_block_hash"`
	ExecNumber uint64     `db:"eth_block_number"`
	Status     SlotStatus `db:"status"`
}

type SearchAheadGraffitiResult []struct {
	Graffiti string `db:"graffiti"`
	Count    uint64 `db:"count"`
}

type SearchAheadSlotsResult []struct {
	Slot   uint64     `db:"slot"`
	Root   []byte     `db:"root"`
	Status SlotStatus `db:"status"`
}

type SearchAheadValidatorNameResult []struct {
	Name  string `db:"name"`
	Count uint64 `db:"count"`
}

type SearchAheadValidatorResult []struct {
	Index  uint64 `db:"validator_index"`
	Pubkey []byte `db:"pubkey"`
	Name   string `db:"name"`
}

type SearchBlockResult struct {
	Slot   uint64     `db:"slot"`
	Root   []byte     `db:"root"`
	Status SlotStatus `db:"status"`
}

type SearchGraffitiResult struct {
	Graffiti string `db:"graffiti"`
}

type SearchNameResult struct {
	Name string `db:"name"`
}

type Slashing struct {
	SlotNumber     uint64         `db:"slot_number"`
	SlotIndex      uint64         `db:"slot_index"`
	SlotRoot       []byte         `db:"slot_root"`
	Orphaned       bool           `db:"orphaned"`
	ValidatorIndex uint64         `db:"validator"`
	SlasherIndex   uint64         `db:"slasher"`
	Reason         SlashingReason `db:"reason"`
	ForkId         uint64         `db:"fork_id"`
}

type SlashingFilter struct {
	MinSlot       uint64
	MaxSlot       uint64
	MinIndex      uint64
	MaxIndex      uint64
	ValidatorName string
	SlasherName   string
	WithOrphaned  uint8
	WithReason    SlashingReason
}

type SlashingReason uint8

type Slot struct {
	Slot                  uint64     `db:"slot"`
	Proposer              uint64     `db:"proposer"`
	Status                SlotStatus `db:"status"`
	Root                  []byte     `db:"root"`
	ParentRoot            []byte     `db:"parent_root"`
	StateRoot             []byte     `db:"state_root"`
	Graffiti              []byte     `db:"graffiti"`
	GraffitiText          string     `db:"graffiti_text"`
	AttestationCount      uint64     `db:"attestation_count"`
	DepositCount          uint64     `db:"deposit_count"`
	ExitCount             uint64     `db:"exit_count"`
	WithdrawCount         uint64     `db:"withdraw_count"`
	WithdrawAmount        uint64     `db:"withdraw_amount"`
	AttesterSlashingCount uint64     `db:"attester_slashing_count"`
	ProposerSlashingCount uint64     `db:"proposer_slashing_count"`
	BLSChangeCount        uint64     `db:"bls_change_count"`
	EthTransactionCount   uint64     `db:"eth_transaction_count"`
	BlobCount             uint64     `db:"blob_count"`
	EthGasUsed            uint64     `db:"eth_gas_used"`
	EthGasLimit           uint64     `db:"eth_gas_limit"`
	EthBaseFee            uint64     `db:"eth_base_fee"`
	EthFeeRecipient       []byte     `db:"eth_fee_recipient"`
	EthBlockNumber        *uint64    `db:"eth_block_number"`
	EthBlockHash          []byte     `db:"eth_block_hash"`
	EthBlockExtra         []byte     `db:"eth_block_extra"`
	EthBlockExtraText     string     `db:"eth_block_extra_text"`
	SyncParticipation     float32    `db:"sync_participation"`
	ForkId                uint64     `db:"fork_id"`
	BlockSize             uint64     `db:"block_size"`
	RecvDelay             int32      `db:"recv_delay"`
	MinExecTime           uint32     `db:"min_exec_time"`
	MaxExecTime           uint32     `db:"max_exec_time"`
	ExecTimes             []byte     `db:"exec_times"`
}

type SlotAssignment struct {
	Slot     uint64 `db:"slot"`
	Proposer uint64 `db:"proposer"`
}

type SlotHeader struct {
	Slot     uint64     `db:"slot"`
	Proposer uint64     `db:"proposer"`
	Status   SlotStatus `db:"status"`
}

type SlotStatus uint8

type SyncAssignment struct {
	Period    uint64 `db:"period"`
	Index     uint32 `db:"index"`
	Validator uint64 `db:"validator"`
}

type TxFunctionSignature struct {
	Signature string `db:"signature"`
	Bytes     []byte `db:"bytes"`
	Name      string `db:"name"`
}

type TxPendingFunctionSignature struct {
	Bytes     []byte `db:"bytes"`
	QueueTime uint64 `db:"queuetime"`
}

type TxUnknownFunctionSignature struct {
	Bytes     []byte `db:"bytes"`
	LastCheck uint64 `db:"lastcheck"`
}

type UnfinalizedBlock struct {
	Root        []byte                 `db:"root"`
	Slot        uint64                 `db:"slot"`
	HeaderVer   uint64                 `db:"header_ver"`
	HeaderSSZ   []byte                 `db:"header_ssz"`
	BlockVer    uint64                 `db:"block_ver"`
	BlockSSZ    []byte                 `db:"block_ssz"`
	Status      UnfinalizedBlockStatus `db:"status"`
	ForkId      uint64                 `db:"fork_id"`
	RecvDelay   int32                  `db:"recv_delay"`
	MinExecTime uint32                 `db:"min_exec_time"`
	MaxExecTime uint32                 `db:"max_exec_time"`
	ExecTimes   []byte                 `db:"exec_times"`
}

type UnfinalizedBlockFilter struct {
	MinSlot  uint64
	MaxSlot  uint64
	WithBody bool
}

type UnfinalizedBlockStatus uint32

type UnfinalizedDuty struct {
	Epoch         uint64 `db:"epoch"`
	DependentRoot []byte `db:"dependent_root"`
	DutiesSSZ     []byte `db:"duties"`
}

type UnfinalizedEpoch struct {
	Epoch                 uint64  `db:"epoch"`
	DependentRoot         []byte  `db:"dependent_root"`
	EpochHeadRoot         []byte  `db:"epoch_head_root"`
	EpochHeadForkId       uint64  `db:"epoch_head_fork_id"`
	ValidatorCount        uint64  `db:"validator_count"`
	ValidatorBalance      uint64  `db:"validator_balance"`
	Eligible              uint64  `db:"eligible"`
	VotedTarget           uint64  `db:"voted_target"`
	VotedHead             uint64  `db:"voted_head"`
	VotedTotal            uint64  `db:"voted_total"`
	BlockCount            uint16  `db:"block_count"`
	OrphanedCount         uint16  `db:"orphaned_count"`
	AttestationCount      uint64  `db:"attestation_count"`
	DepositCount          uint64  `db:"deposit_count"`
	ExitCount             uint64  `db:"exit_count"`
	WithdrawCount         uint64  `db:"withdraw_count"`
	WithdrawAmount        uint64  `db:"withdraw_amount"`
	AttesterSlashingCount uint64  `db:"attester_slashing_count"`
	ProposerSlashingCount uint64  `db:"proposer_slashing_count"`
	BLSChangeCount        uint64  `db:"bls_change_count"`
	EthTransactionCount   uint64  `db:"eth_transaction_count"`
	BlobCount             uint64  `db:"blob_count"`
	EthGasUsed            uint64  `db:"eth_gas_used"`
	EthGasLimit           uint64  `db:"eth_gas_limit"`
	SyncParticipation     float32 `db:"sync_participation"`
}

type Validator struct {
	ValidatorIndex             uint64 `db:"validator_index"`
	Pubkey                     []byte `db:"pubkey"`
	WithdrawalCredentials      []byte `db:"withdrawal_credentials"`
	EffectiveBalance           uint64 `db:"effective_balance"`
	Slashed                    bool   `db:"slashed"`
	ActivationEligibilityEpoch int64  `db:"activation_eligibility_epoch"`
	ActivationEpoch            int64  `db:"activation_epoch"`
	ExitEpoch                  int64  `db:"exit_epoch"`
	WithdrawableEpoch          int64  `db:"withdrawable_epoch"`
}

type ValidatorFilter struct {
	MinIndex          *uint64
	MaxIndex          *uint64
	Indices           []phase0.ValidatorIndex
	PubKey            []byte
	WithdrawalAddress []byte
	WithdrawalCreds   []byte
	ValidatorName     string
	Status            []v1.ValidatorState

	OrderBy ValidatorOrder
	Limit   uint64
	Offset  uint64
}

type ValidatorName struct {
	Index uint64 `db:"index"`
	Name  string `db:"name"`
}

type ValidatorOrder uint8

type VoluntaryExit struct {
	SlotNumber     uint64 `db:"slot_number"`
	SlotIndex      uint64 `db:"slot_index"`
	SlotRoot       []byte `db:"slot_root"`
	Orphaned       bool   `db:"orphaned"`
	ValidatorIndex uint64 `db:"validator"`
	ForkId         uint64 `db:"fork_id"`
}

type VoluntaryExitFilter struct {
	MinSlot       uint64
	MaxSlot       uint64
	MinIndex      uint64
	MaxIndex      uint64
	ValidatorName string
	WithOrphaned  uint8
}

type WithdrawalRequest struct {
	SlotNumber      uint64  `db:"slot_number"`
	SlotRoot        []byte  `db:"slot_root"`
	SlotIndex       uint64  `db:"slot_index"`
	Orphaned        bool    `db:"orphaned"`
	ForkId          uint64  `db:"fork_id"`
	SourceAddress   []byte  `db:"source_address"`
	ValidatorIndex  *uint64 `db:"validator_index"`
	ValidatorPubkey []byte  `db:"validator_pubkey"`
	Amount          int64   `db:"amount"`
	TxHash          []byte  `db:"tx_hash"`
	BlockNumber     uint64  `db:"block_number"`
	Result          uint8   `db:"result"`
}

type WithdrawalRequestFilter struct {
	MinSlot       uint64
	MaxSlot       uint64
	PublicKey     []byte
	SourceAddress []byte
	MinIndex      uint64
	MaxIndex      uint64
	ValidatorName string
	MinAmount     *uint64
	MaxAmount     *uint64
	WithOrphaned  uint8
}

type WithdrawalRequestTx struct {
	BlockNumber     uint64  `db:"block_number"`
	BlockIndex      uint64  `db:"block_index"`
	BlockTime       uint64  `db:"block_time"`
	BlockRoot       []byte  `db:"block_root"`
	ForkId          uint64  `db:"fork_id"`
	SourceAddress   []byte  `db:"source_address"`
	ValidatorPubkey []byte  `db:"validator_pubkey"`
	ValidatorIndex  *uint64 `db:"validator_index"`
	Amount          int64   `db:"amount"`
	TxHash          []byte  `db:"tx_hash"`
	TxSender        []byte  `db:"tx_sender"`
	TxTarget        []byte  `db:"tx_target"`
	DequeueBlock    uint64  `db:"dequeue_block"`
}

type WithdrawalRequestTxFilter struct {
	MinDequeue    uint64
	MaxDequeue    uint64
	PublicKey     []byte
	SourceAddress []byte
	MinIndex      uint64
	MaxIndex      uint64
	ValidatorName string
	MinAmount     *uint64
	MaxAmount     *uint64
	WithOrphaned  uint8
}