model

type Account struct {
	ID            int64           `db:"id"             json:"id"`
	Name          string          `db:"name"           json:"name"`
	InitialAmount decimal.Decimal `db:"initial_amount" json:"initialAmount"`

	// Additional fields that used in view
	Total decimal.Decimal `db:"total" json:"total"`
}

type ChartSeries struct {
	AccountID int64           `db:"account_id" json:"accountId"`
	Month     int             `db:"month"      json:"month"`
	Amount    decimal.Decimal `db:"amount"     json:"amount"`
}

type Config struct {
	DbUser     string
	DbPassword string
	DbHost     string
	DbName     string
}

type Entry struct {
	ID                int64           `db:"id"                  json:"id"`
	AccountID         int64           `db:"account_id"          json:"accountId"`
	AffectedAccountID null.Int        `db:"affected_account_id" json:"affectedAccountId"`
	Type              int             `db:"type"                json:"type"`
	Description       null.String     `db:"description"         json:"description"`
	Amount            decimal.Decimal `db:"amount"              json:"amount"`
	Date              string          `db:"date"                json:"date"`

	// Additional foreign key fields
	Account         string      `db:"account"          json:"account"`
	AffectedAccount null.String `db:"affected_account" json:"affectedAccount"`
}

type User struct {
	ID       int64  `db:"id"       json:"id"`
	Username string `db:"username" json:"username"`
	Name     string `db:"name"     json:"name"`
	Password string `db:"password" json:"password,omitempty"`
	Admin    bool   `db:"admin"    json:"admin"`
}