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 BlockFilter struct {
	Graffiti      string
	ExtraData     string
	ProposerIndex *uint64
	ProposerName  string
	WithOrphaned  uint8
	WithMissing   uint8
}

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

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"`
}

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        bool   `db:"valid_signature"`
	Orphaned              bool   `db:"orphaned"`
	TxHash                []byte `db:"tx_hash"`
	TxSender              []byte `db:"tx_sender"`
	TxTarget              []byte `db:"tx_target"`
}

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

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"`
	SyncParticipation     float32 `db:"sync_participation"`
}

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

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 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"`
	Orphaned   bool   `db:"orphaned"`
}

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

type SearchAheadSlotsResult []struct {
	Slot     uint64 `db:"slot"`
	Root     []byte `db:"root"`
	Orphaned bool   `db:"orphaned"`
}

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

type SearchBlockResult struct {
	Slot     uint64 `db:"slot"`
	Root     []byte `db:"root"`
	Orphaned bool   `db:"orphaned"`
}

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"`
}

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"`
	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"`
}

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"`
}

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

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"`
}

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