types

type AccountBalanceRow struct {
	Address string   `db:"address"`
	Coins   *DbCoins `db:"coins"`
	Height  int64    `db:"height"`
}

type AccountRow struct {
	Address string `db:"address"`
}

type BlockRow struct {
	Height          int64     `db:"height"`
	Hash            string    `db:"hash"`
	TxNum           int64     `db:"num_txs"`
	TotalGas        int64     `db:"total_gas"`
	ProposerAddress string    `db:"proposer_address"`
	PreCommitsNum   int64     `db:"pre_commits"`
	Timestamp       time.Time `db:"timestamp"`
}

type BlockTimeRow struct {
	AverageTime float64 `db:"average_time"`
	Height      int64   `db:"height"`
}

type CommunityPoolRow struct {
	Coins  *DbDecCoins `db:"coins"`
	Height int64       `db:"height"`
}

type ConsensusRow struct {
	Height int64  `db:"height"`
	Round  int32  `db:"round"`
	Step   string `db:"step"`
}

type DbCoin struct {
	Denom  string
	Amount string
}

type DbCoins []*DbCoin

type DbDecCoin struct {
	Denom  string
	Amount string
}

type DbDecCoins []*DbDecCoin

type DelegationRow struct {
	ID               string  `db:"id"`
	ValidatorAddress string  `db:"validator_address"`
	DelegatorAddress string  `db:"delegator_address"`
	Amount           DbCoin  `db:"amount"`
	Shares           float64 `db:"shares"`
	Height           int64   `db:"height"`
}

type DepositRow struct {
	ProposalID int64   `db:"proposal_id"`
	Depositor  string  `db:"depositor_address"`
	Amount     DbCoins `db:"amount"`
	Height     int64   `db:"height"`
}

type DoubleSignEvidenceRow struct {
	Height  int64 `db:"height"`
	VoteAID int64 `db:"vote_a_id"`
	VoteBID int64 `db:"vote_b_id"`
}

type DoubleSignVoteRow struct {
	ID               int64  `db:"id"`
	VoteType         int    `db:"type"`
	Height           int64  `db:"height"`
	Round            int    `db:"round"`
	BlockID          string `db:"block_id"`
	ValidatorAddress string `db:"validator_address"`
	ValidatorIndex   int    `db:"validator_index"`
	Signature        string `db:"signature"`
}

type GenesisRow struct {
	ChainID string    `db:"chain_id"`
	Time    time.Time `db:"time"`
}

type InflationRow struct {
	Value  float64 `db:"value"`
	Height int64   `db:"height"`
}

type ModuleRow struct {
	Module string `db:"module_name"`
}

type ModuleRows []*ModuleRow

type ProposalRow struct {
	Title           string    `db:"title"`
	Description     string    `db:"description"`
	ProposalRoute   string    `db:"proposal_route"`
	ProposalType    string    `db:"proposal_type"`
	ProposalID      uint64    `db:"proposal_id"`
	SubmitTime      time.Time `db:"submit_time"`
	DepositEndTime  time.Time `db:"deposit_end_time"`
	VotingStartTime time.Time `db:"voting_start_time"`
	VotingEndTime   time.Time `db:"voting_end_time" `
	Proposer        string    `db:"proposer_address"`
	Status          string    `db:"status"`
}

type ReDelegationRow struct {
	DelegatorAddress    string    `db:"delegator_address"`
	SrcValidatorAddress string    `db:"src_validator_address"`
	DstValidatorAddress string    `db:"dst_validator_address"`
	Amount              DbCoin    `db:"amount"`
	CompletionTime      time.Time `db:"completion_time"`
	Height              int64     `db:"height"`
}

type StakingParamsRow struct {
	BondName string `db:"bond_denom"`
}

type StakingPoolRow struct {
	BondedTokens    int64 `db:"bonded_tokens"`
	NotBondedTokens int64 `db:"not_bonded_tokens"`
	Height          int64 `db:"height"`
}

type TallyResultRow struct {
	ProposalID int64 `db:"proposal_id"`
	Yes        int64 `db:"yes"`
	Abstain    int64 `db:"abstain"`
	No         int64 `db:"no"`
	NoWithVeto int64 `db:"no_with_veto"`
	Height     int64 `db:"height"`
}

type TokenPriceRow struct {
	Denom     string    `db:"denom"`
	Price     float64   `db:"price"`
	MarketCap int64     `db:"market_cap"`
	Timestamp time.Time `db:"timestamp"`
}

