models

type Account struct {
	StakingKey    []byte `` /* 224-byte string literal not displayed */
	CredentialTag uint8  `` /* 235-byte string literal not displayed */
	Pool          []byte `gorm:"index;size:28;index:idx_account_active_pool_staking_key,priority:2"`
	Drep          []byte `gorm:"index;size:28;index:idx_account_drep_active_staking_key,priority:1"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	Reward        types.Uint64
	// DrepType is the DRep delegation type code, an internal enum
	// matching the Cardano ledger CBOR sum-type tag:
	//   0 = key credential, 1 = script credential,
	//   2 = AlwaysAbstain, 3 = AlwaysNoConfidence.
	// A zero value (0) means either "key credential" or "no delegation set",
	// disambiguated by whether Drep is nil.
	DrepType uint64 `gorm:"default:0;index:idx_account_drep_type_active_staking_key,priority:1"`
	Active   bool   `` /* 183-byte string literal not displayed */
}

type AccountDelegationHistoryRow struct {
	AddedSlot   uint64
	BlockIndex  uint32
	CertIndex   uint32
	TxHash      []byte
	PoolKeyHash []byte
	// TxSlot is the slot of the transaction containing the
	// delegation certificate.
	TxSlot uint64
	// BlockHash is the hash of the block containing the
	// delegation certificate's transaction. The block height is
	// resolved from the block store, which is not part of the
	// metadata SQL schema.
	BlockHash []byte
}

type AccountRegistrationHistoryRow struct {
	AddedSlot  uint64
	BlockIndex uint32
	CertIndex  uint32
	TxHash     []byte
	Action     string
	// Deposit is the registration deposit (or refund, for
	// deregistrations) in lovelace. Zero for certificate types
	// that do not record an explicit deposit.
	Deposit uint64
	// TxSlot is the slot of the transaction containing the
	// (de)registration certificate.
	TxSlot uint64
	// BlockHash is the hash of the block containing the
	// (de)registration certificate's transaction. The block
	// height is resolved from the block store, which is not part
	// of the metadata SQL schema.
	BlockHash []byte
}

type AccountRewardDelta struct {
	StakingKey     []byte       `` /* 136-byte string literal not displayed */
	CredentialTag  uint8        `` /* 138-byte string literal not displayed */
	TxHash         []byte       `gorm:"index;size:32;not null;uniqueIndex:idx_account_reward_delta_w_tx_s_slot,priority:2"`
	Amount         types.Uint64 `gorm:"not null"`
	PreviousReward types.Uint64
	ID             uint   `gorm:"primarykey"`
	AddedSlot      uint64 `gorm:"index;not null;uniqueIndex:idx_account_reward_delta_w_tx_s_slot,priority:5"`
	Withdrawal     bool   `gorm:"index;not null;default:false;uniqueIndex:idx_account_reward_delta_w_tx_s_slot,priority:1"`
}

type AccountSums struct {
	// WithdrawalsSum is the total of all reward withdrawals
	// made by the account.
	WithdrawalsSum uint64
	// ReservesSum is the total of all MIR transfers to the
	// account sourced from the reserves pot.
	ReservesSum uint64
	// TreasurySum is the total of all MIR transfers to the
	// account sourced from the treasury pot.
	TreasurySum uint64
}

type AddressTransaction struct {
	ID            uint   `gorm:"primaryKey"`
	PaymentKey    []byte `gorm:"index:idx_addr_tx_payment;size:28"`
	StakingKey    []byte `gorm:"index:idx_addr_tx_staking,priority:2;size:28"`
	CredentialTag uint8  `gorm:"not null;default:0;index:idx_addr_tx_staking,priority:1"`
	TransactionID uint   `gorm:"index"`
	Slot          uint64 `gorm:"index"`
	TxIndex       uint32
}

type Asset struct {
	Name        []byte       `gorm:"uniqueIndex:idx_asset_unique;size:32"`
	NameHex     []byte       `gorm:"index;size:64"`
	PolicyId    []byte       `gorm:"index:idx_asset_policy_id;uniqueIndex:idx_asset_unique;size:28"`
	Fingerprint []byte       `gorm:"index;size:48"`
	ID          uint         `gorm:"primaryKey"`
	UtxoID      uint         `gorm:"index;uniqueIndex:idx_asset_unique"`
	Amount      types.Uint64 `gorm:"index"`
}

type AuthCommitteeHot struct {
	ColdCredential []byte `gorm:"index;size:28"`
	// Column is "host_credential" for backward compatibility with
	// existing databases; the Go field uses the canonical Cardano
	// terminology ("hot credential" for committee voting keys).
	HotCredential []byte `gorm:"column:host_credential;index;size:28"`
	ID            uint   `gorm:"primarykey"`
	CertificateID uint   `gorm:"index"`
	AddedSlot     uint64 `gorm:"index"`
}

type BackfillCheckpoint struct {
	ID         uint   `gorm:"primarykey"`
	Phase      string `gorm:"uniqueIndex;size:64;not null"` // "metadata"
	LastSlot   uint64 // Last successfully processed slot
	TotalSlots uint64 // Total slots to process (for progress)
	StartedAt  time.Time
	UpdatedAt  time.Time
	Completed  bool
}

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

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

type Certificate struct {
	BlockHash     []byte `gorm:"index;size:32"`
	ID            uint   `gorm:"primaryKey"`
	TransactionID uint   `gorm:"index;uniqueIndex:uniq_tx_cert"`
	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 CommitteeMember struct {
	ID           uint    `gorm:"primarykey"`
	ColdCredHash []byte  `gorm:"uniqueIndex;size:28;not null"` // 28-byte credential hash
	ExpiresEpoch uint64  `gorm:"not null"`
	AddedSlot    uint64  `gorm:"index;not null"` // Slot when imported/registered
	DeletedSlot  *uint64 `gorm:"index"`          // For rollback support
}

type CommitteeQuorum struct {
	Quorum    *types.Rat
	ID        uint   `gorm:"primarykey"`
	AddedSlot uint64 `gorm:"uniqueIndex;not null"`
}

type Constitution struct {
	ID          uint    `gorm:"primarykey"`
	AnchorURL   string  `gorm:"column:anchor_url;size:128;not null"`
	AnchorHash  []byte  `gorm:"size:32;not null"`
	PolicyHash  []byte  `gorm:"size:28"`
	AddedSlot   uint64  `gorm:"uniqueIndex;not null"`
	DeletedSlot *uint64 `gorm:"index"`
}

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

type Deregistration struct {
	StakingKey    []byte `gorm:"index:idx_deregistration_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_deregistration_credential,priority:1;not null;default:0"`
	ID            uint   `gorm:"primarykey"`
	CertificateID uint   `gorm:"index"`
	AddedSlot     uint64 `gorm:"index"`
	Amount        types.Uint64
}

type DeregistrationDrep struct {
	DrepCredential []byte `gorm:"index:idx_dereg_drep_credential,priority:2;size:28"`
	CertificateID  uint   `gorm:"index"`
	ID             uint   `gorm:"primarykey"`
	CredentialTag  uint8  `gorm:"index:idx_dereg_drep_credential,priority:1;not null;default:0"`
	AddedSlot      uint64 `gorm:"index"`
	DepositAmount  types.Uint64
}

type Drep struct {
	AnchorURL     string `gorm:"column:anchor_url;size:128"`
	Credential    []byte `gorm:"uniqueIndex:idx_drep_credential,priority:2;size:28"`
	AnchorHash    []byte
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
	CredentialTag uint8  `gorm:"uniqueIndex:idx_drep_credential,priority:1;not null;default:0"`
	// Last activity epoch (vote, register, update).
	LastActivityEpoch uint64 `gorm:"index;default:0"`
	// Epoch when DRep expires (activity + inactivity).
	ExpiryEpoch uint64 `gorm:"index;default:0"`
	Active      bool   `gorm:"default:true"`
}

type Epoch struct {
	Nonce         []byte
	EvolvingNonce []byte
	// CandidateNonce holds the frozen candidate nonce from the end
	// of the previous epoch (psCandidateNonce in Haskell). In
	// Ouroboros Praos, the candidate nonce tracks the evolving
	// nonce until the randomness stabilisation window cutoff
	// (4k/f slots before the end of the epoch), then freezes.
	// When 4k/f >= epochLength (e.g., devnets with short epochs),
	// the candidate nonce is never updated and stays at its
	// initial value (genesis hash). This field carries the
	// candidate nonce across epochs so it can seed the next
	// epoch's computation correctly.
	CandidateNonce []byte
	// LastEpochBlockNonce holds the prevHash of the last applied
	// block from the PREVIOUS epoch transition (praosStateLabNonce
	// in Haskell). In Ouroboros Praos, the epoch nonce formula uses
	// a lagged lab nonce: at the N→N+1 transition, the nonce saved
	// at N-1→N is used. This field is nil for epoch 0 (equivalent
	// to NeutralNonce / identity).
	LastEpochBlockNonce []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 EpochSummary struct {
	ID               uint         `gorm:"primarykey"`
	Epoch            uint64       `gorm:"uniqueIndex;not null"`
	TotalActiveStake types.Uint64 `gorm:"not null"`
	TotalPoolCount   uint64       `gorm:"not null"`
	TotalDelegators  uint64       `gorm:"not null"`
	EpochNonce       []byte       `gorm:"size:32"`
	BoundarySlot     uint64       `gorm:"not null"`
	SnapshotReady    bool         `gorm:"not null;default:false"`
}

type GovernanceProposal struct {
	ID              uint    `gorm:"primarykey"`
	TxHash          []byte  `gorm:"uniqueIndex:idx_proposal_tx_action,priority:1;size:32;not null"`
	ActionIndex     uint32  `gorm:"uniqueIndex:idx_proposal_tx_action,priority:2;not null"`
	ActionType      uint8   `gorm:"index;not null"` // GovActionType enum
	ProposedEpoch   uint64  `gorm:"index;not null"`
	ExpiresEpoch    uint64  `gorm:"index;not null"`
	ParentTxHash    []byte  `gorm:"index:idx_gov_proposal_parent,priority:1;size:32"`
	ParentActionIdx *uint32 `gorm:"index:idx_gov_proposal_parent,priority:2"`
	EnactedEpoch    *uint64
	EnactedSlot     *uint64 `gorm:"index"` // Slot when enacted (for rollback safety)
	RatifiedEpoch   *uint64
	RatifiedSlot    *uint64 `gorm:"index"` // Slot when ratified (for rollback safety)
	PolicyHash      []byte  `gorm:"size:28"`
	AnchorURL       string  `gorm:"column:anchor_url;size:128;not null"`
	AnchorHash      []byte  `gorm:"size:32;not null"`
	Deposit         uint64  `gorm:"not null"`
	ReturnAddress   []byte  `gorm:"size:29;not null"` // Reward account for deposit return (1 byte header + 28 bytes hash)
	// GovActionCbor holds the CBOR-encoded GovAction needed at enactment
	// time to extract type-specific fields (ParamUpdate, ProtocolVersion,
	// Withdrawals, Committee changes, Constitution). Populated on proposal
	// submission so enactment does not need to re-fetch the transaction.
	GovActionCbor []byte
	ExpiredEpoch  *uint64 `gorm:"index"`
	ExpiredSlot   *uint64 `gorm:"index"` // Slot when expired (for rollback safety)
	AddedSlot     uint64  `gorm:"index;not null"`
	DeletedSlot   *uint64 `gorm:"index"`
}

type GovernanceVote struct {
	ID                 uint   `gorm:"primarykey"`
	ProposalID         uint   `gorm:"index:idx_vote_proposal;uniqueIndex:idx_vote_unique,priority:1;not null"`
	VoterType          uint8  `gorm:"index:idx_vote_voter,priority:1;uniqueIndex:idx_vote_unique,priority:2;not null"` // 0=CC, 1=DRep, 2=SPO
	VoterCredentialTag uint8  `gorm:"index:idx_vote_voter,priority:2;uniqueIndex:idx_vote_unique,priority:3;not null;default:0"`
	VoterCredential    []byte `gorm:"index:idx_vote_voter,priority:3;uniqueIndex:idx_vote_unique,priority:4;size:28;not null"`
	Vote               uint8  `gorm:"not null"` // 0=No, 1=Yes, 2=Abstain
	AnchorURL          string `gorm:"column:anchor_url;size:128"`
	AnchorHash         []byte `gorm:"size:32"`
	AddedSlot          uint64 `gorm:"index;not null"`
	// Slot when vote was last changed (for rollback safety).
	VoteUpdatedSlot *uint64 `gorm:"index"`
	DeletedSlot     *uint64 `gorm:"index"`
}

type ImportCheckpoint struct {
	ID        uint   `gorm:"primarykey"`
	ImportKey string `gorm:"size:255;uniqueIndex;not null"` // "{digest}:{slot}"
	Phase     string `gorm:"not null"`                      // last completed phase
}

type KeyWitness struct {
	Vkey          []byte
	Signature     []byte
	PublicKey     []byte
	ChainCode     []byte
	Attributes    []byte
	ID            uint  `gorm:"primaryKey"`
	TransactionID uint  `gorm:"index"`
	Type          uint8 `gorm:"index"`
}

type MIREffect struct {
	// ID is the move_instantaneous_rewards row ID. It is used as the stable
	// per-MIR reward-credit discriminator when applying epoch-boundary effects.
	ID uint
	// Pot is the source Ada pot: 0 = Reserves, 1 = Treasury.
	Pot uint
	// OtherPot is the amount for a pot-to-pot transfer (0 when distributing).
	OtherPot uint64
	// Rewards lists credential→amount pairs for a distribution MIR.
	Rewards []MIRReward
}

type MIRReward struct {
	Credential    []byte
	CredentialTag uint8
	Amount        uint64
}

type MidnightAriadneParams struct {
	ID    uint   `gorm:"primarykey"`
	Epoch uint64 `gorm:"uniqueIndex;not null"`
	Datum []byte `gorm:"not null"`
}

type MidnightAriadneRollback struct {
	ID             uint   `gorm:"primarykey"`
	BlockNumber    uint64 `gorm:"uniqueIndex:idx_midnight_ariadne_rollbacks_block_epoch,priority:1;not null"`
	Epoch          uint64 `gorm:"uniqueIndex:idx_midnight_ariadne_rollbacks_block_epoch,priority:2;not null"`
	PreviousExists bool   `gorm:"not null"`
	PreviousDatum  []byte
}

type MidnightAssetCreate struct {
	ID               uint   `gorm:"primarykey"`
	Address          []byte `gorm:"not null"`
	Quantity         uint64 `gorm:"not null"`
	TxHash           []byte `gorm:"uniqueIndex:idx_midnight_asset_creates_utxo_lookup,priority:1;size:32;not null"`
	OutputIndex      uint32 `gorm:"uniqueIndex:idx_midnight_asset_creates_utxo_lookup,priority:2;not null"`
	BlockNumber      uint64 `gorm:"index:idx_midnight_asset_creates_block_tx,priority:1;not null"`
	BlockHash        []byte `gorm:"size:32;not null"`
	TxIndex          uint32 `gorm:"index:idx_midnight_asset_creates_block_tx,priority:2;not null"`
	BlockTimestampMs uint64 `gorm:"not null"`
}

type MidnightAssetSpend struct {
	ID               uint   `gorm:"primarykey"`
	Address          []byte `gorm:"not null"`
	Quantity         uint64 `gorm:"not null"`
	SpendingTxHash   []byte `gorm:"size:32;not null"`
	UtxoTxHash       []byte `gorm:"uniqueIndex:idx_midnight_asset_spends_utxo_ref,priority:1;size:32;not null"`
	UtxoIndex        uint32 `gorm:"uniqueIndex:idx_midnight_asset_spends_utxo_ref,priority:2;not null"`
	BlockNumber      uint64 `gorm:"index:idx_midnight_asset_spends_block_tx,priority:1;not null"`
	BlockHash        []byte `gorm:"size:32;not null"`
	TxIndex          uint32 `gorm:"index:idx_midnight_asset_spends_block_tx,priority:2;not null"`
	BlockTimestampMs uint64 `gorm:"not null"`
}

type MidnightDeregistration struct {
	ID               uint   `gorm:"primarykey"`
	FullDatum        []byte `gorm:"not null"`
	TxHash           []byte `gorm:"size:32;not null"`
	UtxoTxHash       []byte `gorm:"uniqueIndex:idx_midnight_deregistrations_utxo_ref,priority:1;size:32;not null"`
	UtxoIndex        uint32 `gorm:"uniqueIndex:idx_midnight_deregistrations_utxo_ref,priority:2;not null"`
	BlockNumber      uint64 `gorm:"index:idx_midnight_deregistrations_block_tx,priority:1;not null"`
	BlockHash        []byte `gorm:"size:32;not null"`
	TxIndex          uint32 `gorm:"index:idx_midnight_deregistrations_block_tx,priority:2;not null"`
	BlockTimestampMs uint64 `gorm:"not null"`
}

type MidnightEpochCandidates struct {
	ID             uint   `gorm:"primarykey"`
	Epoch          uint64 `gorm:"uniqueIndex;not null"`
	BlockNumber    uint64 `gorm:"index;not null;default:0"`
	CandidatesCbor []byte `gorm:"not null"`
}

type MidnightGovernanceDatum struct {
	ID          uint   `gorm:"primarykey"`
	DatumType   string `` /* 139-byte string literal not displayed */
	TxHash      []byte `gorm:"uniqueIndex:idx_midnight_governance_datums_output,priority:2;size:32;not null"`
	OutputIndex uint32 `gorm:"uniqueIndex:idx_midnight_governance_datums_output,priority:3;not null"`
	Datum       []byte `gorm:"not null"`
	BlockNumber uint64 `gorm:"index:idx_midnight_governance_datums_latest,priority:2,sort:desc;not null"`
}

type MidnightRegistration struct {
	ID               uint   `gorm:"primarykey"`
	FullDatum        []byte `gorm:"not null"`
	TxHash           []byte `gorm:"uniqueIndex:idx_midnight_registrations_utxo_lookup,priority:1;size:32;not null"`
	OutputIndex      uint32 `gorm:"uniqueIndex:idx_midnight_registrations_utxo_lookup,priority:2;not null"`
	BlockNumber      uint64 `gorm:"index:idx_midnight_registrations_block_tx,priority:1;not null"`
	BlockHash        []byte `gorm:"size:32;not null"`
	TxIndex          uint32 `gorm:"index:idx_midnight_registrations_block_tx,priority:2;not null"`
	BlockTimestampMs uint64 `gorm:"not null"`
}

type MoveInstantaneousRewards struct {
	Rewards       []MoveInstantaneousRewardsReward `gorm:"foreignKey:MIRID;constraint:OnDelete:CASCADE"`
	Pot           uint                             `gorm:"index"`
	CertificateID uint                             `gorm:"index"`
	ID            uint                             `gorm:"primarykey"`
	AddedSlot     uint64                           `gorm:"index"`
	// OtherPot holds the lovelace amount for a pot-to-pot transfer (non-zero
	// only when the cert moves coins between treasury and reserves rather than
	// distributing to staking credentials).
	OtherPot types.Uint64 `gorm:"default:0"`
}

type MoveInstantaneousRewardsReward struct {
	Credential    []byte `gorm:"index:idx_mir_reward_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_mir_reward_credential,priority:1;not null;default:0"`
	Amount        types.Uint64
	ID            uint `gorm:"primarykey"`
	MIRID         uint `gorm:"index"`
}

type NetworkDonation struct {
	ID     uint   `gorm:"primarykey"`
	Slot   uint64 `gorm:"uniqueIndex;not null"`
	Epoch  uint64 `gorm:"index;not null"`
	Amount uint64 `gorm:"not null"`
}

type NetworkState struct {
	ID       uint         `gorm:"primarykey"`
	Treasury types.Uint64 `gorm:"not null"`
	Reserves types.Uint64 `gorm:"not null"`
	Slot     uint64       `gorm:"uniqueIndex;not null"`
}

type OffchainMetadata struct {
	FetchedAt      *time.Time
	NextFetchAfter *time.Time `gorm:"index:idx_offchain_metadata_status_next,priority:2"`
	CreatedAt      time.Time
	UpdatedAt      time.Time
	URL            string `gorm:"size:512;not null;uniqueIndex:idx_offchain_metadata_source_url_hash,priority:2"`
	SourceType     string `gorm:"size:32;not null;uniqueIndex:idx_offchain_metadata_source_url_hash,priority:1"`
	Status         string `gorm:"size:16;not null;index:idx_offchain_metadata_status_next,priority:1"`
	ContentType    string `gorm:"size:128"`
	LastError      string `gorm:"size:1024"`
	Hash           []byte `gorm:"size:32;not null;uniqueIndex:idx_offchain_metadata_source_url_hash,priority:3"`
	BodyHash       []byte `gorm:"size:32"`
	Content        []byte
	ID             uint `gorm:"primarykey"`
	FetchAttempts  uint
	LastHTTPStatus uint
}

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

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

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

type Pool struct {
	Margin               *types.Rat
	PoolKeyHash          []byte `gorm:"uniqueIndex;size:28"`
	VrfKeyHash           []byte
	RewardAccount        []byte
	LatestOpCertSequence uint64
	// RewardAccountCredentialTag is the stake credential type of the pool's
	// reward account: 0 = key hash, 1 = script hash. The on-chain pool cert
	// encodes the reward_account as a 29-byte reward address (header + 28-byte
	// hash). The gouroboros library stores only the first 28 bytes in
	// RewardAccount (AddrKeyHash), discarding the header. We decode the raw
	// cert CBOR to preserve the credential type here.
	RewardAccountCredentialTag uint8 `gorm:"not null;default:0"`
	// Owners and Relays are query-only associations (no CASCADE).
	// The actual parent-child relationship is PoolRegistration -> Owners/Relays.
	// When Pool is deleted, PoolRegistrations cascade, which then cascade to Owners/Relays.
	Owners       []PoolRegistrationOwner `gorm:"foreignKey:PoolID"`
	Relays       []PoolRegistrationRelay `gorm:"foreignKey:PoolID"`
	Registration []PoolRegistration      `gorm:"foreignKey:PoolID;constraint:OnDelete:CASCADE"`
	Retirement   []PoolRetirement        `gorm:"foreignKey:PoolID;constraint:OnDelete:CASCADE"`
	ID           uint                    `gorm:"primarykey"`
	Pledge       types.Uint64
	Cost         types.Uint64
}

type PoolOpCertSequence struct {
	PoolKeyHash []byte `gorm:"uniqueIndex:idx_pool_opcert_sequence_pool_slot;size:28"`
	ID          uint   `gorm:"primarykey"`
	Slot        uint64 `gorm:"uniqueIndex:idx_pool_opcert_sequence_pool_slot;index"`
	Sequence    uint64
}

type PoolRegistration struct {
	Margin                     *types.Rat
	Pool                       *Pool // Belongs-to relationship; CASCADE is defined on Pool.Registration
	MetadataUrl                string
	VrfKeyHash                 []byte
	PoolKeyHash                []byte `gorm:"index;size:28"`
	RewardAccount              []byte
	RewardAccountCredentialTag uint8 `gorm:"not null;default:0"`
	MetadataHash               []byte
	Owners                     []PoolRegistrationOwner `gorm:"foreignKey:PoolRegistrationID;constraint:OnDelete:CASCADE"`
	Relays                     []PoolRegistrationRelay `gorm:"foreignKey:PoolRegistrationID;constraint:OnDelete:CASCADE"`
	Pledge                     types.Uint64
	Cost                       types.Uint64
	CertificateID              uint   `gorm:"index"`
	ID                         uint   `gorm:"primarykey"`
	PoolID                     uint   `gorm:"uniqueIndex:idx_pool_reg_pool_slot"`
	AddedSlot                  uint64 `gorm:"uniqueIndex:idx_pool_reg_pool_slot"`
	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;size:28"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	PoolID        uint   `gorm:"index"`
	Epoch         uint64
	AddedSlot     uint64 `gorm:"index"`
}

type PoolRetirementRefund struct {
	PoolKeyHash                []byte
	RewardAccount              []byte
	RewardAccountCredentialTag uint8
	DepositAmount              types.Uint64
}

type PoolStakeSnapshot struct {
	ID             uint         `gorm:"primarykey"`
	Epoch          uint64       `gorm:"uniqueIndex:idx_pool_stake_epoch_pool,priority:1;not null"`
	SnapshotType   string       `gorm:"type:varchar(4);uniqueIndex:idx_pool_stake_epoch_pool,priority:2;not null"` // "mark", "set", "go"
	PoolKeyHash    []byte       `gorm:"uniqueIndex:idx_pool_stake_epoch_pool,priority:3;size:28;not null"`
	TotalStake     types.Uint64 `gorm:"not null"`
	DelegatorCount uint64       `gorm:"not null"`
	CapturedSlot   uint64       `gorm:"not null"`
	// RewardAccountAutoVote captures the CIP-1694 SPO auto-vote
	// outcome implied by the pool's reward-account DRep delegation at
	// the snapshot epoch. Values come from PoolRewardAccountAutoVote*.
	// This field is only meaningful when RewardAccountAutoVoteResolved
	// is true; otherwise its value is undefined and must not be read
	// by the tally.
	RewardAccountAutoVote uint8 `gorm:"not null;default:0"`
	// RewardAccountAutoVoteResolved disambiguates "resolved as none"
	// from "never resolved". The resolver sets this to true after it
	// has computed RewardAccountAutoVote against snapshot-era state.
	// Rows imported by Mithril for set/go rotations (which only have
	// live state available at import time and cannot be faithfully
	// resolved against historical boundaries) intentionally leave this
	// false; the tally treats them as PoolRewardAccountAutoVoteNone,
	// matching pre-CIP-1694 behaviour for those rows. Pre-CIP-1694
	// rows in upgraded databases also remain false until re-resolved.
	RewardAccountAutoVoteResolved bool `gorm:"not null;default:false"`
}

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

type Registration struct {
	StakingKey    []byte `gorm:"index:idx_registration_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_registration_credential,priority:1;not null;default:0"`
	ID            uint   `gorm:"primarykey"`
	CertificateID uint   `gorm:"index"`
	AddedSlot     uint64 `gorm:"index"`
	DepositAmount types.Uint64
}

type RegistrationDrep struct {
	AnchorURL      string `gorm:"column:anchor_url;size:128"`
	DrepCredential []byte `gorm:"uniqueIndex:idx_drep_reg_cred_slot,priority:2;size:28"`
	AnchorHash     []byte
	CertificateID  uint   `gorm:"index"`
	ID             uint   `gorm:"primarykey"`
	CredentialTag  uint8  `gorm:"uniqueIndex:idx_drep_reg_cred_slot,priority:1;not null;default:0"`
	AddedSlot      uint64 `gorm:"uniqueIndex:idx_drep_reg_cred_slot,priority:3"`
	DepositAmount  types.Uint64
}

type ResignCommitteeCold struct {
	AnchorURL      string `gorm:"column:anchor_url;size:128"`
	ColdCredential []byte `gorm:"index;size:28"`
	AnchorHash     []byte
	ID             uint   `gorm:"primarykey"`
	CertificateID  uint   `gorm:"index"`
	AddedSlot      uint64 `gorm:"index"`
}

type RewardAdaPots struct {
	ID           uint         `gorm:"primarykey"`
	Epoch        uint64       `gorm:"uniqueIndex;not null"`
	Treasury     types.Uint64 `gorm:"not null"`
	Reserves     types.Uint64 `gorm:"not null"`
	Fees         types.Uint64 `gorm:"not null"`
	Rewards      types.Uint64 `gorm:"not null"`
	CapturedSlot uint64       `gorm:"index;not null"`
}

type RewardPoolInput struct {
	Margin             *types.Rat
	PoolKeyHash        []byte `gorm:"uniqueIndex:idx_reward_pool_input_epoch_pool,priority:2;size:28;not null"`
	BlocksProduced     *uint64
	TotalBlocksInEpoch *uint64
	ID                 uint         `gorm:"primarykey"`
	Epoch              uint64       `gorm:"uniqueIndex:idx_reward_pool_input_epoch_pool,priority:1;not null"`
	Pledge             types.Uint64 `gorm:"not null"`
	DelegatedStake     types.Uint64 `gorm:"not null"`
	Cost               types.Uint64 `gorm:"not null"`
	DelegatorCount     uint64       `gorm:"not null"`
	CapturedSlot       uint64       `gorm:"index;not null"`
	BoundarySlot       uint64       `gorm:"index;not null"`
}

type RewardSnapshot struct {
	ID               uint         `gorm:"primarykey"`
	Epoch            uint64       `gorm:"uniqueIndex:idx_reward_snapshot_epoch_type,priority:1;not null"`
	SnapshotType     string       `gorm:"type:varchar(4);uniqueIndex:idx_reward_snapshot_epoch_type,priority:2;not null"`
	TotalActiveStake types.Uint64 `gorm:"not null"`
	TotalPoolCount   uint64       `gorm:"not null"`
	TotalDelegators  uint64       `gorm:"not null"`
	CapturedSlot     uint64       `gorm:"index;not null"`
	BoundarySlot     uint64       `gorm:"index;not null"`
	EpochNonce       []byte       `gorm:"size:32"`
	ProtocolVersion  uint         `gorm:"not null"`
}

type Script struct {
	Hash        []byte `gorm:"index;unique;size:28"`
	Content     []byte
	ID          uint `gorm:"primaryKey"`
	CreatedSlot uint64
	Type        uint8 `gorm:"index"`
}

type StakeCredentialRef struct {
	Tag uint8
	Key []byte
}

type StakeDelegation struct {
	StakingKey    []byte `gorm:"index:idx_stake_delegation_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_stake_delegation_credential,priority:1;not null;default:0"`
	PoolKeyHash   []byte `gorm:"index;size:28"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
}

