db

type AddBackupCodeParams struct {
	MemberID string
	CodeHash string
}

type ApiToken struct {
	ID         string
	MemberID   string
	Name       string
	TokenHash  string
	Scope      string
	CreatedAt  string
	LastUsedAt *string
	RevokedAt  *string
}

type AssistantUsage struct {
	ID           string
	HouseholdID  string
	MemberID     string
	At           string
	Kind         string
	Surface      string
	Provider     string
	Model        string
	Rounds       int64
	InputTokens  int64
	OutputTokens int64
	CostMicros   *int64
	Failed       int64
}

type AuditLog struct {
	ID         string
	At         string
	ActorKind  string
	ActorID    string
	ActorLabel string
	Action     string
	Entity     string
	EntityID   string
	Before     string
	After      string
	UndoneBy   string
}

type CancelOutboxKindForChargeParams struct {
	ChargeID *string
	Kind     string
}

type CancelOutboxRefParams struct {
	Kind string
	Ref  string
}

type Category struct {
	ID          string
	HouseholdID string
	Name        string
	Color       string
}

type ChannelLink struct {
	ID         string
	MemberID   string
	Channel    string
	ExternalID string
	CreatedAt  string
}

type Charge struct {
	ID              string
	SubscriptionID  string
	OriginalDate    string
	DueDate         string
	AmountMinor     int64
	Currency        string
	ChargedMinor    *int64
	ChargedCurrency *string
	Status          string
	ResolvedAt      *string
	Note            string
	UpdatedAt       string
	Version         int64
	Decision        string
}

type CreateAPITokenParams struct {
	ID        string
	MemberID  string
	Name      string
	TokenHash string
	Scope     string
	CreatedAt string
}

type CreateAuditParams struct {
	ID         string
	At         string
	ActorKind  string
	ActorID    string
	ActorLabel string
	Action     string
	Entity     string
	EntityID   string
	Before     string
	After      string
}

type CreateCategoryParams struct {
	ID          string
	HouseholdID string
	Name        string
	Color       string
}

type CreateFileParams struct {
	ID             string
	HouseholdID    string
	SubscriptionID string
	ChargeID       string
	Kind           string
	Name           string
	MediaType      string
	Size           int64
	Sha256         string
	CreatedAt      string
	CreatedBy      string
	Data           []byte
}

type CreateHouseholdParams struct {
	ID        string
	Name      string
	Currency  string
	Timezone  string
	Locale    string
	CreatedAt string
}

type CreateInviteParams struct {
	CodeHash    string
	HouseholdID string
	Role        string
	CreatedBy   string
	ExpiresAt   string
}

type CreateLinkCodeParams struct {
	CodeHash  string
	MemberID  string
	Channel   string
	ExpiresAt string
}

type CreateMemberParams struct {
	ID           string
	HouseholdID  string
	Name         string
	Email        string
	Role         string
	PasswordHash string
	CreatedAt    string
}

type CreateOAuthClientParams struct {
	ID           string
	Name         string
	Uri          string
	RedirectUris string
	SecretHash   string
	CreatedAt    string
}

type CreateOAuthCodeParams struct {
	CodeHash       string
	ClientID       string
	MemberID       string
	RedirectUri    string
	CodeChallenge  string
	Scope          string
	Resource       string
	SessionVersion int64
	ExpiresAt      string
}

type CreateOAuthGrantParams struct {
	ID             string
	MemberID       string
	ClientID       string
	Scope          string
	Resource       string
	SessionVersion int64
	CreatedAt      string
}

type CreateOAuthTokenParams struct {
	TokenHash string
	GrantID   string
	Kind      string
	CreatedAt string
	ExpiresAt string
}

type CreatePaymentMethodParams struct {
	ID          string
	HouseholdID string
	Name        string
	Kind        string
	Last4       string
	ExpiresOn   *string
	OwnerID     *string
}

