models

type Account struct {
	StakingKey    []byte `gorm:"uniqueIndex"`
	Pool          []byte `gorm:"index"`
	Drep          []byte `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64
	CertificateID uint `gorm:"index"`
	Active        bool `gorm:"default:true"`
}

type Asset struct {
	Name        []byte       `gorm:"index"`
	NameHex     []byte       `gorm:"index"`
	PolicyId    []byte       `gorm:"index"`
	Fingerprint []byte       `gorm:"index"`
	ID          uint         `gorm:"primaryKey"`
	UtxoID      uint         `gorm:"index"`
	Amount      types.Uint64 `gorm:"index"`
}

type AuthCommitteeHot struct {
	ColdCredential []byte `gorm:"index"`
	HostCredential []byte `gorm:"index"`
	ID             uint   `gorm:"primarykey"`
	CertificateID  uint   `gorm:"index"`
	AddedSlot      uint64
}

type Block struct {
	Hash     []byte `gorm:"index:hash_slot"`
	PrevHash []byte
	Cbor     []byte
	ID       uint64 `gorm:"primaryKey"`
	Slot     uint64 `gorm:"index:hash_slot"`
	Number   uint64
	Type     uint
}

type BlockNonce struct {
	Hash         []byte `gorm:"index:hash_slot"`
	Nonce        []byte
	ID           uint   `gorm:"primarykey"`
	Slot         uint64 `gorm:"index:hash_slot"`
	IsCheckpoint bool
}

type Certificate struct {
	BlockHash     []byte `gorm:"index"`
	ID            uint   `gorm:"primaryKey"`
	TransactionID uint   `gorm:"index;uniqueIndex:uniq_tx_cert;constraint:OnDelete:CASCADE"`
	CertificateID uint   `gorm:"index"` // Polymorphic FK to certificate table based on CertType. Not DB-enforced.
	Slot          uint64 `gorm:"index"`
	CertIndex     uint   `gorm:"column:cert_index;uniqueIndex:uniq_tx_cert"`
	CertType      uint   `gorm:"index"`
}

type Datum struct {
	Hash      []byte `gorm:"index;not null;unique"`
	RawDatum  []byte `gorm:"not null"`
	ID        uint   `gorm:"primarykey"`
	AddedSlot uint64 `gorm:"not null"`
}

type Deregistration struct {
	StakingKey    []byte `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	CertificateID uint   `gorm:"index"`
	AddedSlot     uint64
	Amount        types.Uint64
}

type DeregistrationDrep struct {
	DrepCredential []byte `gorm:"index"`
	CertificateID  uint   `gorm:"index"`
	ID             uint   `gorm:"primarykey"`
	AddedSlot      uint64
	DepositAmount  types.Uint64
}

type Drep struct {
	AnchorUrl     string
	Credential    []byte `gorm:"uniqueIndex"`
	AnchorHash    []byte
	CertificateID uint `gorm:"index"`
	ID            uint `gorm:"primarykey"`
	AddedSlot     uint64
	Active        bool `gorm:"default:true"`
}

type Epoch struct {
	Nonce []byte
	ID    uint `gorm:"primarykey"`
	// NOTE: we would normally use this as the primary key, but GORM doesn't
	// like a primary key value of 0
	EpochId       uint64 `gorm:"uniqueIndex"`
	StartSlot     uint64
	EraId         uint
	SlotLength    uint
	LengthInSlots uint
}

type KeyWitness struct {
	ID            uint   `gorm:"primaryKey"`
	TransactionID uint   `gorm:"index"`
	Type          uint8  `gorm:"index"` // See KeyWitnessType* constants
	Vkey          []byte // Vkey witness key
	Signature     []byte // Witness signature
	PublicKey     []byte // For Bootstrap witness
	ChainCode     []byte // For Bootstrap witness
	Attributes    []byte // For Bootstrap witness
}

type MoveInstantaneousRewards struct {
	Pot           uint `gorm:"index"`
	CertificateID uint `gorm:"index"`
	ID            uint `gorm:"primarykey"`
	AddedSlot     uint64
}

