tables

type BlockInfo struct {
	Id          uint64    `gorm:"column:id;primary_key;AUTO_INCREMENT;NOT NULL"`
	Height      uint32    `gorm:"column:height;type:int unsigned;index:idx_height;default:0;NOT NULL"`
	SequenceNum int64     `gorm:"column:sequence_num;type:bigint;index:idx_sequence_num;default:0;NOT NULL"`
	Header      []byte    `gorm:"column:header;type:blob;NOT NULL;comment:header"`
	Timestamp   int64     `gorm:"column:timestamp;type:bigint;default:0;NOT NULL;comment:timestamp"`
	CreatedAt   time.Time `gorm:"column:created_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
	UpdatedAt   time.Time `gorm:"column:updated_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
}

type BlockParserInfo struct {
	Id        uint64    `json:"id" gorm:"column:id;primaryKey;type:bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ''"`
	Height    uint32    `` /* 132-byte string literal not displayed */
	BlockHash string    `` /* 140-byte string literal not displayed */
	CreatedAt time.Time `json:"created_at" gorm:"column:created_at;type:timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ''"`
	UpdatedAt time.Time `` /* 131-byte string literal not displayed */
}

type CInsDescription struct {
	Type     string `gorm:"column:type;type:varchar(255);default:'';NOT NULL" json:"type"` // blockchain/ordinals
	Chain    string `gorm:"column:chain;type:varchar(255);index:idx_chain;default:'';NOT NULL" json:"chain"`
	Contract string `gorm:"column:contract;type:varchar(255);index:idx_contract;default:'';NOT NULL" json:"contract"`
}

type InscribeOrder struct {
	Id             uint64 `gorm:"column:id;primary_key;AUTO_INCREMENT;NOT NULL"`
	OrderId        string `gorm:"column:order_id;type:varchar(255);index:idx_order_id;default:'';NOT NULL"`
	InscriptionId  `gorm:"embedded"`
	RevealAddress  string      `gorm:"column:reveal_address;type:varchar(255);index:idx_reveal_address;default:;NOT NULL"`
	RevealPriKey   string      `gorm:"column:reveal_pri_key;type:varchar(255);default:;NOT NULL"`
	RevealTxId     string      `gorm:"column:reveal_tx_id;type:varchar(255);index:idx_reveal_tx_id;default:;NOT NULL"`
	RevealTxRaw    string      `gorm:"column:reveal_tx_raw;type:mediumtext;default:;NOT NULL"`
	RevealTxValue  int64       `gorm:"column:reveal_tx_value;type:bigint;default:0;NOT NULL"`
	ReceiveAddress string      `gorm:"column:receive_address;type:varchar(255);index:idx_receive_address;default:;NOT NULL"`
	CommitTxId     string      `gorm:"column:commit_tx_id;type:varchar(255);index:idx_commit_tx_id;default:;NOT NULL"`
	Status         OrderStatus `gorm:"column:status;type:int;default:0;NOT NULL"`
	CreatedAt      time.Time   `gorm:"column:created_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
	UpdatedAt      time.Time   `gorm:"column:updated_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
}

type InscriptionId struct {
	TxId   string `gorm:"column:tx_id;type:varchar(255);index:idx_tx_id;default:'';NOT NULL" json:"txid"` // tx id
	Offset uint32 `gorm:"column:offset;type:int unsigned;default:0;NOT NULL" json:"offset"`               // inscription offset of tx
}

type Inscriptions struct {
	Id              uint64 `gorm:"column:id;primary_key;AUTO_INCREMENT;NOT NULL"` // this is sequence_num
	InscriptionId   `gorm:"embedded"`
	Index           uint32          `gorm:"column:index;type:int unsigned;default:0;NOT NULL"` // outpoint index of tx
	SequenceNum     int64           `gorm:"column:sequence_num;type:bigint;index:idx_sequence_num;default:0;NOT NULL"`
	InscriptionNum  int64           `gorm:"column:inscription_num;type:bigint;index:idx_inscription_num;default:0;NOT NULL"`
	Owner           string          `gorm:"column:owner;type:varchar(255);index:idx_owner;default:'';NOT NULL"`
	Charms          uint16          `gorm:"column:charms;type:tinyint unsigned;default:0;NOT NULL"`
	Fee             uint64          `gorm:"column:fee;type:bigint unsigned;default:0;NOT NULL"`
	Height          uint32          `gorm:"column:height;type:int unsigned;default:0;NOT NULL"`
	Sat             uint64          `gorm:"column:sat;type:bigint unsigned;index:idx_sat;default:0;NOT NULL"`
	Timestamp       int64           `gorm:"column:timestamp;type:bigint unsigned;default:0;NOT NULL"`
	Body            []byte          `gorm:"column:body;type:mediumblob"`
	ContentEncoding string          `gorm:"column:content_encoding;type:varchar(255);default:'';NOT NULL"`
	ContentType     string          `gorm:"column:content_type;type:varchar(255);default:'';NOT NULL"`
	MediaType       string          `gorm:"column:media_type;type:varchar(255);index:idx_media_type;default:'';NOT NULL"`
	ContentSize     uint32          `gorm:"column:content_size;type:int unsigned;default:0;NOT NULL"`
	ContentProtocol string          `gorm:"column:content_protocol;type:varchar(255);default:'';NOT NULL"`
	CInsDescription CInsDescription `gorm:"embedded"`
	Metadata        []byte          `gorm:"column:metadata;type:mediumblob"`
	Pointer         int32           `gorm:"column:pointer;type:int;default:0;NOT NULL"`
	CreatedAt       time.Time       `gorm:"column:created_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
	UpdatedAt       time.Time       `gorm:"column:updated_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
}

