record

type CardEmailRecord struct {
	ID           int    `json:"id"`            // Unique identifier for the record
	Email        string `json:"email"`         // Email address associated with the card
	UserID       int    `json:"user_id"`       // ID of the user who owns this card
	CardNumber   string `json:"card_number"`   // Card number (typically masked)
	CardType     string `json:"card_type"`     // Type of card (e.g., Visa, MasterCard)
	ExpireDate   string `json:"expire_date"`   // Card expiration date in MM/YY format
	CVV          string `json:"cvv"`           // Card verification value (typically masked)
	CardProvider string `json:"card_provider"` // Provider or issuing bank of the card
	CreatedAt    string `json:"created_at"`    // Timestamp when the record was created
	UpdatedAt    string `json:"updated_at"`    // Timestamp when the record was last updated
}

type CardMonthAmount struct {
	Month       string `json:"month"`        // Month in YYYY-MM format
	TotalAmount int64  `json:"total_amount"` // Total transaction amount for the month in smallest currency unit
}

type CardMonthBalance struct {
	Month        string `json:"month"`         // Month in YYYY-MM format
	TotalBalance int64  `json:"total_balance"` // Total balance for the month in smallest currency unit (e.g., cents)
}

type CardRecord struct {
	ID           int     `json:"id"`            // Unique identifier for the card record
	UserID       int     `json:"user_id"`       // ID of the user who owns this card
	CardNumber   string  `json:"card_number"`   // Card number (typically masked in outputs)
	CardType     string  `json:"card_type"`     // Type of card (e.g., Visa, MasterCard)
	ExpireDate   string  `json:"expire_date"`   // Card expiration date in MM/YY format
	CVV          string  `json:"cvv"`           // Card verification value (typically masked)
	CardProvider string  `json:"card_provider"` // Provider or issuing bank of the card
	CreatedAt    string  `json:"created_at"`    // Timestamp when the record was created
	UpdatedAt    string  `json:"updated_at"`    // Timestamp when the record was last updated
	DeletedAt    *string `json:"deleted_at"`    // Timestamp when the record was soft-deleted (nil if not deleted)
}

type CardYearAmount struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalAmount int64  `json:"total_amount"` // Total transaction amount for the year in smallest currency unit
}

type CardYearlyBalance struct {
	Year         string `json:"year"`          // Year in YYYY format
	TotalBalance int64  `json:"total_balance"` // Total balance for the year in smallest currency unit (e.g., cents)
}

type MerchantDocumentRecord struct {
	ID           int     `json:"id"`            // Unique identifier for the document record
	MerchantID   int     `json:"merchant_id"`   // ID of the merchant this document belongs to
	DocumentType string  `json:"document_type"` // Type of document (e.g., "license", "contract", "identity")
	DocumentURL  string  `json:"document_url"`  // URL or path where the document is stored
	Status       string  `json:"status"`        // Current status of the document (e.g., "pending", "approved", "rejected")
	Note         string  `json:"note"`          // Additional notes or comments about the document
	CreatedAt    string  `json:"created_at"`    // Timestamp when the record was created
	UpdatedAt    string  `json:"updated_at"`    // Timestamp when the record was last updated
	DeletedAt    *string `json:"deleted_at"`    // Timestamp when the record was soft-deleted (nil if not deleted)
}

type MerchantMonthlyAmount struct {
	Month       string `json:"month"`        // Month in YYYY-MM format
	TotalAmount int    `json:"total_amount"` // Total transaction amount for the month in smallest currency unit
}

type MerchantMonthlyPaymentMethod struct {
	Month         string `json:"month"`          // Month in YYYY-MM format
	PaymentMethod string `json:"payment_method"` // Type of payment method (e.g., "credit", "debit")
	TotalAmount   int    `json:"total_amount"`   // Total amount processed for this payment method in the month
}

type MerchantMonthlyTotalAmount struct {
	Year        string `json:"year"`         // Year in YYYY format
	Month       string `json:"month"`        // Month in MM format
	TotalAmount int    `json:"total_amount"` // Total transaction amount for the month in smallest currency unit
}

