database

type Account struct {
	ID          uuid.UUID
	CreatedAt   time.Time
	UpdatedAt   time.Time
	BudgetID    uuid.UUID
	AccountType string
	Name        string
	Notes       string
	IsDeleted   bool
}

type AccountTransfer struct {
	FromTransactionID uuid.UUID
	ToTransactionID   uuid.UUID
}

type AddAccountParams struct {
	BudgetID    uuid.UUID
	AccountType string
	Name        string
	Notes       string
}

type AssignAmountToCategoryParams struct {
	MonthID    time.Time
	CategoryID uuid.UUID
	Amount     int64
}

type AssignBudgetMemberWithRoleParams struct {
	BudgetID   uuid.UUID
	UserID     uuid.UUID
	MemberRole string
}

type Assignment struct {
	Month      time.Time
	CategoryID uuid.UUID
	Assigned   int64
}

type Budget struct {
	ID        uuid.UUID
	CreatedAt time.Time
	UpdatedAt time.Time
	AdminID   uuid.UUID
	Name      string
	Notes     string
}

type Category struct {
	ID        uuid.UUID
	CreatedAt time.Time
	UpdatedAt time.Time
	BudgetID  uuid.UUID
	Name      string
	GroupID   *uuid.UUID
	Notes     string
}

type CategoryReport struct {
	Month        time.Time
	CategoryName string
	CategoryID   uuid.UUID
	BudgetID     uuid.UUID
	Assigned     int64
	Activity     int64
	Balance      int64
}

type CreateBudgetParams struct {
	AdminID uuid.UUID
	Name    string
	Notes   string
}

type CreateCategoryParams struct {
	BudgetID uuid.UUID
	GroupID  *uuid.UUID
	Name     string
	Notes    string
}

type CreateGroupParams struct {
	BudgetID uuid.UUID
	Name     string
	Notes    string
}

type CreatePayeeParams struct {
	BudgetID uuid.UUID
	Name     string
	Notes    string
}

type CreateRefreshTokenParams struct {
	Token     string
	UserID    uuid.UUID
	ExpiresAt time.Time
}

type CreateUserParams struct {
	Username       string
	HashedPassword string
}

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type DeleteMonthAssignmentForCatParams struct {
	Month      time.Time
	CategoryID uuid.UUID
}

type GetBudgetAccountIDAndTypeByNameParams struct {
	AccountName string
	BudgetID    uuid.UUID
}

type GetBudgetAccountIDAndTypeByNameRow struct {
	ID          uuid.UUID
	AccountType string
}

type GetBudgetAccountIDByNameParams struct {
	AccountName string
	BudgetID    uuid.UUID
}

type GetBudgetCapitalParams struct {
	BudgetID    uuid.UUID
	AccountType string
}

type GetBudgetCategoryIDByNameParams struct {
	CategoryName string
	BudgetID     uuid.UUID
}

type GetBudgetGroupIDByNameParams struct {
	GroupName string
	BudgetID  uuid.UUID
}

type GetBudgetMemberRoleParams struct {
	BudgetID uuid.UUID
	UserID   uuid.UUID
}

type GetBudgetPayeeIDByNameParams struct {
	PayeeName string
	BudgetID  uuid.UUID
}

type GetCategoriesParams struct {
	BudgetID uuid.UUID
	GroupID  uuid.UUID
}

type GetGroupByIDParams struct {
	BudgetID uuid.UUID
	ID       uuid.UUID
}

type GetMonthCategoryReportParams struct {
	MonthID    time.Time
	CategoryID uuid.UUID
	BudgetID   uuid.UUID
}

type GetMonthCategoryReportRow struct {
	Month        time.Time
	CategoryName string
	CategoryID   uuid.UUID
	BudgetID     uuid.UUID
	Assigned     int64
	Activity     int64
	Balance      int64
	ID           uuid.UUID
	CreatedAt    time.Time
	UpdatedAt    time.Time
	BudgetID_2   uuid.UUID
	Name         string
	GroupID      *uuid.UUID
	Notes        string
}

type GetMonthCategoryReportsParams struct {
	MonthID  time.Time
	BudgetID uuid.UUID
}

type GetMonthCategoryReportsRow struct {
	Month        time.Time
	CategoryName string
	CategoryID   uuid.UUID
	BudgetID     uuid.UUID
	Assigned     int64
	Activity     int64
	Balance      int64
	ID           uuid.UUID
	CreatedAt    time.Time
	UpdatedAt    time.Time
	BudgetID_2   uuid.UUID
	Name         string
	GroupID      *uuid.UUID
	Notes        string
}

