database

type Account struct {
	ID int32

	Name     string
	Currency string // code

	CurrentBalance decimal.Decimal
	Extra          map[string]string `gorm:"serializer:json"`
	Flags          AccountFlag

	LastUpdatedAt time.Time
	CreatedAt     time.Time

	DeletedAt        gorm.DeletedAt
	Type             gomoneypbv1.AccountType
	Note             string
	AccountNumber    string
	Iban             string
	LiabilityPercent decimal.NullDecimal
	DisplayOrder     *int32

	FirstTransactionAt *time.Time
}

type AccountFlag = int64

type AppConfig struct {
	ID        string
	Value     string
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt
}

type Category struct {
	ID        int32 `gorm:"primaryKey"`
	Name      string
	CreatedAt time.Time

	DeletedAt gorm.DeletedAt
}

type Currency struct {
	ID   string // Currency ID
	Rate decimal.Decimal

	IsActive bool

	DecimalPlaces int32
	UpdatedAt     time.Time
	DeletedAt     gorm.DeletedAt
}

type DailyStat struct {
	AccountID int32     `gorm:"primaryKey"`
	Date      time.Time `gorm:"primaryKey"`

	Amount decimal.Decimal
}

type DbType int

type DoubleEntry struct {
	ID            int64
	TransactionID int64
	IsDebit       bool

	AmountInBaseCurrency decimal.Decimal
	BaseCurrency         string

	AccountID int32

	TransactionDate time.Time
	CreatedAt       time.Time
	DeletedAt       gorm.DeletedAt
}

type ImportDeduplication struct {
	ImportSource  importv1.ImportSource
	Key           string
	CreatedAt     time.Time
	TransactionID int64
}

type JtiRevocation struct {
	ID        string    `gorm:"type:text;primaryKey"`
	ExpiresAt time.Time `gorm:"type:timestamp;not null"`
}

type MonthlyStat struct {
	AccountID int32     `gorm:"primaryKey"`
	Date      time.Time `gorm:"primaryKey"`

	Balance decimal.Decimal
}

type Rule struct {
	ID              int32
	Title           string
	Script          string
	InterpreterType gomoneypbv1.RuleInterpreterType
	SortOrder       int32
	CreatedAt       time.Time
	UpdatedAt       time.Time
	Enabled         bool
	IsFinalRule     bool
	DeletedAt       gorm.DeletedAt
	GroupName       string
}

type ScheduleRule struct {
	ID              int32
	Title           string
	Script          string
	InterpreterType gomoneypbv1.RuleInterpreterType
	CreatedAt       time.Time
	UpdatedAt       time.Time
	Enabled         bool
	DeletedAt       gorm.DeletedAt
	CronExpression  string
	LastRunAt       *time.Time
	GroupName       string
}

type ServiceToken struct {
	ID string `gorm:"type:uuid;primaryKey"`

	Name      string         `gorm:"type:text;not null"`
	ExpiresAt time.Time      `gorm:"type:timestamp;not null"`
	DeletedAt gorm.DeletedAt `gorm:"index"`
	CreatedAt time.Time      `gorm:"type:timestamp;not null"`
}

type SystemConfig struct {
	ID        string
	Value     string
	CreatedAt time.Time
	UpdatedAt time.Time
}

type SystemConfigRepository struct {
	// contains filtered or unexported fields
}

type Tag struct {
	ID        int32
	Name      string
	Color     string
	Icon      string
	DeletedAt gorm.DeletedAt
	CreatedAt time.Time
}

type Transaction struct {
	ID int64

	SourceAmount               decimal.NullDecimal
	SourceCurrency             string
	SourceAmountInBaseCurrency decimal.NullDecimal

	FxSourceAmount   decimal.NullDecimal // withdrawals only
	FxSourceCurrency string              // withdrawals only

	DestinationAmount               decimal.NullDecimal
	DestinationCurrency             string
	DestinationAmountInBaseCurrency decimal.NullDecimal

	SourceAccountID      int32
	DestinationAccountID int32

	TagIDs pq.Int32Array `gorm:"type:integer[]"`

	CreatedAt time.Time
	UpdatedAt time.Time

	Notes string
	Extra map[string]string `gorm:"serializer:json"`

	TransactionDateTime time.Time `gorm:"type:timestamp"`
	TransactionDateOnly time.Time `gorm:"type:date"`

	TransactionType gomoneypbv1.TransactionType `gorm:"type:int"`
	Flags           TransactionFlags            `gorm:"type:bigint"`

	VoidedByTransactionID *int64
	Title                 string

	DeletedAt gorm.DeletedAt

	ReferenceNumber          *string
	InternalReferenceNumbers pq.StringArray `gorm:"type:text[]"`
	CategoryID               *int32
}

type TransactionFlags int64

type User struct {
	ID       int32
	Login    string
	Password string

	CreatedAt time.Time
	DeletedAt gorm.DeletedAt
}