type MerchantRecord struct {
	ID        int     `json:"id"`         // Unique identifier for the merchant
	Name      string  `json:"name"`       // Legal name of the merchant
	ApiKey    string  `json:"api_key"`    // API key used for merchant authentication (typically masked)
	UserID    int     `json:"user_id"`    // ID of the user who owns/administers this merchant account
	Status    string  `json:"status"`     // Current status of the merchant (e.g., "active", "suspended")
	CreatedAt string  `json:"created_at"` // Timestamp when the merchant was created
	UpdatedAt string  `json:"updated_at"` // Timestamp when the merchant was last updated
	DeletedAt *string `json:"deleted_at"` // Timestamp when the merchant was soft-deleted (nil if not deleted)
}

type MerchantTransactionsRecord struct {
	TransactionID   int32     `json:"transaction_id"`   // Unique identifier for the transaction
	CardNumber      string    `json:"card_number"`      // Masked card number used for the transaction
	Amount          int32     `json:"amount"`           // Transaction amount in smallest currency unit (e.g., cents)
	PaymentMethod   string    `json:"payment_method"`   // Payment method used (e.g., "credit", "debit")
	MerchantID      int32     `json:"merchant_id"`      // ID of the merchant who processed the transaction
	MerchantName    string    `json:"merchant_name"`    // Name of the merchant at time of transaction
	TransactionTime time.Time `json:"transaction_time"` // Timestamp when the transaction occurred
	CreatedAt       string    `json:"created_at"`       // Timestamp when the record was created
	UpdatedAt       string    `json:"updated_at"`       // Timestamp when the record was last updated
	DeletedAt       *string   `json:"deleted_at"`       // Timestamp when the record was soft-deleted (nil if not deleted)
}

type MerchantYearlyAmount struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalAmount int    `json:"total_amount"` // Total transaction amount for the year in smallest currency unit
}

type MerchantYearlyPaymentMethod struct {
	Year          string `json:"year"`           // Year in YYYY format
	PaymentMethod string `json:"payment_method"` // Type of payment method (e.g., "credit", "debit")
	TotalAmount   int    `json:"total_amount"`   // Total amount processed for this payment method in the year
}

type MerchantYearlyTotalAmount struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalAmount int    `json:"total_amount"` // Total transaction amount for the year in smallest currency unit
}

type RefreshTokenRecord struct {
	ID        int    `json:"id"`         // Unique identifier for the refresh token record
	UserID    int    `json:"user_id"`    // ID of the user this token belongs to
	Token     string `json:"token"`      // The actual refresh token value (typically hashed in storage)
	ExpiredAt string `json:"expired_at"` // Timestamp when this token expires and becomes invalid
	CreatedAt string `json:"created_at"` // Timestamp when the token was created
	UpdatedAt string `json:"updated_at"` // Timestamp when the token was last updated
}

type ResetTokenRecord struct {
	ID        int64  `json:"id"`         // Unique identifier for the reset token record
	Token     string `json:"token"`      // The actual reset token value (typically hashed in storage)
	UserID    int64  `json:"user_id"`    // ID of the user this token belongs to
	ExpiredAt string `json:"expired_at"` // Timestamp when this token expires and becomes invalid
}

type RoleRecord struct {
	ID        int     `json:"id"`         // Unique identifier for the role
	Name      string  `json:"name"`       // Name of the role (e.g., "admin", "user", "manager")
	CreatedAt string  `json:"created_at"` // Timestamp when the role was created
	UpdatedAt string  `json:"updated_at"` // Timestamp when the role was last updated
	DeletedAt *string `json:"deleted_at"` // Timestamp when the role was soft-deleted (nil if active)
}

type SaldoMonthSaldoBalance struct {
	Month        string `json:"month"`         // Month in YYYY-MM format
	TotalBalance int    `json:"total_balance"` // Aggregate balance for the month in smallest currency unit
}

type SaldoMonthTotalBalance struct {
	Year         string `json:"year"`          // Year in YYYY format
	Month        string `json:"month"`         // Month in MM format
	TotalBalance int    `json:"total_balance"` // Aggregate balance for the month in smallest currency unit
}

type SaldoRecord struct {
	ID             int     `json:"id"`              // Unique identifier for the record
	CardNumber     string  `json:"card_number"`     // Card number associated with the balance (typically masked)
	TotalBalance   int     `json:"total_balance"`   // Current available balance in smallest currency unit (e.g., cents)
	WithdrawAmount int     `json:"withdraw_amount"` // Amount withdrawn in smallest currency unit (e.g., cents)
	WithdrawTime   string  `json:"withdraw_time"`   // Timestamp of when the withdrawal occurred
	CreatedAt      string  `json:"created_at"`      // Timestamp when the record was created
	UpdatedAt      string  `json:"updated_at"`      // Timestamp when the record was last updated
	DeletedAt      *string `json:"deleted_at"`      // Timestamp when record was soft-deleted (nil if active)
}