type CreateSubscriptionParams struct {
	ID              string
	HouseholdID     string
	Name            string
	PriceMinor      int64
	Currency        string
	Schedule        string
	CategoryID      *string
	PaymentMethodID *string
	PayerID         *string
	Visibility      string
	Status          string
	Url             string
	Notes           string
	AutoConfirm     int64
	Reminders       string
	Details         string
	CreatedBy       string
	CreatedAt       string
	UpdatedAt       string
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteCategoryParams struct {
	ID          string
	HouseholdID string
}

type DeleteChannelLinkParams struct {
	ID       string
	MemberID string
}

type DeleteFuturePendingChargesParams struct {
	SubscriptionID string
	OriginalDate   string
}

type DeleteIdleOAuthClientsParams struct {
	UnusedBefore string
	IdleBefore   *string
}

type DeleteMemberParams struct {
	ID          string
	HouseholdID string
}

type DeletePaymentMethodParams struct {
	ID          string
	HouseholdID string
}

type DeleteSubscriptionParams struct {
	ID          string
	HouseholdID string
}

type DismissFindingParams struct {
	HouseholdID string
	Kind        string
	Key         string
	MemberID    *string
	CreatedAt   string
}

type DismissedFinding struct {
	HouseholdID string
	Kind        string
	Key         string
	MemberID    *string
	CreatedAt   string
}

type EnableTOTPParams struct {
	EnabledAt *string
	Step      int64
	MemberID  string
	Secret    string
}

type EnqueueNoticeParams struct {
	ID        string
	Kind      string
	DedupeKey string
	MemberID  *string
	Ref       string
	DueAt     string
	CreatedAt string
}

type EnqueueOutboxParams struct {
	ID        string
	Kind      string
	DedupeKey string
	ChargeID  *string
	MemberID  *string
	DueAt     string
	CreatedAt string
}

type File struct {
	ID             string
	HouseholdID    string
	SubscriptionID string
	ChargeID       string
	Kind           string
	Name           string
	MediaType      string
	Size           int64
	Sha256         string
	CreatedAt      string
	CreatedBy      string
	DeletedAt      string
	Data           []byte
}

type FindSessionParams struct {
	Token  string
	Expiry string
}

type Flow struct {
	ID        string
	MemberID  string
	State     string
	ExpiresAt string
	CreatedAt string
}

type FxRate struct {
	Day      string
	Currency string
	Rate     string
	Source   string
}

type FxRateOnOrBeforeParams struct {
	Currency string
	Day      string
}

type FxRateOnOrBeforeRow struct {
	Rate string
	Day  string
}

type GetChargeByOriginalDateParams struct {
	SubscriptionID string
	OriginalDate   string
}

type GetFileDataParams struct {
	ID          string
	HouseholdID string
}

type GetFileMetaParams struct {
	ID          string
	HouseholdID string
}

type GetFileMetaRow struct {
	ID             string
	HouseholdID    string
	SubscriptionID string
	ChargeID       string
	Kind           string
	Name           string
	MediaType      string
	Size           int64
	Sha256         string
	CreatedAt      string
	CreatedBy      string
	DeletedAt      string
}

type GetInviteParams struct {
	CodeHash  string
	ExpiresAt string
}

type GetLogoParams struct {
	SubscriptionID string
	HouseholdID    string
}

type GetLogoRow struct {
	ID             string
	HouseholdID    string
	SubscriptionID string
	ChargeID       string
	Kind           string
	Name           string
	MediaType      string
	Size           int64
	Sha256         string
	CreatedAt      string
	CreatedBy      string
	DeletedAt      string
}

type GetMessageParams struct {
	Channel   string
	ChatID    string
	MessageID string
}

type GetOAuthAccessRow struct {
	ExpiresAt     string
	GrantID       string
	MemberID      string
	ClientID      string
	Scope         string
	Resource      string
	GrantVersion  int64
	MemberVersion int64
	HouseholdID   string
	ClientName    string
}

type GetPaymentMethodParams struct {
	ID          string
	HouseholdID string
}

type GetPushSubscriptionRow struct {
	LinkID   string
	MemberID string
	P256dh   string
	Auth     string
	Device   string
}

type GetSubscriptionParams struct {
	ID          string
	HouseholdID string
}

type Household struct {
	ID               string
	Name             string
	Currency         string
	Timezone         string
	Locale           string
	CreatedAt        string
	ReminderHour     int64
	ReminderMinute   int64
	Payday           int64
	ConfirmTimes     int64
	ConfirmEveryDays int64
}

type InsertAssistantUsageParams struct {
	ID           string
	HouseholdID  string
	MemberID     string
	At           string
	Kind         string
	Surface      string
	Provider     string
	Model        string
	Rounds       int64
	InputTokens  int64
	OutputTokens int64
	CostMicros   *int64
	Failed       int64
}

type InsertChargeIfMissingParams struct {
	ID             string
	SubscriptionID string
	OriginalDate   string
	DueDate        string
	AmountMinor    int64
	Currency       string
	UpdatedAt      string
}

type Invite struct {
	CodeHash    string
	HouseholdID string
	Role        string
	CreatedBy   string
	ExpiresAt   string
	UsedAt      *string
}

type LinkChannelParams struct {
	ID         string
	MemberID   string
	Channel    string
	ExternalID string
	CreatedAt  string
}

type LinkCode struct {
	CodeHash  string
	MemberID  string
	Channel   string
	ExpiresAt string
}

type LinkMemberIdentityParams struct {
	Issuer  string
	Subject string
	ID      string
}

type ListAppMessagesForChatParams struct {
	Channel string
	ChatID  string
}

type ListAssistantUsageParams struct {
	HouseholdID string
	MemberID    interface{}
	Lim         int64
}

type ListAssistantUsageRow struct {
	ID           string
	HouseholdID  string
	MemberID     string
	At           string
	Kind         string
	Surface      string
	Provider     string
	Model        string
	Rounds       int64
	InputTokens  int64
	OutputTokens int64
	CostMicros   *int64
	Failed       int64
	MemberName   string
}

type ListChargesBetweenParams struct {
	HouseholdID string
	FromDate    string
	ToDate      string
}

type ListChargesForSubscriptionParams struct {
	SubscriptionID string
	Limit          int64
}

type ListDismissedFindingsParams struct {
	HouseholdID string
	Kind        string
}

type ListDocumentsParams struct {
	SubscriptionID string
	HouseholdID    string
}

type ListDocumentsRow struct {
	ID             string
	HouseholdID    string
	SubscriptionID string
	ChargeID       string
	Kind           string
	Name           string
	MediaType      string
	Size           int64
	Sha256         string
	CreatedAt      string
	CreatedBy      string
	DeletedAt      string
}

type ListFilesForExportRow struct {
	ID             string
	HouseholdID    string
	SubscriptionID string
	ChargeID       string
	Kind           string
	Name           string
	MediaType      string
	Size           int64
	Sha256         string
	CreatedAt      string
	CreatedBy      string
	DeletedAt      string
}

type ListOAuthGrantsOfSameAppParams struct {
	MemberID     string
	Resource     string
	Name         string
	RedirectUris string
}

type ListOAuthGrantsParams struct {
	MemberID string
	Now      string
}

type ListOAuthGrantsRow struct {
	ID           string
	Scope        string
	Resource     string
	CreatedAt    string
	LastUsedAt   *string
	ClientID     string
	ClientKind   string
	ClientName   string
	ClientUri    string
	RedirectUris string
}

type ListOpenChargesDueBeforeParams struct {
	HouseholdID string
	Before      string
}

type ListOutboxDueParams struct {
	DueAt string
	Limit int64
}

type ListOutboxForChargeKindParams struct {
	ChargeID *string
	Kind     string
}

type ListOutboxForChargeKindRow struct {
	DedupeKey string
	DueAt     string
	Status    string
	MemberID  *string
}

type ListOutboxForHouseholdParams struct {
	HouseholdID string
	Limit       int64
}

type ListOutboxForHouseholdRow struct {
	ID               string
	Kind             string
	Status           string
	DueAt            string
	SentAt           *string
	Attempts         int64
	LastError        string
	MemberID         *string
	ChargeID         string
	ChargeDue        string
	SubscriptionID   string
	SubscriptionName string
}

type ListPaidChargesBetweenParams struct {
	HouseholdID string
	FromDate    string
	ToDate      string
}

type MarkAuditUndoneParams struct {
	UndoneBy string
	ID       string
}

type MarkOutboxAttemptFailedParams struct {
	LastError string
	DueAt     string
	Attempts  int64
	ID        string
}

type MarkOutboxObsoleteParams struct {
	LastError string
	ID        string
}

type MarkOutboxSentParams struct {
	SentAt *string
	ID     string
}

type MarkOutboxUndeliverableParams struct {
	LastError string
	ID        string
}

type Member struct {
	ID             string
	HouseholdID    string
	Name           string
	Email          string
	Role           string
	PasswordHash   string
	CreatedAt      string
	SessionVersion int64
	OidcIssuer     string
	OidcSubject    string
	Locale         string
}

type MemberBackupCode struct {
	MemberID string
	CodeHash string
	UsedAt   *string
}

type MemberByIdentityParams struct {
	OidcIssuer  string
	OidcSubject string
}

type MemberForChannelParams struct {
	Channel    string
	ExternalID string
}

type MemberTotp struct {
	MemberID  string
	Secret    string
	CreatedAt string
	EnabledAt *string
	LastStep  int64
}

type Message struct {
	ID        string
	Channel   string
	ChatID    string
	MessageID string
	ChargeID  *string
	MemberID  *string
	CreatedAt string
	Kind      string
	Route     string
}

type OauthClient struct {
	ID           string
	Kind         string
	Name         string
	Uri          string
	RedirectUris string
	SecretHash   string
	CreatedAt    string
	LastUsedAt   *string
	FreshUntil   *string
}

type OauthCode struct {
	CodeHash       string
	ClientID       string
	MemberID       string
	RedirectUri    string
	CodeChallenge  string
	Scope          string
	Resource       string
	SessionVersion int64
	ExpiresAt      string
	UsedAt         *string
	GrantID        *string
}

type OauthGrant struct {
	ID             string
	MemberID       string
	ClientID       string
	Scope          string
	Resource       string
	SessionVersion int64
	CreatedAt      string
	LastUsedAt     *string
}

type OauthToken struct {
	TokenHash string
	GrantID   string
	Kind      string
	CreatedAt string
	ExpiresAt string
	UsedAt    *string
}

type Outbox struct {
	ID        string
	Kind      string
	DedupeKey string
	ChargeID  *string
	MemberID  *string
	DueAt     string
	Status    string
	Attempts  int64
	LastError string
	SentAt    *string
	CreatedAt string
	Ref       string
}

type PaymentMethod struct {
	ID          string
	HouseholdID string
	Name        string
	Kind        string
	Last4       string
	ExpiresOn   *string
	OwnerID     *string
}

type PushSubscription struct {
	LinkID    string
	P256dh    string
	Auth      string
	Device    string
	CreatedAt string
}

type PutPendingTOTPParams struct {
	MemberID  string
	Secret    string
	CreatedAt string
}

type PutSettingParams struct {
	Key   string
	Value string
}

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

type ReassignPayerParams struct {
	ToID        *string
	UpdatedAt   string
	HouseholdID string
	FromID      *string
}

type ReassignPaymentMethodParams struct {
	ToID        *string
	UpdatedAt   string
	HouseholdID string
	FromID      *string
}

type RestoreChargeParams struct {
	ID              string
	SubscriptionID  string
	OriginalDate    string
	DueDate         string
	AmountMinor     int64
	Currency        string
	ChargedMinor    *int64
	ChargedCurrency *string
	Status          string
	ResolvedAt      *string
	Note            string
	Decision        string
	UpdatedAt       string
	Version         int64
}

type RestoreFileParams struct {
	ID          string
	HouseholdID string
}

type RevokeAPITokenParams struct {
	RevokedAt *string
	ID        string
	MemberID  string
}

type SaveAppMessageParams struct {
	ID        string
	Channel   string
	ChatID    string
	MessageID string
	MemberID  *string
	Route     string
	CreatedAt string
}

type SaveFlowParams struct {
	ID        string
	MemberID  string
	State     string
	ExpiresAt string
	CreatedAt string
}

type SaveMessageParams struct {
	ID        string
	Channel   string
	ChatID    string
	MessageID string
	ChargeID  *string
	MemberID  *string
	CreatedAt string
}

type SaveOAuthMetadataClientParams struct {
	ID           string
	Name         string
	Uri          string
	RedirectUris string
	CreatedAt    string
	FreshUntil   *string
}

type SavePushSubscriptionParams struct {
	LinkID    string
	P256dh    string
	Auth      string
	Device    string
	CreatedAt string
}

type SaveSessionParams struct {
	Token  string
	Data   []byte
	Expiry string
}

type Session struct {
	Token  string
	Data   []byte
	Expiry string
}

type SetHouseholdConfirmRepeatParams struct {
	ConfirmTimes     int64
	ConfirmEveryDays int64
	ID               string
}

type SetMemberCredentialsParams struct {
	Name         string
	Email        string
	PasswordHash string
	ID           string
}

type SetMemberLocaleParams struct {
	Locale string
	ID     string
}

type SetMemberPasswordParams struct {
	PasswordHash string
	ID           string
}

type SetMemberProfileParams struct {
	Name  string
	Email string
	ID    string
}

type SetMessageRouteParams struct {
	Route     string
	Channel   string
	ChatID    string
	MessageID string
}

type SetOAuthCodeGrantParams struct {
	GrantID  *string
	CodeHash string
}

type Setting struct {
	Key   string
	Value string
}

type Subscription struct {
	ID              string
	HouseholdID     string
	Name            string
	PriceMinor      int64
	Currency        string
	Schedule        string
	CategoryID      *string
	PaymentMethodID *string
	PayerID         *string
	Visibility      string
	Status          string
	Url             string
	Notes           string
	AutoConfirm     int64
	Reminders       string
	CreatedBy       string
	CreatedAt       string
	UpdatedAt       string
	Version         int64
	Details         string
}

type SumAssistantUsageParams struct {
	HouseholdID string
	Since       string
	Until       string
}

type SumAssistantUsageRow struct {
	Questions    int64
	InputTokens  int64
	OutputTokens int64
	CostMicros   int64
	Unpriced     int64
}

type TakeLinkCodeParams struct {
	CodeHash  string
	Channel   string
	ExpiresAt string
}

type TouchAPITokenParams struct {
	LastUsedAt *string
	ID         string
}

type TouchOAuthClientParams struct {
	LastUsedAt *string
	ID         string
}

type TouchOAuthGrantParams struct {
	Now   *string
	ID    string
	Stale *string
}

type TrashFileParams struct {
	DeletedAt   string
	ID          string
	HouseholdID string
}

type TrashSubscriptionFilesParams struct {
	DeletedAt      string
	SubscriptionID string
	HouseholdID    string
}

type UpdateCategoryParams struct {
	Name        string
	Color       string
	ID          string
	HouseholdID string
}

type UpdateChargeParams struct {
	DueDate         string
	AmountMinor     int64
	Currency        string
	ChargedMinor    *int64
	ChargedCurrency *string
	Status          string
	ResolvedAt      *string
	Note            string
	Decision        string
	UpdatedAt       string
	ID              string
	Version         int64
}

type UpdateHouseholdParams struct {
	Name           string
	Currency       string
	Timezone       string
	Locale         string
	ReminderHour   int64
	ReminderMinute int64
	Payday         int64
	ID             string
}

type UpdateMemberNameParams struct {
	Name        string
	ID          string
	HouseholdID string
}

type UpdateMemberRoleParams struct {
	Role        string
	ID          string
	HouseholdID string
}

type UpdatePaymentMethodParams struct {
	Name        string
	Kind        string
	Last4       string
	ExpiresOn   *string
	OwnerID     *string
	ID          string
	HouseholdID string
}

type UpdateSubscriptionParams struct {
	Name            string
	PriceMinor      int64
	Currency        string
	Schedule        string
	CategoryID      *string
	PaymentMethodID *string
	PayerID         *string
	Visibility      string
	Status          string
	Url             string
	Notes           string
	AutoConfirm     int64
	Reminders       string
	Details         string
	UpdatedAt       string
	ID              string
	HouseholdID     string
	Version         int64
}

type UpsertFxRateParams struct {
	Day      string
	Currency string
	Rate     string
	Source   string
}

type UseBackupCodeParams struct {
	UsedAt   *string
	MemberID string
	CodeHash string
}

type UseInviteParams struct {
	UsedAt   *string
	CodeHash string
}

type UseOAuthCodeParams struct {
	UsedAt   *string
	CodeHash string
}

type UseOAuthTokenParams struct {
	UsedAt    *string
	TokenHash string
}

type UseTOTPStepParams struct {
	Step     int64
	MemberID string
}