type StakeDeregistration struct {
	StakingKey    []byte `gorm:"index:idx_stake_deregistration_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_stake_deregistration_credential,priority:1;not null;default:0"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
}

type StakeRegistration struct {
	StakingKey    []byte `gorm:"index:idx_stake_registration_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_stake_registration_credential,priority:1;not null;default:0"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
	DepositAmount types.Uint64
}

type StakeRegistrationDelegation struct {
	StakingKey    []byte `gorm:"index:idx_stake_registration_delegation_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_stake_registration_delegation_credential,priority:1;not null;default:0"`
	PoolKeyHash   []byte `gorm:"index;size:28"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
	DepositAmount types.Uint64
}

type StakeVoteDelegation struct {
	StakingKey    []byte `gorm:"index:idx_stake_vote_delegation_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_stake_vote_delegation_credential,priority:1;not null;default:0"`
	PoolKeyHash   []byte `gorm:"index;size:28"`
	Drep          []byte `gorm:"index;size:28"`
	DrepType      uint64 `gorm:"default:0"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
}

type StakeVoteRegistrationDelegation struct {
	StakingKey    []byte `gorm:"index:idx_stake_vote_registration_delegation_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_stake_vote_registration_delegation_credential,priority:1;not null;default:0"`
	PoolKeyHash   []byte `gorm:"index;size:28"`
	Drep          []byte `gorm:"index;size:28"`
	DrepType      uint64 `gorm:"default:0"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
	DepositAmount types.Uint64
}

type SyncState struct {
	Key   string `gorm:"column:sync_key;primaryKey;size:255"`
	Value string `gorm:"type:text;not null"`
}

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

type Transaction struct {
	// CollateralReturn uses a separate FK (CollateralReturnForTxID) to distinguish
	// from regular Outputs which use TransactionID. This allows GORM to load each
	// association correctly without ambiguity.
	CollateralReturn *Utxo            `gorm:"foreignKey:CollateralReturnForTxID;references:ID;constraint:OnDelete:CASCADE"`
	PlutusData       []PlutusData     `gorm:"foreignKey:TransactionID;references:ID;constraint:OnDelete:CASCADE"`
	Certificates     []Certificate    `gorm:"foreignKey:TransactionID;references:ID;constraint:OnDelete:CASCADE"`
	Outputs          []Utxo           `gorm:"foreignKey:TransactionID;references:ID;constraint:OnDelete:CASCADE"`
	Hash             []byte           `gorm:"uniqueIndex;size:32"`
	Collateral       []Utxo           `gorm:"foreignKey:CollateralByTxId;references:Hash"`
	BlockHash        []byte           `gorm:"index;size:32"`
	KeyWitnesses     []KeyWitness     `gorm:"foreignKey:TransactionID;references:ID;constraint:OnDelete:CASCADE"`
	WitnessScripts   []WitnessScripts `gorm:"foreignKey:TransactionID;references:ID;constraint:OnDelete:CASCADE"`
	Inputs           []Utxo           `gorm:"foreignKey:SpentAtTxId;references:Hash"`
	Redeemers        []Redeemer       `gorm:"foreignKey:TransactionID;references:ID;constraint:OnDelete:CASCADE"`
	ReferenceInputs  []Utxo           `gorm:"foreignKey:ReferencedByTxId;references:Hash"`
	Metadata         []byte
	Slot             uint64 `gorm:"index"`
	Type             int
	ID               uint `gorm:"primaryKey"`
	Fee              types.Uint64
	TTL              types.Uint64
	BlockIndex       uint32
	Valid            bool
}

type TransactionMetadataLabel struct {
	ID            uint         `gorm:"primaryKey"`
	TransactionID uint         `gorm:"uniqueIndex:idx_tx_metadata_label_tx_label"`
	Label         types.Uint64 `gorm:"index;uniqueIndex:idx_tx_metadata_label_tx_label"`
	Slot          uint64       `gorm:"index"`
	CborValue     []byte
	JsonValue     string `gorm:"type:text"`
}

type UpdateDrep struct {
	AnchorURL     string `gorm:"column:anchor_url;size:128"`
	Credential    []byte `gorm:"index:idx_update_drep_credential,priority:2;size:28"`
	AnchorHash    []byte
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	CredentialTag uint8  `gorm:"index:idx_update_drep_credential,priority:1;not null;default:0"`
	AddedSlot     uint64 `gorm:"index"`
}

type Utxo struct {
	TransactionID           *uint   `gorm:"index"`
	CollateralReturnForTxID *uint   `gorm:"uniqueIndex"` // Unique: a transaction has at most one collateral return output
	TxId                    []byte  `gorm:"uniqueIndex:tx_id_output_idx;size:32"`
	PaymentKey              []byte  `gorm:"index;size:28"`
	StakingKey              []byte  `gorm:"index;size:28;index:idx_utxo_deleted_staking_amount,priority:3;index:idx_utxo_staking_deleted_amount,priority:2"`
	CredentialTag           uint8   `gorm:"not null;default:0;index:idx_utxo_deleted_staking_amount,priority:2;index:idx_utxo_staking_deleted_amount,priority:1"`
	Assets                  []Asset `gorm:"foreignKey:UtxoID;constraint:OnDelete:CASCADE"`
	Cbor                    []byte  `gorm:"-"`       // This is here for convenience but not represented in the metadata DB
	DatumHash               []byte  `gorm:"size:32"` // Optional datum hash (32 bytes)
	Datum                   []byte  `gorm:"-"`       // Inline datum CBOR, not stored in metadata DB
	ScriptRef               []byte  `gorm:"-"`       // Reference script bytes, not stored in metadata DB
	// SpentAtTxId, ReferencedByTxId, and CollateralByTxId are nullable FKs to
	// transaction(hash); they are unset until a UTxO is spent/referenced.
	// They use types.NullableHash so an empty value serializes to SQL NULL
	// (not an empty blob), which is required for the FK to be skipped — see
	// the type docs for the FOREIGN KEY constraint failed (787) issue.
	SpentAtTxId      types.NullableHash `gorm:"index;size:32"`
	ReferencedByTxId types.NullableHash `gorm:"index;size:32"`
	CollateralByTxId types.NullableHash `gorm:"index;size:32"`
	ID               uint               `gorm:"primarykey"`
	AddedSlot        uint64             `gorm:"index"`
	DeletedSlot      uint64             `` /* 153-byte string literal not displayed */
	Amount           types.Uint64       `` /* 153-byte string literal not displayed */
	OutputIdx        uint32             `gorm:"uniqueIndex:tx_id_output_idx"`
	// PaymentScript is true when the output's payment credential is a
	// script hash (as opposed to a key hash). It is derived from the
	// address type at index time and used to compute the network's
	// script-locked supply (see GetScriptLockedSupply). The composite
	// index (deleted_slot, payment_script, amount) lets the supply sum
	// scan only live script UTxOs.
	PaymentScript bool `gorm:"index:idx_utxo_deleted_payment_script,priority:2"`
}

type UtxoId struct {
	Hash []byte
	Idx  uint32
}

type UtxoOrderingCursor struct {
	Slot       uint64
	BlockIndex uint32
	OutputIdx  uint32
}

type UtxoSlot struct {
	Utxo ledger.Utxo
	Slot uint64
}

type UtxoWithOrdering struct {
	Utxo
	TxSlot       uint64 `gorm:"column:tx_slot"`
	TxBlockIndex uint32 `gorm:"column:tx_block_index"`
}

type UtxoWithOrderingQuery struct {
	MatchAllAddresses bool
	Addresses         []ledger.Address
	After             *UtxoOrderingCursor
	Limit             int
	FilterByAsset     bool
	AssetPolicyID     []byte
	AssetName         []byte
}

type VoteDelegation struct {
	StakingKey    []byte `gorm:"index:idx_vote_delegation_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_vote_delegation_credential,priority:1;not null;default:0"`
	Drep          []byte `gorm:"index;size:28"`
	DrepType      uint64 `gorm:"default:0"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
}

type VoteRegistrationDelegation struct {
	StakingKey    []byte `gorm:"index:idx_vote_registration_delegation_credential,priority:2;size:28"`
	CredentialTag uint8  `gorm:"index:idx_vote_registration_delegation_credential,priority:1;not null;default:0"`
	Drep          []byte `gorm:"index;size:28"`
	DrepType      uint64 `gorm:"default:0"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
	DepositAmount types.Uint64
}

type WitnessScripts struct {
	ScriptHash    []byte `gorm:"index;size:28"`
	ID            uint   `gorm:"primaryKey"`
	TransactionID uint   `gorm:"index"`
	Type          uint8  `gorm:"index"`
}