type SaldoYearSaldoBalance struct {
	Year         string `json:"year"`          // Year in YYYY format
	TotalBalance int    `json:"total_balance"` // Aggregate balance for the year in smallest currency unit
}

type SaldoYearTotalBalance struct {
	Year         string `json:"year"`          // Year in YYYY format
	TotalBalance int    `json:"total_balance"` // Aggregate balance for the year in smallest currency unit
}

type TopupMonthAmount struct {
	Month       string `json:"month"`        // Month in YYYY-MM format
	TotalAmount int    `json:"total_amount"` // Total top-up amount for the month in smallest currency unit
}

type TopupMonthMethod struct {
	Month       string `json:"month"`        // Month in YYYY-MM format
	TopupMethod string `json:"topup_method"` // Payment method used (e.g., "bank_transfer")
	TotalTopups int    `json:"total_topups"` // Number of top-ups using this method in the month
	TotalAmount int    `json:"total_amount"` // Total amount processed via this method in smallest currency unit
}

type TopupRecord struct {
	ID          int     `json:"id"`           // Unique identifier for the top-up record
	CardNumber  string  `json:"card_number"`  // Card number being topped up (typically masked)
	TopupNo     string  `json:"topup_no"`     // Unique reference number for the top-up transaction
	TopupAmount int     `json:"topup_amount"` // Amount added in smallest currency unit (e.g., cents)
	TopupMethod string  `json:"topup_method"` // Payment method used (e.g., "bank_transfer", "credit_card")
	TopupTime   string  `json:"topup_time"`   // Timestamp when the top-up was processed
	CreatedAt   string  `json:"created_at"`   // Timestamp when record was created
	UpdatedAt   string  `json:"updated_at"`   // Timestamp when record was last updated
	DeletedAt   *string `json:"deleted_at"`   // Timestamp when record was soft-deleted (nil if active)
}

type TopupRecordMonthStatusFailed struct {
	Year        string `json:"year"`         // Year in YYYY format
	Month       string `json:"month"`        // Month in MM format
	TotalFailed int    `json:"total_failed"` // Count of failed top-ups in the month
	TotalAmount int    `json:"total_amount"` // Total amount of failed top-up attempts in smallest currency unit
}

type TopupRecordMonthStatusSuccess struct {
	Year         string `json:"year"`          // Year in YYYY format
	Month        string `json:"month"`         // Month in MM format
	TotalSuccess int    `json:"total_success"` // Count of successful top-ups in the month
	TotalAmount  int    `json:"total_amount"`  // Total amount of successful top-ups in smallest currency unit
}

type TopupRecordYearStatusFailed struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalFailed int    `json:"total_failed"` // Count of failed top-ups in the year
	TotalAmount int    `json:"total_amount"` // Total amount of failed top-up attempts in smallest currency unit
}

type TopupRecordYearStatusSuccess struct {
	Year         string `json:"year"`          // Year in YYYY format
	TotalSuccess int    `json:"total_success"` // Count of successful top-ups in the year
	TotalAmount  int    `json:"total_amount"`  // Total amount of successful top-ups in smallest currency unit
}

type TopupYearlyAmount struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalAmount int    `json:"total_amount"` // Total top-up amount for the year in smallest currency unit
}

type TopupYearlyMethod struct {
	Year        string `json:"year"`         // Year in YYYY format
	TopupMethod string `json:"topup_method"` // Payment method used (e.g., "credit_card")
	TotalTopups int    `json:"total_topups"` // Number of top-ups using this method in the year
	TotalAmount int    `json:"total_amount"` // Total amount processed via this method in smallest currency unit
}

type TransactionMonthAmount struct {
	Month       string `json:"month"`        // Month in YYYY-MM format
	TotalAmount int    `json:"total_amount"` // Total transaction amount
}

type TransactionMonthMethod struct {
	Month             string `json:"month"`              // Month in YYYY-MM format
	PaymentMethod     string `json:"payment_method"`     // Payment method used
	TotalTransactions int    `json:"total_transactions"` // Number of transactions
	TotalAmount       int    `json:"total_amount"`       // Total amount processed
}

