database

type Address struct {
	Address string `gorm:"type:char(34);primaryKey"`

	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	CustomInstructions datatypes.JSONSlice[bsv.CustomInstruction]

	UserID string
	User   *User `gorm:"foreignKey:UserID"`
}

type Data struct {
	TxID string `gorm:"primaryKey"`
	Vout uint32 `gorm:"primaryKey"`

	UserID string

	Blob []byte
}

type Operation struct {
	TxID   string `gorm:"primaryKey"`
	UserID string `gorm:"primaryKey"`

	CreatedAt time.Time

	Counterparty string
	Type         string
	Value        int64

	User        *User               `gorm:"foreignKey:UserID"`
	Transaction *TrackedTransaction `gorm:"foreignKey:TxID"`
}

type Paymail struct {
	gorm.Model

	Alias  string `gorm:"uniqueIndex:idx_alias_domain"`
	Domain string `gorm:"uniqueIndex:idx_alias_domain"`

	PublicName string
	Avatar     string

	UserID string
}

type TrackedOutput struct {
	TxID       string `gorm:"primaryKey"`
	Vout       uint32 `gorm:"primaryKey"`
	SpendingTX string `gorm:"type:char(64)"`

	UserID string

	Satoshis bsv.Satoshis

	CreatedAt time.Time
	UpdatedAt time.Time
}

type TrackedTransaction struct {
	ID       string `gorm:"type:char(64);primaryKey"`
	TxStatus string

	CreatedAt time.Time
	UpdatedAt time.Time

	BlockHeight *int64
	BlockHash   *string

	Data []*Data `gorm:"-"` // Don't auto-save, handled in AfterCreate hook

	Inputs  []*TrackedOutput `gorm:"foreignKey:SpendingTX"`
	Outputs []*TrackedOutput `gorm:"foreignKey:TxID"`

	BeefHex        *string   `gorm:"column:beef_hex"`
	RawHex         *string   `gorm:"column:raw_hex"`
	SourceTxInputs []TxInput `gorm:"foreignKey:TxID;constraint:OnDelete:CASCADE;"`
	// contains filtered or unexported fields
}

type TxInput struct {
	TxID       string `gorm:"type:char(64);primaryKey"` // ID of the spending transaction
	SourceTxID string `gorm:"type:char(64);primaryKey"` // ID of the source transaction
}

type User struct {
	ID        string `gorm:"type:char(34);primaryKey"`
	CreatedAt time.Time
	UpdatedAt time.Time

	PubKey string `gorm:"index;unique;not null"`

	Paymails  []*Paymail     `gorm:"foreignKey:UserID"`
	Addresses []*Address     `gorm:"foreignKey:UserID"`
	Contacts  []*UserContact `gorm:"foreignKey:UserID"`
}

type UserContact struct {
	gorm.Model

	FullName string
	Status   string
	Paymail  string
	PubKey   string

	UserID string
	User   *User `gorm:"foreignKey:UserID"`
}

type UserUTXO struct {
	UserID   string `gorm:"primaryKey;uniqueIndex:idx_window,sort:asc,priority:1"`
	TxID     string `gorm:"primaryKey;uniqueIndex:idx_window,sort:asc,priority:4"`
	Vout     uint32 `gorm:"primaryKey;uniqueIndex:idx_window,sort:asc,priority:5"`
	Satoshis uint64
	// EstimatedInputSize is the estimated size increase when adding and unlocking this UTXO to a transaction.
	EstimatedInputSize uint64
	Bucket             string    `gorm:"check:chk_not_data_bucket,bucket <> 'data'"`
	CreatedAt          time.Time `gorm:"uniqueIndex:idx_window,sort:asc,priority:3"`
	// TouchedAt is the time when the UTXO was last touched (selected for preparing transaction outline) - used for prioritizing UTXO selection.
	TouchedAt time.Time `gorm:"uniqueIndex:idx_window,sort:asc,priority:2"`
	// CustomInstructions is the list of instructions for unlocking given UTXO (it should be understood by client).
	CustomInstructions datatypes.JSONSlice[bsv.CustomInstruction]
}