table

type AverageTaxRateSubmission struct {
	ID              uint64          `gorm:"id"`
	EpochID         uint64          `gorm:"epoch_id"`
	AverageTaxRate  decimal.Decimal `gorm:"average_tax_rate"`
	TransactionHash string          `gorm:"transaction_hash"`
	CreatedAt       time.Time       `gorm:"created_at"`
	UpdatedAt       time.Time       `gorm:"updated_at"`
}

type AverageTaxSubmissions []AverageTaxRateSubmission

type BridgeEvent struct {
	ID                string    `gorm:"column:id"`
	Type              string    `gorm:"column:type"`
	TransactionHash   string    `gorm:"column:transaction_hash;primaryKey"`
	TransactionIndex  uint      `gorm:"column:transaction_index"`
	TransactionStatus uint64    `gorm:"column:transaction_status"`
	ChainID           uint64    `gorm:"column:chain_id"`
	BlockHash         string    `gorm:"column:block_hash;primaryKey"`
	BlockNumber       uint64    `gorm:"column:block_number"`
	BlockTimestamp    time.Time `gorm:"column:block_timestamp"`
	Finalized         bool      `gorm:"column:finalized"`
}

type BridgeTransaction struct {
	ID               string          `gorm:"column:id;primaryKey"`
	Type             string          `gorm:"column:type;primaryKey"`
	Sender           string          `gorm:"column:sender"`
	Receiver         string          `gorm:"column:receiver"`
	TokenAddressL1   *string         `gorm:"column:token_address_l1"`
	TokenAddressL2   *string         `gorm:"column:token_address_l2"`
	TokenValue       decimal.Decimal `gorm:"column:token_value"`
	Data             string          `gorm:"column:data"`
	ChainID          uint64          `gorm:"column:chain_id"`
	BlockTimestamp   time.Time       `gorm:"column:block_timestamp"`
	BlockNumber      uint64          `gorm:"column:block_number"`
	TransactionIndex uint            `gorm:"column:transaction_index"`
	Finalized        bool            `gorm:"column:finalized"`
}

type Checkpoint struct {
	ChainID     uint64    `gorm:"column:chain_id"`
	BlockNumber uint64    `gorm:"column:block_number"`
	BlockHash   string    `gorm:"column:block_hash"`
	CreatedAt   time.Time `gorm:"column:created_at"`
	UpdatedAt   time.Time `gorm:"column:updated_at"`
}

type Epoch struct {
	ID                    uint64          `gorm:"column:id;primaryKey"`
	StartTimestamp        time.Time       `gorm:"column:start_timestamp"`
	EndTimestamp          time.Time       `gorm:"column:end_timestamp"`
	TransactionHash       string          `gorm:"column:transaction_hash"`
	TransactionIndex      uint            `gorm:"column:transaction_index"`
	BlockHash             string          `gorm:"column:block_hash"`
	BlockNumber           uint64          `gorm:"column:block_number"`
	BlockTimestamp        time.Time       `gorm:"column:block_timestamp"`
	TotalOperationRewards decimal.Decimal `gorm:"column:total_operation_rewards"`
	TotalStakingRewards   decimal.Decimal `gorm:"column:total_staking_rewards"`
	TotalRewardedNodes    int             `gorm:"column:total_rewarded_nodes"`
	TotalRequestCounts    decimal.Decimal `gorm:"column:total_request_counts"`
	Finalized             bool            `gorm:"column:finalized"`

	CreatedAt time.Time `gorm:"column:created_at"`
	UpdatedAt time.Time `gorm:"column:updated_at"`
}

type EpochAPYSnapshot struct {
	EpochID   uint64          `gorm:"column:epoch_id"`
	Date      time.Time       `gorm:"column:date"`
	APY       decimal.Decimal `gorm:"column:apy"`
	CreatedAt time.Time       `gorm:"column:created_at"`
	UpdatedAt time.Time       `gorm:"column:updated_at"`
}

type EpochAPYSnapshots []EpochAPYSnapshot

type EpochItems []*NodeRewardRecord

type EpochTrigger struct {
	TransactionHash string          `gorm:"column:transaction_hash"`
	EpochID         uint64          `gorm:"column:epoch_id"`
	Data            json.RawMessage `gorm:"column:data"`
	CreatedAt       time.Time       `gorm:"column:created_at"`
	UpdatedAt       time.Time       `gorm:"column:updated_at"`
}

type EpochTriggers []*EpochTrigger

type Epochs []*Epoch