type GetMonthReportParams struct {
	MonthID  time.Time
	BudgetID uuid.UUID
}

type GetMonthReportRow struct {
	Assigned int64
	Activity int64
	Balance  int64
}

type GetTransactionDetailsParams struct {
	BudgetID   uuid.UUID
	AccountID  uuid.UUID
	PayeeID    uuid.UUID
	CategoryID uuid.UUID
	StartDate  time.Time
	EndDate    time.Time
}

type GetTransactionsParams struct {
	BudgetID   uuid.UUID
	AccountID  uuid.UUID
	PayeeID    uuid.UUID
	CategoryID uuid.UUID
	StartDate  time.Time
	EndDate    time.Time
}

type GetUserBudgetsParams struct {
	UserID uuid.UUID
	Roles  []string
}

type Group struct {
	ID        uuid.UUID
	CreatedAt time.Time
	UpdatedAt time.Time
	BudgetID  uuid.UUID
	Name      string
	Notes     string
}

type LogAccountTransferParams struct {
	FromTransactionID uuid.UUID
	ToTransactionID   uuid.UUID
}

type LogTransactionParams struct {
	BudgetID        uuid.UUID
	LoggerID        uuid.UUID
	AccountID       uuid.UUID
	TransactionType string
	TransactionDate time.Time
	PayeeID         uuid.UUID
	Notes           string
	Cleared         bool
}

type LogTransactionSplitsParams struct {
	TransactionID uuid.UUID
	Amounts       []byte
}

type Membership struct {
	CreatedAt  time.Time
	UpdatedAt  time.Time
	BudgetID   uuid.UUID
	UserID     uuid.UUID
	MemberRole string
}

type Payee struct {
	ID        uuid.UUID
	CreatedAt time.Time
	UpdatedAt time.Time
	BudgetID  uuid.UUID
	Name      string
	Notes     string
}

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

type ReassignTransactionsParams struct {
	NewPayeeID uuid.UUID
	OldPayeeID uuid.UUID
}

type RefreshToken struct {
	Token     string
	CreatedAt time.Time
	UpdatedAt time.Time
	UserID    uuid.UUID
	ExpiresAt time.Time
	RevokedAt pgtype.Timestamp
}

type RevokeBudgetMembershipParams struct {
	BudgetID uuid.UUID
	UserID   uuid.UUID
}

type Transaction struct {
	ID              uuid.UUID
	CreatedAt       time.Time
	UpdatedAt       time.Time
	BudgetID        uuid.UUID
	LoggerID        uuid.UUID
	AccountID       uuid.UUID
	TransactionType string
	TransactionDate time.Time
	PayeeID         uuid.UUID
	Notes           string
	Cleared         bool
}

type TransactionDetail struct {
	ID              uuid.UUID
	TransactionDate time.Time
	TransactionType string
	Notes           string
	PayeeName       string
	BudgetName      pgtype.Text
	AccountName     pgtype.Text
	LoggerName      pgtype.Text
	TotalAmount     int64
	Splits          []byte
	Cleared         bool
}

type TransactionSplit struct {
	ID            uuid.UUID
	TransactionID uuid.UUID
	CategoryID    *uuid.UUID
	Amount        int64
}

type UpdateAccountParams struct {
	ID          uuid.UUID
	AccountType string
	Name        string
	Notes       string
}

type UpdateBudgetParams struct {
	ID    uuid.UUID
	Name  string
	Notes string
}

type UpdateCategoryParams struct {
	ID      uuid.UUID
	GroupID *uuid.UUID
	Name    string
	Notes   string
}

type UpdateGroupParams struct {
	ID    uuid.UUID
	Name  string
	Notes string
}

type UpdatePayeeParams struct {
	ID    uuid.UUID
	Name  string
	Notes string
}

type UpdateTransactionParams struct {
	AccountID       uuid.UUID
	TransactionType string
	TransactionDate time.Time
	PayeeID         uuid.UUID
	Notes           string
	Cleared         bool
	TransactionID   uuid.UUID
}

type UpdateUserCredentialsParams struct {
	ID             uuid.UUID
	Username       string
	HashedPassword string
}

type User struct {
	ID             uuid.UUID
	CreatedAt      time.Time
	UpdatedAt      time.Time
	Username       string
	HashedPassword string
}