model

type AccountTransfer struct {
	ID                 string            `db:"id"`
	AccountID          string            `db:"account_id"`
	Amount             decimal.Decimal   `db:"amount"`
	AmountCents        int               `db:"amount_cents"` // deprecated: kept for SELECT * compatibility
	Direction          TransferDirection `db:"direction"`
	Note               string            `db:"note"`
	RecurringDepositID *string           `db:"recurring_deposit_id"`
	CreatedBy          string            `db:"created_by"`
	CreatedAt          time.Time         `db:"created_at"`
}

type AccountTransferWithAccount struct {
	AccountTransfer
	AccountName string `db:"account_name"`
}

type Budget struct {
	ID          string          `db:"id"`
	SpaceID     string          `db:"space_id"`
	Amount      decimal.Decimal `db:"amount"`
	AmountCents int             `db:"amount_cents"` // deprecated: kept for SELECT * compatibility
	Period      BudgetPeriod    `db:"period"`
	StartDate   time.Time       `db:"start_date"`
	EndDate     *time.Time      `db:"end_date"`
	IsActive    bool            `db:"is_active"`
	CreatedBy   string          `db:"created_by"`
	CreatedAt   time.Time       `db:"created_at"`
	UpdatedAt   time.Time       `db:"updated_at"`
}

type BudgetPeriod string

type BudgetStatus string

type BudgetWithSpent struct {
	Budget
	Tags       []*Tag
	Spent      decimal.Decimal
	Percentage float64
	Status     BudgetStatus
}

type DailySpending struct {
	Date  time.Time       `db:"date"`
	Total decimal.Decimal `db:"total"`
}

type Expense struct {
	ID                 string          `db:"id"`
	SpaceID            string          `db:"space_id"`
	CreatedBy          string          `db:"created_by"`
	Description        string          `db:"description"`
	Amount             decimal.Decimal `db:"amount"`
	AmountCents        int             `db:"amount_cents"` // deprecated: kept for SELECT * compatibility
	Type               ExpenseType     `db:"type"`
	Date               time.Time       `db:"date"`
	PaymentMethodID    *string         `db:"payment_method_id"`
	RecurringExpenseID *string         `db:"recurring_expense_id"`
	CreatedAt          time.Time       `db:"created_at"`
	UpdatedAt          time.Time       `db:"updated_at"`
}

type ExpenseItem struct {
	ExpenseID string `db:"expense_id"`
	ItemID    string `db:"item_id"`
}

type ExpenseTag struct {
	ExpenseID string `db:"expense_id"`
	TagID     string `db:"tag_id"`
}

type ExpenseType string

type ExpenseWithTags struct {
	Expense
	Tags []*Tag
}

type ExpenseWithTagsAndMethod struct {
	Expense
	Tags          []*Tag
	PaymentMethod *PaymentMethod
}

type File struct {
	ID           string    `db:"id"`
	UserID       string    `db:"user_id"`    // Who owns/created this file
	OwnerType    string    `db:"owner_type"` // "user", "profile", etc. - the entity that owns the file
	OwnerID      string    `db:"owner_id"`   // Polymorphic FK
	Type         string    `db:"type"`
	Filename     string    `db:"filename"`
	OriginalName string    `db:"original_name"`
	MimeType     string    `db:"mime_type"`
	Size         int64     `db:"size"`
	StoragePath  string    `db:"storage_path"`
	CreatedAt    time.Time `db:"created_at"`
}

type Frequency string

type FundingSourceType string

type InvitationStatus string

type ListCardData struct {
	List        *ShoppingList
	Items       []*ListItem
	CurrentPage int
	TotalPages  int
}