type Node struct {
	Address                common.Address    `gorm:"column:address;primaryKey"`
	NodeID                 uint64            `gorm:"column:id"`
	Endpoint               string            `gorm:"column:endpoint"`
	HideTaxRate            bool              `gorm:"column:hide_tax_rate"`
	IsPublicGood           bool              `gorm:"column:is_public_good"`
	Stream                 json.RawMessage   `gorm:"column:stream"`
	Config                 json.RawMessage   `gorm:"column:config;type:jsonb"`
	Status                 schema.NodeStatus `gorm:"column:status"`
	LastHeartbeatTimestamp time.Time         `gorm:"column:last_heartbeat_timestamp"`
	Location               json.RawMessage   `gorm:"column:location;type:jsonb"`
	Avatar                 json.RawMessage   `gorm:"column:avatar;type:jsonb"`
	APY                    decimal.Decimal   `gorm:"column:apy"`
	Version                string            `gorm:"column:version"`
	Type                   string            `gorm:"column:type"`
	AccessToken            string            `gorm:"column:access_token"`
	CreatedAt              time.Time         `gorm:"column:created_at"`
	UpdatedAt              time.Time         `gorm:"column:updated_at"`
}

type NodeAPYSnapshot struct {
	ID          uint64          `gorm:"column:id"`
	Date        time.Time       `gorm:"column:date"`
	EpochID     uint64          `gorm:"column:epoch_id"`
	NodeAddress common.Address  `gorm:"column:node_address"`
	APY         decimal.Decimal `gorm:"column:apy"`
	CreatedAt   time.Time       `gorm:"column:created_at"`
	UpdatedAt   time.Time       `gorm:"column:updated_at"`
}

type NodeAPYSnapshots []NodeAPYSnapshot

type NodeEvent struct {
	TransactionHash  string               `gorm:"column:transaction_hash"`
	TransactionIndex uint                 `gorm:"column:transaction_index"`
	NodeID           uint64               `gorm:"column:node_id"`
	AddressFrom      common.Address       `gorm:"column:address_from"`
	AddressTo        common.Address       `gorm:"column:address_to"`
	Type             schema.NodeEventType `gorm:"column:type"`
	LogIndex         uint                 `gorm:"column:log_index"`
	ChainID          uint64               `gorm:"column:chain_id"`
	BlockHash        string               `gorm:"column:block_hash"`
	BlockNumber      uint64               `gorm:"column:block_number"`
	BlockTimestamp   time.Time            `gorm:"column:block_timestamp"`
	Metadata         json.RawMessage      `gorm:"column:metadata"`
	Finalized        bool                 `gorm:"column:finalized"`
}

type NodeEvents []*NodeEvent

type NodeInvalidResponse struct {
	ID               uint64                         `gorm:"id;primaryKey"`
	EpochID          uint64                         `gorm:"column:epoch_id"`
	Type             schema.NodeInvalidResponseType `gorm:"column:type"`
	Request          string                         `gorm:"column:request"`
	VerifierNodes    pq.ByteaArray                  `gorm:"column:verifier_nodes;type:bytea[]"`
	VerifierResponse json.RawMessage                `gorm:"column:verifier_response;type:jsonb"`
	Node             common.Address                 `gorm:"column:node"`
	Response         json.RawMessage                `gorm:"column:response;type:jsonb"`
	CreatedAt        time.Time                      `gorm:"column:created_at"`
	UpdatedAt        time.Time                      `gorm:"column:updated_at"`
}

type NodeInvalidResponses []NodeInvalidResponse

type NodeRewardRecord struct {
	EpochID          uint64          `gorm:"column:epoch_id;"`
	Index            int             `gorm:"column:index;primaryKey"`
	TransactionHash  string          `gorm:"column:transaction_hash;primaryKey"`
	NodeAddress      string          `gorm:"column:node_address"`
	OperationRewards decimal.Decimal `gorm:"column:operation_rewards"`
	StakingRewards   decimal.Decimal `gorm:"column:staking_rewards"`
	TaxCollected     decimal.Decimal `gorm:"column:tax_collected"`
	RequestCount     decimal.Decimal `gorm:"column:request_count"`
}

type NodeSnapshot struct {
	Date  time.Time `gorm:"column:date"`
	Count uint64    `gorm:"column:count"`
}

type Nodes []Node

type OperatorProfitSnapshot struct {
	ID            uint64          `gorm:"column:id"`
	Date          time.Time       `gorm:"column:date"`
	EpochID       uint64          `gorm:"column:epoch_id"`
	Operator      common.Address  `gorm:"column:operator"`
	OperationPool decimal.Decimal `gorm:"column:operation_pool"`
	CreatedAt     time.Time       `gorm:"column:created_at"`
	UpdatedAt     time.Time       `gorm:"column:updated_at"`
}

type OperatorProfitSnapshots []OperatorProfitSnapshot