type OrderStatus int

type Outpoint struct {
	TxId  string `gorm:"column:tx_id;type:varchar(255);index:idx_tx_id;default:'';NOT NULL" json:"txid"` // tx id
	Index uint32 `gorm:"column:index;type:int unsigned;default:0;NOT NULL"`                              // outpoint index of tx
}

type Protocol struct {
	Id            uint64 `gorm:"column:id;primary_key;AUTO_INCREMENT;NOT NULL"` // this is sequence_num
	InscriptionId `gorm:"embedded"`
	Index         uint32    `gorm:"column:index;type:int unsigned;default:0;NOT NULL"` // outpoint index of tx
	SequenceNum   int64     `gorm:"column:sequence_num;type:bigint;index:idx_sequence_num;default:0;NOT NULL"`
	Protocol      string    `gorm:"column:protocol;type:varchar(255);index:idx_protocol;default:;NOT NULL"`
	Ticker        string    `gorm:"column:ticker;type:varchar(255);index:idx_ticker;default:;NOT NULL"`
	Operator      string    `gorm:"column:operator;type:varchar(255);index:idx_operator;default:;NOT NULL"`
	Owner         string    `gorm:"column:owner;type:varchar(255);index:idx_owner;default:;NOT NULL"`
	Max           uint64    `gorm:"column:max;type:bigint unsigned;default:0;NOT NULL"`
	Limit         uint64    `gorm:"column:limit;type:bigint unsigned;default:0;NOT NULL"`
	Decimals      uint32    `gorm:"column:decimals;type:int unsigned;default:0;NOT NULL"`
	CreatedAt     time.Time `gorm:"column:created_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
	UpdatedAt     time.Time `gorm:"column:updated_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
}

type ProtocolAmount struct {
	TkID   string `gorm:"column:tkid" json:"ticker_id"`
	Ticker string `gorm:"column:ticker" json:"ticker"`
	Amount uint64 `gorm:"column:amount" json:"amount"`
}

type SatPointToSequenceNum struct {
	Id          uint64    `gorm:"column:id;primary_key;AUTO_INCREMENT;NOT NULL"`
	Outpoint    string    `gorm:"column:outpoint;type:varchar(255);index:idx_outpoint;default:;NOT NULL"`
	Offset      uint64    `gorm:"column:offset;type:bigint unsigned;default:0;NOT NULL"`
	SequenceNum int64     `gorm:"column:sequence_num;type:bigint;index:idx_sequence_num;default:0;NOT NULL"`
	CreatedAt   time.Time `gorm:"column:created_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
	UpdatedAt   time.Time `gorm:"column:updated_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
}

type SavePoint struct {
	Id        uint64    `gorm:"column:id;primary_key;AUTO_INCREMENT;NOT NULL"`
	Height    uint32    `gorm:"column:height;type:int unsigned;index:idx_height;default:0;NOT NULL"`
	UndoLogId uint64    `gorm:"column:undo_log_id;type:bigint unsigned;index:idx_undo_log_id;default:0;NOT NULL"`
	CreatedAt time.Time `gorm:"column:created_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
	UpdatedAt time.Time `gorm:"column:updated_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
}

type UndoLog struct {
	Id        uint64    `gorm:"column:id;primary_key;AUTO_INCREMENT;NOT NULL"`
	Height    uint32    `gorm:"column:height;type:int(11) unsigned;index:idx_height;default:0;NOT NULL;comment:height of the block"`
	Sql       string    `gorm:"column:sql;type:longtext;default:;NOT NULL;comment:sql statement"`
	CreatedAt time.Time `gorm:"column:created_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
	UpdatedAt time.Time `gorm:"column:updated_at;type:timestamp;default:CURRENT_TIMESTAMP;NOT NULL"`
}