type MoveInstantaneousRewardsReward struct {
	Credential []byte
	Amount     types.Uint64
	ID         uint `gorm:"primarykey"`
	MIRID      uint `gorm:"index;constraint:OnDelete:CASCADE"`
}

type PParamUpdate struct {
	GenesisHash []byte
	Cbor        []byte
	ID          uint `gorm:"primarykey"`
	AddedSlot   uint64
	Epoch       uint64
}

type PParams struct {
	Cbor      []byte
	ID        uint `gorm:"primarykey"`
	AddedSlot uint64
	Epoch     uint64
	EraId     uint
}

type PlutusData struct {
	ID            uint `gorm:"primaryKey"`
	TransactionID uint `gorm:"index"`
	Data          []byte
	Transaction   *Transaction
}

type Pool struct {
	Margin        *types.Rat
	PoolKeyHash   []byte `gorm:"uniqueIndex"`
	VrfKeyHash    []byte
	RewardAccount []byte
	Owners        []PoolRegistrationOwner
	Relays        []PoolRegistrationRelay
	Registration  []PoolRegistration
	Retirement    []PoolRetirement
	ID            uint `gorm:"primarykey"`
	Pledge        types.Uint64
	Cost          types.Uint64
}

type PoolRegistration struct {
	Margin        *types.Rat
	MetadataUrl   string
	VrfKeyHash    []byte
	PoolKeyHash   []byte `gorm:"index"`
	RewardAccount []byte
	MetadataHash  []byte
	Owners        []PoolRegistrationOwner
	Relays        []PoolRegistrationRelay
	Pledge        types.Uint64
	Cost          types.Uint64
	CertificateID uint `gorm:"index"`
	ID            uint `gorm:"primarykey"`
	PoolID        uint `gorm:"index"`
	AddedSlot     uint64
	DepositAmount types.Uint64
}

type PoolRegistrationOwner struct {
	KeyHash            []byte
	ID                 uint `gorm:"primarykey"`
	PoolRegistrationID uint `gorm:"index"`
	PoolID             uint `gorm:"index"`
}

type PoolRegistrationRelay struct {
	Ipv4               *net.IP
	Ipv6               *net.IP
	Hostname           string
	ID                 uint `gorm:"primarykey"`
	PoolRegistrationID uint `gorm:"index"`
	PoolID             uint `gorm:"index"`
	Port               uint
}

type PoolRetirement struct {
	PoolKeyHash   []byte `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	PoolID        uint   `gorm:"index"`
	Epoch         uint64
	AddedSlot     uint64
}

type Redeemer struct {
	ID            uint   `gorm:"primaryKey"`
	TransactionID uint   `gorm:"index"`
	Tag           uint8  `gorm:"index"` // Redeemer tag
	Index         uint32 `gorm:"index"`
	Data          []byte // Plutus data
	ExUnitsMemory uint64
	ExUnitsCPU    uint64
}

type Registration struct {
	StakingKey    []byte `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	CertificateID uint   `gorm:"index"`
	AddedSlot     uint64
	DepositAmount types.Uint64
}

type RegistrationDrep struct {
	AnchorUrl      string
	DrepCredential []byte `gorm:"index"`
	AnchorHash     []byte
	CertificateID  uint `gorm:"index"`
	ID             uint `gorm:"primarykey"`
	AddedSlot      uint64
	DepositAmount  types.Uint64
}

type ResignCommitteeCold struct {
	AnchorUrl      string
	ColdCredential []byte `gorm:"index"`
	AnchorHash     []byte
	ID             uint `gorm:"primarykey"`
	CertificateID  uint `gorm:"index"`
	AddedSlot      uint64
}

type Script struct {
	ID          uint   `gorm:"primaryKey"`
	Hash        []byte `gorm:"index;unique"` // Script hash
	Type        uint8  `gorm:"index"`        // Script type
	Content     []byte // Script content
	CreatedSlot uint64 // Slot when this script was first seen
}