type StakeChip struct {
	ID             decimal.Decimal `gorm:"column:id"`
	Owner          string          `gorm:"column:owner"`
	Node           string          `gorm:"column:node"`
	Value          decimal.Decimal `gorm:"column:value"`
	Metadata       json.RawMessage `gorm:"column:metadata"`
	BlockNumber    decimal.Decimal `gorm:"column:block_number"`
	BlockTimestamp time.Time       `gorm:"column:block_timestamp"`
	Finalized      bool            `gorm:"column:finalized"`
}

type StakeEvent struct {
	ID                string          `gorm:"column:id"`
	Type              string          `gorm:"column:type"`
	TransactionHash   string          `gorm:"column:transaction_hash;primaryKey"`
	TransactionIndex  uint            `gorm:"column:transaction_index"`
	TransactionStatus uint64          `gorm:"column:transaction_status"`
	LogIndex          uint            `gorm:"column:log_index"`
	Metadata          json.RawMessage `gorm:"column:metadata"`
	BlockHash         string          `gorm:"column:block_hash;primaryKey"`
	BlockNumber       uint64          `gorm:"column:block_number"`
	BlockTimestamp    time.Time       `gorm:"column:block_timestamp"`
	Finalized         bool            `gorm:"column:finalized"`
}

type StakeStaking struct {
	Staker string          `gorm:"column:staker"`
	Node   string          `gorm:"column:node"`
	Count  uint32          `gorm:"column:count"`
	Value  decimal.Decimal `gorm:"column:value"`
}

type StakeTransaction struct {
	ID               string          `gorm:"column:id;primaryKey"`
	Type             string          `gorm:"column:type;primaryKey"`
	User             string          `gorm:"column:user"`
	Node             string          `gorm:"column:node"`
	Value            decimal.Decimal `gorm:"column:value"`
	ChipIDs          pq.Int64Array   `gorm:"column:chips;type:bigint[]"`
	BlockTimestamp   time.Time       `gorm:"column:block_timestamp"`
	BlockNumber      uint64          `gorm:"column:block_number"`
	TransactionIndex uint            `gorm:"column:transaction_index"`
	Finalized        bool            `gorm:"column:finalized"`
}

type StakerCountSnapshot struct {
	Date  time.Time `gorm:"column:date"`
	Count uint64    `gorm:"column:count"`
}

type StakerProfitSnapshot struct {
	ID              uint64          `gorm:"column:id"`
	Date            time.Time       `gorm:"column:date"`
	EpochID         uint64          `gorm:"column:epoch_id"`
	OwnerAddress    common.Address  `gorm:"column:owner_address"`
	TotalChipAmount decimal.Decimal `gorm:"column:total_chip_amounts"` // Fixme: total_chip_amounts-> total_chip_amount
	TotalChipValue  decimal.Decimal `gorm:"column:total_chip_values"`  // Fixme: total_chip_values-> total_chip_value
	CreatedAt       time.Time       `gorm:"column:created_at"`
	UpdatedAt       time.Time       `gorm:"column:updated_at"`
}

type StakerProfitSnapshots []StakerProfitSnapshot

type Stat struct {
	Address              common.Address `gorm:"column:address;primaryKey"`
	Endpoint             string         `gorm:"column:endpoint"`
	AccessToken          string         `gorm:"column:access_token"`
	Points               float64        `gorm:"column:points"`
	IsPublicGood         bool           `gorm:"column:is_public_good"`
	IsFullNode           bool           `gorm:"column:is_full_node"`
	IsRssNode            bool           `gorm:"column:is_rss_node"`
	Staking              float64        `gorm:"column:staking"`
	Epoch                int64          `gorm:"column:epoch"`
	TotalRequest         int64          `gorm:"column:total_request_count"`
	EpochRequest         int64          `gorm:"column:epoch_request_count"`
	EpochInvalidRequest  int64          `gorm:"column:epoch_invalid_request_count"`
	DecentralizedNetwork int            `gorm:"column:decentralized_network_count"`
	FederatedNetwork     int            `gorm:"column:federated_network_count"`
	Indexer              int            `gorm:"column:indexer_count"`
	ResetAt              time.Time      `gorm:"column:reset_at"`
	CreatedAt            time.Time      `gorm:"column:created_at"`
	UpdatedAt            time.Time      `gorm:"column:updated_at"`
}

type Stats []Stat

type Worker struct {
	EpochID  uint64         `gorm:"column:epoch_id;primaryKey"`
	Address  common.Address `gorm:"column:address;primaryKey"`
	Network  string         `gorm:"column:network;primaryKey"`
	Name     string         `gorm:"column:name;primaryKey"`
	IsActive bool           `gorm:"column:is_active"`
}

type Workers []Worker