bch

type Address struct {
	ID                int64  `xorm:"id bigint autoincr pk"`
	Address           string `xorm:"address varchar(255) notnull unique"`
	BirthTimestamp    int64  `xorm:"birth_timestamp int notnull default '0' index"`
	LatestTxTimestamp int64  `xorm:"latest_tx_timestamp int notnull default '0' index"`
	Value             int64  `xorm:"value bigint notnull default '0' index"`
}

type Block struct {
	ID              int64   `xorm:"id bigint autoincr pk"`
	Height          int64   `xorm:"height int notnull unique"`
	Size            int64   `xorm:"size int notnull"`
	Timestamp       int64   `xorm:"timestamp int notnull index"`
	Version         int64   `xorm:"version int notnull"`
	MerkleRoot      string  `xorm:"merkle_root char(64) notnull"`
	Bits            string  `xorm:"bits char(8) notnull"`
	Nonce           int64   `xorm:"nonce bigint notnull"`
	Hash            string  `xorm:"hash char(64) notnull index"`
	MedianTimestamp int64   `xorm:"median_timestamp int notnull"`
	Difficulty      float64 `xorm:"difficulty double notnull"`
	PreviousHash    string  `xorm:"prev_hash char(64) notnull"`
	ChainWork       string  `xorm:"chain_work char(64) notnull"`
	TxCount         int64   `xorm:"tx_count int notnull"`
	PoolName        string  `xorm:"pool_name varchar(100) notnull default ''"`
}

type Meta struct {
	ID          int64     `xorm:"id bigint autoincr pk"`
	Name        string    `xorm:"name varchar(255) notnull unique"`
	LastID      int64     `xorm:"last_id bigint notnull"`
	Count       int64     `xorm:"count bigint notnull"`
	CreatedTime time.Time `xorm:"created_time created notnull"`
	UpdatedTime time.Time `xorm:"updated_time updated notnull"`
}

type Mining struct {
	ID            int64  `xorm:"id bigint autoincr pk"`
	Address       string `xorm:"address varchar(255) notnull unique"`
	CoinbaseTimes int64  `xorm:"coinbase_times int notnull default '0'"`
	PoolName      string `xorm:"pool_name varchar(256)"`
}

type Node struct {
	ID                int64  `xorm:"id bigint autoincr pk"`
	IP                string `xorm:"ip varchar(40) notnull unique(address)"`
	Port              string `xorm:"port varchar(5) notnull unique(address)"`
	IPVersion         int    `xorm:"ip_version tinyint notnull"`
	UserAgent         string `xorm:"user_agent varchar(256) notnull"`
	ProtocolVersion   int64  `xorm:"protocol_version bigint notnull"`
	Services          string `xorm:"services varchar(256) notnull"`
	LastSeenTimestamp int64  `xorm:"last_seen_timestamp bigint notnull"`
	LastBlockHeight   int64  `xorm:"last_block_height bigint notnull"`
	CountryName       string `xorm:"country_name varchar(256) notnull"`
	RegionName        string `xorm:"region_name varchar(256) notnull"`
	CityName          string `xorm:"city_name varchar(256) notnull"`
	Owner             string `xorm:"owner varchar(256) notnull"`
	ISP               string `xorm:"isp varchar(256) notnull"`
	Latitude          string `xorm:"latitude varchar(256) notnull"`
	Longitude         string `xorm:"longitude varchar(256) notnull"`
	Timezone          string `xorm:"timezone varchar(256) notnull"`
	UTCOffset         string `xorm:"utc_offset varchar(256) notnull"`
	IDDCode           string `xorm:"idd_code varchar(256) notnull"`
	CountryCode       string `xorm:"country_code varchar(256) notnull"`
	ContinentCode     string `xorm:"continent_code varchar(256) notnull"`
}

type StatisticsDayBlock struct {
	ID               int64   `xorm:"id bigint autoincr pk"`
	Timestamp        int64   `xorm:"timestamp int notnull unique"`
	BlockSizeSum     int64   `xorm:"block_size_sum bigint notnull default '0'"`
	BlockSizeNew     int64   `xorm:"block_size_new bigint notnull default '0'"`
	BlockSizeAvg     float64 `xorm:"block_size_avg double notnull default '0'"`
	BlockFeeAvg      float64 `xorm:"block_fee_avg double notnull default '0'"`
	BlockCoinbaseAvg float64 `xorm:"block_coinbase_avg double notnull default '0'"`
	BlockTimeSpent   float64 `xorm:"block_time_spent double notnull default '0'"`
	DifficultySum    float64 `xorm:"difficulty_sum double notnull default '0'"`
	Supply           int64   `xorm:"supply bigint notnull default '0'"`
	MinerCount       int64   `xorm:"miner_count bigint notnull default '0'"`
	TotalMinerCount  int64   `xorm:"total_miner_count bigint notnull default '0'"`
}

type StatisticsDayMinerPool struct {
	ID              int64   `xorm:"id bigint autoincr pk"`
	Name            string  `xorm:"name varchar(100) notnull unique(name_time)"`
	Timestamp       int64   `xorm:"timestamp bigint notnull unique(name_time)"`
	CalcForce       float64 `xorm:"calc_force double notnull default '0'"`
	BlockCount      int64   `xorm:"block_count bigint notnull default '0'"`
	EmptyBlockCount int64   `xorm:"empty_block_count bigint notnull default '0'"`
	SizeAvg         float64 `xorm:"size_avg double notnull default '0'"`
	FeeAvg          float64 `xorm:"fee_avg double notnull default '0'"`
	VOutValueAvg    float64 `xorm:"vout_value_avg double notnull default '0'"`
}