type TotalSupplyRow struct {
	Coins  *DbCoins `db:"coins"`
	Height int64    `db:"height"`
}

type UnbondingDelegationRow struct {
	ConsensusAddress    string    `db:"validator_address"`
	DelegatorAddress    string    `db:"delegator_address"`
	Amount              DbCoin    `db:"amount"`
	CompletionTimestamp time.Time `db:"completion_timestamp"`
	Height              int64     `db:"height"`
}

type ValidatorCommissionHistoryRow struct {
	CommissionID int64     `db:"commission_id"`
	Height       int64     `db:"height"`
	Timestamp    time.Time `db:"timestamp"`
}

type ValidatorCommissionRow struct {
	OperatorAddress   string         `db:"validator_address"`
	Commission        sql.NullString `db:"commission"`
	MinSelfDelegation sql.NullString `db:"min_self_delegation"`
	Height            int64          `db:"height"`
}

type ValidatorData struct {
	ConsAddress         string `db:"consensus_address"`
	ValAddress          string `db:"operator_address"`
	ConsPubKey          string `db:"consensus_pubkey"`
	SelfDelegateAddress string `db:"self_delegate_address"`
	MaxRate             string `db:"max_rate"`
	MaxChangeRate       string `db:"max_change_rate"`
}

type ValidatorDescriptionHistoryRow struct {
	ValAddress      string         `db:"operator_address"`
	Moniker         sql.NullString `db:"moniker"`
	Identity        sql.NullString `db:"identity"`
	Website         sql.NullString `db:"website"`
	SecurityContact sql.NullString `db:"security_contact"`
	Details         sql.NullString `db:"details"`
	Height          int64          `db:"height"`
	Timestamp       time.Time      `db:"timestamp"`
}

type ValidatorDescriptionRow struct {
	ValAddress      string         `db:"validator_address"`
	Moniker         sql.NullString `db:"moniker"`
	Identity        sql.NullString `db:"identity"`
	Website         sql.NullString `db:"website"`
	SecurityContact sql.NullString `db:"security_contact"`
	Details         sql.NullString `db:"details"`
	Height          int64          `db:"height"`
}

type ValidatorInfoRow struct {
	ConsAddress         string `db:"consensus_address"`
	ValAddress          string `db:"operator_address"`
	SelfDelegateAddress string `db:"self_delegate_address"`
	MaxChangeRate       string `db:"max_change_rate"`
	MaxRate             string `db:"max_rate"`
}

type ValidatorRow struct {
	ConsAddress string `db:"consensus_address"`
	ConsPubKey  string `db:"consensus_pubkey"`
}

type ValidatorSigningInfoRow struct {
	ValidatorAddress    string    `db:"validator_address"`
	StartHeight         int64     `db:"start_height"`
	IndexOffset         int64     `db:"index_offset"`
	JailedUntil         time.Time `db:"jailed_until"`
	Tombstoned          bool      `db:"tombstoned"`
	MissedBlocksCounter int64     `db:"missed_blocks_counter"`
	Height              int64     `db:"height"`
}

type ValidatorStatusRow struct {
	Status      int    `db:"status"`
	Jailed      bool   `db:"jailed"`
	ConsAddress string `db:"validator_address"`
	Height      int64  `db:"height"`
}

type ValidatorUptimeHistoryRow struct {
	UptimeID  int64     `db:"uptime_id"`
	Height    int64     `db:"height"`
	Timestamp time.Time `db:"timestamp"`
}

type ValidatorUptimeRow struct {
	ID                 int64  `db:"id"`
	ConsAddr           string `db:"validator_address"`
	SignedBlockWindow  int64  `db:"signed_blocks_window"`
	MissedBlockCounter int64  `db:"missed_blocks_counter"`
}

type ValidatorVotingPowerHistoryRow struct {
	ValidatorAddress string    `db:"validator_address"`
	VotingPower      int64     `db:"voting_power"`
	Height           int64     `db:"height"`
	Timestamp        time.Time `db:"timestamp"`
}

type ValidatorVotingPowerRow struct {
	ValidatorAddress string `db:"validator_address"`
	VotingPower      int64  `db:"voting_power"`
	Height           int64  `db:"height"`
}

type VoteRow struct {
	ProposalID int64  `db:"proposal_id"`
	Voter      string `db:"voter_address"`
	Option     string `db:"option"`
	Height     int64  `db:"height"`
}