database

type BlockEntry struct {
	Id         int
	Created_At sql.NullTime

	Reorg_Key string
	Origin    string
	NodeUri   string

	BlockNumber     uint64
	BlockHash       string
	ParentHash      string
	BlockTimestamp  uint64
	CoinbaseAddress string

	Difficulty uint64
	NumUncles  int
	NumTx      int

	IsPartOfReorg bool
	IsMainChain   bool
	IsFirst       bool

	MevGeth_CoinbaseDiffWei      string
	MevGeth_GasFeesWei           string
	MevGeth_EthSentToCoinbaseWei string

	MevGeth_CoinbaseDiffEth   string
	MevGeth_EthSentToCoinbase string
}

type DatabaseService struct {
	DB *sqlx.DB
}

type ReorgEntry struct {
	Id         int
	Created_At sql.NullTime

	Key      string
	SeenLive bool

	StartBlockNumber  uint64
	EndBlockNumber    uint64
	Depth             int
	NumChains         int
	NumBlocksInvolved int
	NumBlocksReplaced int
	MermaidSyntax     string
}