type StakeDelegation struct {
	StakingKey    []byte `gorm:"index"`
	PoolKeyHash   []byte `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64
}

type StakeDeregistration struct {
	StakingKey    []byte `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64
}

type StakeRegistration struct {
	StakingKey    []byte `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64
	DepositAmount types.Uint64
}

type StakeRegistrationDelegation struct {
	StakingKey    []byte `gorm:"index"`
	PoolKeyHash   []byte `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64
	DepositAmount types.Uint64
}

type StakeVoteDelegation struct {
	StakingKey    []byte `gorm:"index"`
	PoolKeyHash   []byte `gorm:"index"`
	Drep          []byte `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64
}

type StakeVoteRegistrationDelegation struct {
	StakingKey    []byte `gorm:"index"`
	PoolKeyHash   []byte `gorm:"index"`
	Drep          []byte `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64
	DepositAmount types.Uint64
}

type Tip struct {
	Hash        []byte
	ID          uint `gorm:"primarykey"`
	Slot        uint64
	BlockNumber uint64
}

type Transaction struct {
	Hash             []byte           `gorm:"uniqueIndex"`
	BlockHash        []byte           `gorm:"index"`
	Inputs           []Utxo           `gorm:"foreignKey:SpentAtTxId;references:Hash"`
	Outputs          []Utxo           `gorm:"foreignKey:TransactionID;references:ID"`
	ReferenceInputs  []Utxo           `gorm:"foreignKey:ReferencedByTxId;references:Hash"`
	Collateral       []Utxo           `gorm:"foreignKey:CollateralByTxId;references:Hash"`
	CollateralReturn *Utxo            `gorm:"foreignKey:TransactionID;references:ID"`
	KeyWitnesses     []KeyWitness     `gorm:"foreignKey:TransactionID;references:ID"`
	WitnessScripts   []WitnessScripts `gorm:"foreignKey:TransactionID;references:ID"`
	Redeemers        []Redeemer       `gorm:"foreignKey:TransactionID;references:ID"`
	PlutusData       []PlutusData     `gorm:"foreignKey:TransactionID;references:ID"`
	ID               uint             `gorm:"primaryKey"`
	Type             int
	BlockIndex       uint32
	Metadata         []byte
	Fee              types.Uint64
	TTL              types.Uint64
	Valid            bool
}

type UpdateDrep struct {
	AnchorUrl     string
	Credential    []byte `gorm:"index"`
	AnchorHash    []byte
	CertificateID uint `gorm:"index"`
	ID            uint `gorm:"primarykey"`
	AddedSlot     uint64
}

type Utxo struct {
	TransactionID    *uint  `gorm:"index"`
	TxId             []byte `gorm:"uniqueIndex:tx_id_output_idx"`
	PaymentKey       []byte `gorm:"index"`
	StakingKey       []byte `gorm:"index"`
	Assets           []Asset
	Cbor             []byte       `gorm:"-"` // This is here for convenience but not represented in the metadata DB
	SpentAtTxId      []byte       `gorm:"index"`
	ReferencedByTxId []byte       `gorm:"index"`
	CollateralByTxId []byte       `gorm:"index"`
	ID               uint         `gorm:"primarykey"`
	AddedSlot        uint64       `gorm:"index"`
	DeletedSlot      uint64       `gorm:"index"`
	Amount           types.Uint64 `gorm:"index"`
	OutputIdx        uint32       `gorm:"uniqueIndex:tx_id_output_idx"`
}

type UtxoSlot struct {
	Utxo ledger.Utxo
	Slot uint64
}

type VoteDelegation struct {
	StakingKey    []byte `gorm:"index"`
	Drep          []byte `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64
}

type VoteRegistrationDelegation struct {
	StakingKey    []byte `gorm:"index"`
	Drep          []byte `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64
	DepositAmount types.Uint64
}

type WitnessScripts struct {
	ID            uint   `gorm:"primaryKey"`
	TransactionID uint   `gorm:"index"`
	Type          uint8  `gorm:"index"` // Script type
	ScriptHash    []byte `gorm:"index"` // Hash of the script
}