type ListItem struct {
	ID        string    `db:"id"`
	ListID    string    `db:"list_id"`
	Name      string    `db:"name"`
	IsChecked bool      `db:"is_checked"`
	CreatedBy string    `db:"created_by"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type ListWithUncheckedItems struct {
	List  *ShoppingList
	Items []*ListItem
}

type Loan struct {
	ID                  string          `db:"id"`
	SpaceID             string          `db:"space_id"`
	Name                string          `db:"name"`
	Description         string          `db:"description"`
	OriginalAmount      decimal.Decimal `db:"original_amount"`
	OriginalAmountCents int             `db:"original_amount_cents"` // deprecated: kept for SELECT * compatibility
	InterestRateBps     int             `db:"interest_rate_bps"`
	StartDate           time.Time       `db:"start_date"`
	EndDate             *time.Time      `db:"end_date"`
	IsPaidOff           bool            `db:"is_paid_off"`
	CreatedBy           string          `db:"created_by"`
	CreatedAt           time.Time       `db:"created_at"`
	UpdatedAt           time.Time       `db:"updated_at"`
}

type LoanWithPaymentSummary struct {
	Loan
	TotalPaid    decimal.Decimal
	Remaining    decimal.Decimal
	ReceiptCount int
}

type MoneyAccount struct {
	ID        string    `db:"id"`
	SpaceID   string    `db:"space_id"`
	Name      string    `db:"name"`
	CreatedBy string    `db:"created_by"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type MoneyAccountWithBalance struct {
	MoneyAccount
	Balance decimal.Decimal
}

type MonthlySpending struct {
	Month string          `db:"month"`
	Total decimal.Decimal `db:"total"`
}

type PaymentMethod struct {
	ID        string            `db:"id"`
	SpaceID   string            `db:"space_id"`
	Name      string            `db:"name"`
	Type      PaymentMethodType `db:"type"`
	LastFour  *string           `db:"last_four"`
	CreatedBy string            `db:"created_by"`
	CreatedAt time.Time         `db:"created_at"`
	UpdatedAt time.Time         `db:"updated_at"`
}

type PaymentMethodExpenseSummary struct {
	PaymentMethodID   string          `db:"payment_method_id"`
	PaymentMethodName string          `db:"payment_method_name"`
	PaymentMethodType string          `db:"payment_method_type"`
	TotalAmount       decimal.Decimal `db:"total_amount"`
}

type PaymentMethodType string

type Profile struct {
	ID        string    `db:"id"`
	UserID    string    `db:"user_id"`
	Name      string    `db:"name"`
	Timezone  *string   `db:"timezone"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type Receipt struct {
	ID                 string          `db:"id"`
	LoanID             string          `db:"loan_id"`
	SpaceID            string          `db:"space_id"`
	Description        string          `db:"description"`
	TotalAmount        decimal.Decimal `db:"total_amount"`
	TotalAmountCents   int             `db:"total_amount_cents"` // deprecated: kept for SELECT * compatibility
	Date               time.Time       `db:"date"`
	RecurringReceiptID *string         `db:"recurring_receipt_id"`
	CreatedBy          string          `db:"created_by"`
	CreatedAt          time.Time       `db:"created_at"`
	UpdatedAt          time.Time       `db:"updated_at"`
}

type ReceiptFundingSource struct {
	ID               string            `db:"id"`
	ReceiptID        string            `db:"receipt_id"`
	SourceType       FundingSourceType `db:"source_type"`
	AccountID        *string           `db:"account_id"`
	Amount           decimal.Decimal   `db:"amount"`
	AmountCents      int               `db:"amount_cents"` // deprecated: kept for SELECT * compatibility
	LinkedExpenseID  *string           `db:"linked_expense_id"`
	LinkedTransferID *string           `db:"linked_transfer_id"`
}

type ReceiptFundingSourceWithAccount struct {
	ReceiptFundingSource
	AccountName string
}

type ReceiptWithSources struct {
	Receipt
	Sources []ReceiptFundingSource
}

type ReceiptWithSourcesAndAccounts struct {
	Receipt
	Sources []ReceiptFundingSourceWithAccount
}

type RecurringExpense struct {
	ID              string          `db:"id"`
	SpaceID         string          `db:"space_id"`
	CreatedBy       string          `db:"created_by"`
	Description     string          `db:"description"`
	Amount          decimal.Decimal `db:"amount"`
	AmountCents     int             `db:"amount_cents"` // deprecated: kept for SELECT * compatibility
	Type            ExpenseType     `db:"type"`
	PaymentMethodID *string         `db:"payment_method_id"`
	Frequency       Frequency       `db:"frequency"`
	StartDate       time.Time       `db:"start_date"`
	EndDate         *time.Time      `db:"end_date"`
	NextOccurrence  time.Time       `db:"next_occurrence"`
	IsActive        bool            `db:"is_active"`
	CreatedAt       time.Time       `db:"created_at"`
	UpdatedAt       time.Time       `db:"updated_at"`
}

type RecurringExpenseWithTags struct {
	RecurringExpense
	Tags []*Tag
}

type RecurringExpenseWithTagsAndMethod struct {
	RecurringExpense
	Tags          []*Tag
	PaymentMethod *PaymentMethod
}

type RecurringReceipt struct {
	ID               string          `db:"id"`
	LoanID           string          `db:"loan_id"`
	SpaceID          string          `db:"space_id"`
	Description      string          `db:"description"`
	TotalAmount      decimal.Decimal `db:"total_amount"`
	TotalAmountCents int             `db:"total_amount_cents"` // deprecated: kept for SELECT * compatibility
	Frequency        Frequency       `db:"frequency"`
	StartDate        time.Time       `db:"start_date"`
	EndDate          *time.Time      `db:"end_date"`
	NextOccurrence   time.Time       `db:"next_occurrence"`
	IsActive         bool            `db:"is_active"`
	CreatedBy        string          `db:"created_by"`
	CreatedAt        time.Time       `db:"created_at"`
	UpdatedAt        time.Time       `db:"updated_at"`
}

type RecurringReceiptSource struct {
	ID                 string            `db:"id"`
	RecurringReceiptID string            `db:"recurring_receipt_id"`
	SourceType         FundingSourceType `db:"source_type"`
	AccountID          *string           `db:"account_id"`
	Amount             decimal.Decimal   `db:"amount"`
	AmountCents        int               `db:"amount_cents"` // deprecated: kept for SELECT * compatibility
}

type RecurringReceiptWithLoan struct {
	RecurringReceipt
	LoanName string
	Sources  []RecurringReceiptSource
}

type RecurringReceiptWithSources struct {
	RecurringReceipt
	Sources []RecurringReceiptSource
}

type Role string

type ShoppingList struct {
	ID        string    `db:"id"`
	SpaceID   string    `db:"space_id"`
	Name      string    `db:"name"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type Space struct {
	ID        string    `db:"id"`
	Name      string    `db:"name"`
	OwnerID   string    `db:"owner_id"`
	Timezone  *string   `db:"timezone"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type SpaceInvitation struct {
	Token     string           `db:"token"`
	SpaceID   string           `db:"space_id"`
	InviterID string           `db:"inviter_id"`
	Email     string           `db:"email"`
	Status    InvitationStatus `db:"status"`
	ExpiresAt time.Time        `db:"expires_at"`
	CreatedAt time.Time        `db:"created_at"`
	UpdatedAt time.Time        `db:"updated_at"`
}

type SpaceMember struct {
	SpaceID  string    `db:"space_id"`
	UserID   string    `db:"user_id"`
	Role     Role      `db:"role"`
	JoinedAt time.Time `db:"joined_at"`
}

type SpaceMemberWithProfile struct {
	SpaceID  string    `db:"space_id"`
	UserID   string    `db:"user_id"`
	Role     Role      `db:"role"`
	JoinedAt time.Time `db:"joined_at"`
	Name     string    `db:"name"`
	Email    string    `db:"email"`
}

type SpendingReport struct {
	ByTag           []*TagExpenseSummary
	ByPaymentMethod []*PaymentMethodExpenseSummary
	DailySpending   []*DailySpending
	MonthlySpending []*MonthlySpending
	TopExpenses     []*ExpenseWithTagsAndMethod
	TotalIncome     decimal.Decimal
	TotalExpenses   decimal.Decimal
	NetBalance      decimal.Decimal
}

type Tag struct {
	ID        string    `db:"id"`
	SpaceID   string    `db:"space_id"`
	Name      string    `db:"name"`
	Color     *string   `db:"color"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type TagExpenseSummary struct {
	TagID       string          `db:"tag_id"`
	TagName     string          `db:"tag_name"`
	TagColor    *string         `db:"tag_color"`
	TotalAmount decimal.Decimal `db:"total_amount"`
}

type Token struct {
	ID        string     `db:"id"`
	UserID    string     `db:"user_id"`
	Type      string     `db:"type"` // "email_verify" or "password_reset"
	Token     string     `db:"token"`
	ExpiresAt time.Time  `db:"expires_at"`
	UsedAt    *time.Time `db:"used_at"`
	CreatedAt time.Time  `db:"created_at"`
}

type TransferDirection string

type User struct {
	ID    string `db:"id"`
	Email string `db:"email"`
	// Allow null for passwordless users
	PasswordHash    *string    `db:"password_hash"`
	PendingEmail    *string    `db:"pending_email"`
	EmailVerifiedAt *time.Time `db:"email_verified_at"`
	CreatedAt       time.Time  `db:"created_at"`
}