type TransactionRecord struct {
	ID              int     `json:"id"`               // Unique identifier for the transaction
	CardNumber      string  `json:"card_number"`      // Card number used (typically masked)
	TransactionNo   string  `json:"transaction_no"`   // Unique transaction reference number
	Amount          int     `json:"amount"`           // Transaction amount in smallest currency unit (e.g., cents)
	PaymentMethod   string  `json:"payment_method"`   // Method used (e.g., "credit", "debit", "wallet")
	MerchantID      int     `json:"merchant_id"`      // ID of the merchant receiving payment
	TransactionTime string  `json:"transaction_time"` // Timestamp when transaction occurred
	CreatedAt       string  `json:"created_at"`       // Timestamp when record was created
	UpdatedAt       string  `json:"updated_at"`       // Timestamp when record was last updated
	DeletedAt       *string `json:"deleted_at"`       // Timestamp when record was soft-deleted (nil if active)
}

type TransactionRecordMonthStatusFailed struct {
	Year        string `json:"year"`         // Year in YYYY format
	Month       string `json:"month"`        // Month in MM format
	TotalFailed int    `json:"total_failed"` // Count of failed transactions
	TotalAmount int    `json:"total_amount"` // Total amount of failed attempts
}

type TransactionRecordMonthStatusSuccess struct {
	Year         string `json:"year"`          // Year in YYYY format
	Month        string `json:"month"`         // Month in MM format
	TotalSuccess int    `json:"total_success"` // Count of successful transactions
	TotalAmount  int    `json:"total_amount"`  // Total amount processed successfully
}

type TransactionRecordYearStatusFailed struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalFailed int    `json:"total_failed"` // Count of failed transactions
	TotalAmount int    `json:"total_amount"` // Total amount of failed attempts
}

type TransactionRecordYearStatusSuccess struct {
	Year         string `json:"year"`          // Year in YYYY format
	TotalSuccess int    `json:"total_success"` // Count of successful transactions
	TotalAmount  int    `json:"total_amount"`  // Total amount processed successfully
}

type TransactionYearMethod struct {
	Year              string `json:"year"`               // Year in YYYY format
	PaymentMethod     string `json:"payment_method"`     // Payment method used
	TotalTransactions int    `json:"total_transactions"` // Number of transactions
	TotalAmount       int    `json:"total_amount"`       // Total amount processed
}

type TransactionYearlyAmount struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalAmount int    `json:"total_amount"` // Total transaction amount
}

type TransferMonthAmount struct {
	Month       string `json:"month"`        // Month in YYYY-MM format
	TotalAmount int    `json:"total_amount"` // Total amount transferred
}

type TransferRecord struct {
	ID             int     `json:"id"`              // Unique identifier for the transfer
	TransferNo     string  `json:"transfer_no"`     // Unique transaction reference number
	TransferFrom   string  `json:"transfer_from"`   // Source account/card (typically masked)
	TransferTo     string  `json:"transfer_to"`     // Destination account/card (typically masked)
	TransferAmount int     `json:"transfer_amount"` // Amount transferred in smallest currency unit (e.g., cents)
	TransferTime   string  `json:"transfer_time"`   // Timestamp when transfer was executed
	CreatedAt      string  `json:"created_at"`      // Timestamp when record was created
	UpdatedAt      string  `json:"updated_at"`      // Timestamp when record was last updated
	DeletedAt      *string `json:"deleted_at"`      // Timestamp when record was soft-deleted (nil if active)
}

type TransferRecordMonthStatusFailed struct {
	Year        string `json:"year"`         // Year in YYYY format
	Month       string `json:"month"`        // Month in MM format
	TotalFailed int    `json:"total_failed"` // Count of failed transfer attempts
	TotalAmount int    `json:"total_amount"` // Total amount of failed transfers
}

type TransferRecordMonthStatusSuccess struct {
	Year         string `json:"year"`          // Year in YYYY format
	Month        string `json:"month"`         // Month in MM format
	TotalSuccess int    `json:"total_success"` // Count of successful transfers
	TotalAmount  int    `json:"total_amount"`  // Total amount transferred successfully
}

type TransferRecordYearStatusFailed struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalFailed int    `json:"total_failed"` // Count of failed transfer attempts
	TotalAmount int    `json:"total_amount"` // Total amount of failed transfers
}