type StatisticsDayOHLC struct {
	ID        int64   `xorm:"id bigint autoincr pk"`
	Timestamp int64   `xorm:"timestamp int notnull unique"`
	Open      float64 `xorm:"open decimal(38,4) notnull"`
	High      float64 `xorm:"high decimal(38,4) notnull"`
	Low       float64 `xorm:"low decimal(38,4) notnull"`
	Close     float64 `xorm:"close decimal(38,4) notnull"`
}

type StatisticsDayTransaction struct {
	ID                 int64   `xorm:"id bigint autoincr pk"`
	Timestamp          int64   `xorm:"timestamp int notnull unique"`
	ValueDayConsume    float64 `xorm:"value_day_consume double notnull default '0'"`
	TxRate             float64 `xorm:"tx_rate double notnull default '0'"`
	TxCount            int64   `xorm:"tx_count bigint notnull default '0'"`
	TxVInAvg           float64 `xorm:"tx_vin_avg double notnull default '0'"`
	TxVOutAvg          float64 `xorm:"tx_vout_avg double notnull default '0'"`
	TxSizeAvg          float64 `xorm:"tx_size_avg double notnull default '0'"`
	TxValueSum         float64 `xorm:"tx_value_sum double notnull default '0'"`
	TxValueAvg         float64 `xorm:"tx_value_avg double notnull default '0'"`
	TxFeeAvg           float64 `xorm:"tx_fee_avg double notnull default '0'"`
	TxSizeFeeAvg       float64 `xorm:"tx_size_fee_avg double notnull default '0'"`
	AddressCountSum    int64   `xorm:"address_count_sum bigint notnull default '0'"`
	AddressCountNew    int64   `xorm:"address_count_new bigint notnull default '0'"`
	AddressVInVOutAvg  float64 `xorm:"address_vin_vout_avg double notnull default '0'"`
	AddressTxValueAvg  float64 `xorm:"address_tx_value_avg double notnull default '0'"`
	ActivePercent      float64 `xorm:"active_percent double notnull default '0'"`
	StoreRate          float64 `xorm:"store_rate double notnull default '0'"`
	RatioOfMarketValue float64 `xorm:"ratio_of_market_value double notnull default '0'"`
	ActiveAddressCount int64   `xorm:"active_address_count bigint notnull default '0'"`
	UTXOLevel1         int64   `xorm:"utxo_level1 bigint notnull default '0'"`
	UTXOLevel2         int64   `xorm:"utxo_level2 bigint notnull default '0'"`
	UTXOLevel3         int64   `xorm:"utxo_level3 bigint notnull default '0'"`
	UTXOLevel4         int64   `xorm:"utxo_level4 bigint notnull default '0'"`
}

type StatisticsMonth struct {
	ID                 int64 `xorm:"id bigint autoincr pk"`
	Timestamp          int64 `xorm:"timestamp int notnull unique"`
	ActiveAddressCount int64 `xorm:"active_address_count int notnull default '0'"`
}

type Transaction struct {
	ID          int64  `xorm:"id bigint autoincr pk"`
	TxID        string `xorm:"tx_id char(64) notnull unique(tx_id_block_height)"`
	BlockHeight int64  `xorm:"block_height int notnull unique(tx_id_block_height)"`
	Timestamp   int64  `xorm:"timestamp int notnull"`
	Version     int64  `xorm:"version int notnull"`
	Size        int64  `xorm:"size int notnull"`
	LockTime    int64  `xorm:"lock_time bigint notnull"`
	Hash        string `xorm:"hash char(64) notnull"`
	Number      int64  `xorm:"number int notnull"`
	VInCount    int    `xorm:"vin_count smallint notnull"`
	VInValue    int64  `xorm:"vin_value bigint notnull"`
	VOutCount   int    `xorm:"vout_count smallint notnull"`
	VOutValue   uint64 `xorm:"vout_value bigint notnull"`
	Fee         int64  `xorm:"fee bigint notnull"`
}

type VIn struct {
	ID               int64  `xorm:"id bigint autoincr pk"`
	BlockHeight      int64  `xorm:"block_height int notnull"`
	TxID             string `xorm:"tx_id char(64) notnull"`
	TxIDOrigin       string `xorm:"tx_id_origin char(64) notnull"`
	Timestamp        int64  `xorm:"timestamp int notnull"`
	Coinbase         string `xorm:"coinbase varchar(200) notnull"`
	Sequence         int64  `xorm:"sequence bigint notnull"`
	Number           int64  `xorm:"number int notnull"`
	VOutNumberOrigin int64  `xorm:"vout_num_origin smallint notnull"`
	AddressOrigin    string `xorm:"address_origin varchar(256) notnull"`
	ValueOrigin      int64  `xorm:"value_origin bigint notnull"`
	ScriptSignature  string `xorm:"script_sig text notnull"`
}

type VOut struct {
	ID                 int64  `xorm:"id bigint autoincr pk"`
	TxID               string `xorm:"tx_id char(64) notnull"`
	BlockHeight        int64  `xorm:"block_height int notnull"`
	Value              uint64 `xorm:"value bigint notnull"`
	Address            string `xorm:"address varchar(256) notnull"`
	Timestamp          int64  `xorm:"timestamp int notnull"`
	ScriptPublicKey    string `xorm:"script_pubkey text notnull"`
	Type               string `xorm:"type varchar(256) notnull"`
	RequiredSignatures int64  `xorm:"required_signatures smallint notnull"`
	Number             int64  `xorm:"number smallint notnull"`
	IsUsed             int64  `xorm:"is_used tinyint notnull"`
	IsCoinbase         int64  `xorm:"is_coinbase tinyint notnull"`
}