mysql

type Base struct {
	CreatedAt time.Time `gorm:"NOT NULL;DEFAULT:current_timestamp"`
	UpdatedAt time.Time `gorm:"NOT NULL;DEFAULT:current_timestamp"`
}

type BaseAutoincrement struct {
	Base
	ID uint64 `gorm:"PRIMARY_KEY;AUTO_INCREMENT:true"`
}

type Block struct {
	Base

	Block             uint64    `gorm:"PRIMARY_KEY;AUTO_INCREMENT:false"`
	PrevDigest        []byte    `gorm:"size:32;NOT NULL" sql:"type:binary(32);"`
	MerkleRoot        []byte    `gorm:"size:32;NOT NULL" sql:"type:binary(32);"`
	TransactionsCount uint16    `gorm:"NOT NULL"`
	SignersCount      uint16    `gorm:"NOT NULL"`
	Orchestrator      []byte    `gorm:"size:32;NOT NULL" sql:"type:binary(32);"`
	TotalMNT          string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	TotalGOLD         string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	FeeMNT            string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	FeeGOLD           string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	TotalUserData     uint64    `gorm:"NOT NULL"`
	Timestamp         time.Time `gorm:"NOT NULL;DEFAULT:current_timestamp"`
}

type DailyStats struct {
	Base
	Timestamp    time.Time `gorm:"NOT NULL;DEFAULT:current_timestamp;PRIMARY_KEY;AUTO_INCREMENT:false"`
	Transactions uint64    `gorm:"NOT NULL"`
	FeeMNT       string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	FeeGOLD      string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	VolumeMNT    string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	VolumeGOLD   string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	TotalStake   string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	PriceMNTPUSD float64   `gorm:"NOT NULL"`
	PriceGOLDUSD float64   `gorm:"NOT NULL"`
	PriceMNTPBTC float64   `gorm:"NOT NULL"`
	PriceGOLDBTC float64   `gorm:"NOT NULL"`
}

type Database struct {
	*gorm.DB
}

type EthereumRewardTx struct {
	BaseAutoincrement

	RewardID   uint64 `gorm:"NOT NULL"` // FK
	Address    string `gorm:"size:64;NOT NULL"`
	Hash       string `gorm:"size:128;NOT NULL"`
	MntAmount  string `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	GoldAmount string `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	TxStatus   uint8  `gorm:"NOT NULL"`
	Message    string `gorm:"size:128;NOT NULL"`
}

type Node struct {
	Base

	Index          uint32    `gorm:"NOT NULL"`
	Address        []byte    `gorm:"size:32;PRIMARY_KEY;AUTO_INCREMENT:false" sql:"type:binary(32);"`
	Name           string    `gorm:"size:128;NOT NULL"`
	IP             string    `gorm:"size:32;NOT NULL"`
	MajorVersion   uint16    `gorm:"NOT NULL"`
	MinorVersion   uint16    `gorm:"NOT NULL"`
	OldVersion     bool      `gorm:"NOT NULL"`
	GenesisDigest  []byte    `gorm:"size:32;" sql:"type:binary(32);"`
	Blocks         uint64    `gorm:"NOT NULL"`
	BlocksDesync   bool      `gorm:"NOT NULL"`
	VotingPool     uint64    `gorm:"NOT NULL"`
	PendingPool    uint64    `gorm:"NOT NULL"`
	ValidSignature bool      `gorm:"NOT NULL"`
	BalanceGOLD    string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	BalanceMNT     string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	GainedGOLD     string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	GainedMNT      string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	RewardHistory  string    `gorm:"size:2048;NOT NULL"`
	Activity       float64   `gorm:"NOT NULL"`
	Quit           bool      `gorm:"NOT NULL"`
	QuitAt         time.Time `gorm:"NOT NULL;DEFAULT:current_timestamp"`
}

type NodeReward struct {
	BaseAutoincrement

	BlockFrom       uint64 `gorm:"NOT NULL"`
	BlockTo         uint64 `gorm:"NOT NULL"`
	Transactions    uint64 `gorm:"NOT NULL"`
	TransferredGOLD string `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	TransferredMNT  string `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	RewardGOLD      string `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	RewardMNT       string `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
}

type NodeRewardHistoryInternal struct {
	Time       uint64  `json:"t,omitempty"`
	GainedGOLD float64 `json:"g,omitempty"`
	GainedMNT  float64 `json:"m,omitempty"`
}

type NodeRewardTx struct {
	Base

	RewardID       uint64 `gorm:"NOT NULL"` // FK
	NodeAddress    []byte `gorm:"size:32;NOT NULL" sql:"type:binary(32);"`
	NodeName       string `gorm:"size:128;NOT NULL"`
	NodeBalanceMNT string `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	TxNonce        uint64 `gorm:"NOT NULL"`
	TxDigest       []byte `gorm:"size:32;NOT NULL" sql:"type:binary(32);"`
	TxToken        uint16 `gorm:"NOT NULL"`
	TxAmount       string `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	TxStatus       uint8  `gorm:"NOT NULL"`
}

type Transaction struct {
	Base

	Digest     []byte    `gorm:"size:32;PRIMARY_KEY;AUTO_INCREMENT:false" sql:"type:binary(32);"`
	Block      *uint64   `gorm:""`
	Type       uint16    `gorm:"NOT NULL"`
	Nonce      uint64    `gorm:"NOT NULL"`
	From       []byte    `gorm:"size:32;NOT NULL" sql:"type:binary(32);"`
	To         []byte    `gorm:"size:32" sql:"type:binary(32);"`
	AmountMNT  string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	AmountGOLD string    `gorm:"NOT NULL" sql:"type:decimal(38,18);"`
	Status     uint8     `gorm:"NOT NULL"`
	DataSize   uint64    `gorm:"NOT NULL"`
	DataPiece  []byte    `gorm:"size:128"`
	Timestamp  time.Time `gorm:"NOT NULL;DEFAULT:current_timestamp"`
}

type TransactionData struct {
	Base

	Digest []byte `gorm:"size:32;PRIMARY_KEY;AUTO_INCREMENT:false" sql:"type:binary(32);"`
	Data   []byte `gorm:"size:4096"`
	Status uint8  `gorm:"NOT NULL"`
}