type TransferRecordYearStatusSuccess struct {
	Year         string `json:"year"`          // Year in YYYY format
	TotalSuccess int    `json:"total_success"` // Count of successful transfers
	TotalAmount  int    `json:"total_amount"`  // Total amount transferred successfully
}

type TransferYearAmount struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalAmount int    `json:"total_amount"` // Total amount transferred
}

type UserRecord struct {
	ID              int     `json:"id"`               // Unique identifier for the user
	FirstName       string  `json:"firstname"`        // User's first name
	LastName        string  `json:"lastname"`         // User's last name
	Email           string  `json:"email"`            // User's email address (used for authentication)
	Password        string  `json:"password"`         // Hashed password (should never be exposed in responses)
	VerifiedCode    string  `json:"verified_code"`    // Verification code for email confirmation
	IsVerified      bool    `json:"is_verified"`      // Flag indicating if user has verified their email
	ConfirmPassword string  `json:"confirm_password"` // Used only during registration/update (not stored)
	CreatedAt       string  `json:"created_at"`       // Timestamp when user account was created
	UpdatedAt       string  `json:"updated_at"`       // Timestamp when user account was last updated
	DeletedAt       *string `json:"deleted_at"`       // Timestamp when account was deactivated (nil if active)
}

type UserRoleRecord struct {
	UserRoleID int32      `json:"user_role_id"`         // Unique identifier for the user-role association
	UserID     int32      `json:"user_id"`              // ID of the user being assigned a role
	RoleID     int32      `json:"role_id"`              // ID of the role being assigned
	RoleName   string     `json:"role_name,omitempty"`  // Name of the role (optional, may be populated in joins)
	CreatedAt  time.Time  `json:"created_at"`           // Timestamp when the association was created
	UpdatedAt  time.Time  `json:"updated_at"`           // Timestamp when the association was last updated
	DeletedAt  *time.Time `json:"deleted_at,omitempty"` // Timestamp when association was removed (nil if active)
}

type WithdrawMonthlyAmount struct {
	Month       string `json:"month"`        // Month in YYYY-MM format
	TotalAmount int    `json:"total_amount"` // Total amount withdrawn
}

type WithdrawRecord struct {
	ID             int     `json:"id"`              // Unique identifier for the withdrawal
	WithdrawNo     string  `json:"withdraw_no"`     // Unique withdrawal reference number
	CardNumber     string  `json:"card_number"`     // Card number used (typically masked)
	WithdrawAmount int     `json:"withdraw_amount"` // Amount withdrawn in smallest currency unit (e.g., cents)
	WithdrawTime   string  `json:"withdraw_time"`   // Timestamp when withdrawal was processed
	CreatedAt      string  `json:"created_at"`      // Timestamp when record was created
	UpdatedAt      string  `json:"updated_at"`      // Timestamp when record was last updated
	DeletedAt      *string `json:"deleted_at"`      // Timestamp when record was soft-deleted (nil if active)
}

type WithdrawRecordMonthStatusFailed struct {
	Year        string `json:"year"`         // Year in YYYY format
	Month       string `json:"month"`        // Month in MM format
	TotalFailed int    `json:"total_failed"` // Count of failed withdrawal attempts
	TotalAmount int    `json:"total_amount"` // Total amount of failed withdrawals
}

type WithdrawRecordMonthStatusSuccess struct {
	Year         string `json:"year"`          // Year in YYYY format
	Month        string `json:"month"`         // Month in MM format
	TotalSuccess int    `json:"total_success"` // Count of successful withdrawals
	TotalAmount  int    `json:"total_amount"`  // Total amount withdrawn successfully
}

type WithdrawRecordYearStatusFailed struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalFailed int    `json:"total_failed"` // Count of failed withdrawal attempts
	TotalAmount int    `json:"total_amount"` // Total amount of failed withdrawals
}

type WithdrawRecordYearStatusSuccess struct {
	Year         string `json:"year"`          // Year in YYYY format
	TotalSuccess int    `json:"total_success"` // Count of successful withdrawals
	TotalAmount  int    `json:"total_amount"`  // Total amount withdrawn successfully
}

type WithdrawYearlyAmount struct {
	Year        string `json:"year"`         // Year in YYYY format
	TotalAmount int    `json:"total_amount"` // Total amount withdrawn
}