models

type Account struct {
	StakingKey    []byte `gorm:"uniqueIndex;size:28"`
	Pool          []byte `gorm:"index;size:28"`
	Drep          []byte `gorm:"index;size:28"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
	CertificateID uint   `gorm:"index"`
	Reward        types.Uint64
	// DrepType is the CBOR-encoded DRep delegation type:
	//   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"`
	Active   bool   `gorm:"default:true"`
}

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;size:28"`
	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;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"`
	HostCredential []byte `gorm:"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:"index:hash_slot;size:32"`
	Nonce        []byte
	ID           uint   `gorm:"primarykey"`
	Slot         uint64 `gorm:"index: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 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;size:28"`
	ID            uint   `gorm:"primarykey"`
	CertificateID uint   `gorm:"index"`
	AddedSlot     uint64 `gorm:"index"`
	Amount        types.Uint64
}

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

type Drep struct {
	AnchorURL  string `gorm:"column:anchor_url;size:128"`
	Credential []byte `gorm:"uniqueIndex;size:28"`
	AnchorHash []byte
	ID         uint   `gorm:"primarykey"`
	AddedSlot  uint64 `gorm:"index"`
	// 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:"size:32"`
	ParentActionIdx *uint32
	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)
	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
	VoterCredential []byte  `gorm:"index:idx_vote_voter,priority:2;uniqueIndex:idx_vote_unique,priority:3;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"`
	VoteUpdatedSlot *uint64 `gorm:"index"` // Slot when vote was last changed (for rollback safety)
	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 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"`
}

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

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 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
	// 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 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
	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 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"`
}

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;size:28"`
	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;size:28"`
	AnchorHash     []byte
	CertificateID  uint   `gorm:"index"`
	ID             uint   `gorm:"primarykey"`
	AddedSlot      uint64 `gorm:"uniqueIndex:idx_drep_reg_cred_slot"`
	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 Script struct {
	Hash        []byte `gorm:"index;unique;size:28"`
	Content     []byte
	ID          uint `gorm:"primaryKey"`
	CreatedSlot uint64
	Type        uint8 `gorm:"index"`
}

type StakeDelegation struct {
	StakingKey    []byte `gorm:"index;size:28"`
	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;size:28"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
}

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

type StakeRegistrationDelegation struct {
	StakingKey    []byte `gorm:"index;size:28"`
	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;size:28"`
	PoolKeyHash   []byte `gorm:"index;size:28"`
	Drep          []byte `gorm:"index;size:28"`
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	AddedSlot     uint64 `gorm:"index"`
}

type StakeVoteRegistrationDelegation struct {
	StakingKey    []byte `gorm:"index;size:28"`
	PoolKeyHash   []byte `gorm:"index;size:28"`
	Drep          []byte `gorm:"index;size:28"`
	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 UpdateDrep struct {
	AnchorURL     string `gorm:"column:anchor_url;size:128"`
	Credential    []byte `gorm:"index;size:28"`
	AnchorHash    []byte
	CertificateID uint   `gorm:"index"`
	ID            uint   `gorm:"primarykey"`
	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"`
	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             []byte       `gorm:"index;size:32"`
	ReferencedByTxId        []byte       `gorm:"index;size:32"`
	CollateralByTxId        []byte       `gorm:"index;size:32"`
	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 UtxoId struct {
	Hash []byte
	Idx  uint32
}

type UtxoSlot struct {
	Utxo ledger.Utxo
	Slot uint64
}

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

type VoteRegistrationDelegation struct {
	StakingKey    []byte `gorm:"index;size:28"`
	Drep          []byte `gorm:"index;size:28"`
	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"`
}