model

type AllowedEmail struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;colum:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`
	UpdatedAt time.Time  `gorm:"not null;column:updated_at"`
	Email     string     `gorm:"type:varchar();not null;column:email"`
}

type AuthProvider struct {
	ID *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`

	UserID   uuid.UUID `gorm:"type:uuid;not null;column:user_id"`
	Provider string    `gorm:"type:varchar(50);not null;column:provider"`

	ProviderUserID *string `gorm:"type:varchar(255);column:provider_user_id"`
	PasswordHash   *string `gorm:"type:varchar(255);column:password_hash"`

	CreatedAt time.Time `gorm:"not null;column:created_at"`
	UpdatedAt time.Time `gorm:"not null;column:updated_at"`
}

type Challenge struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`
	UpdatedAt time.Time  `gorm:"not null;column:updated_at"`

	Purpose string `gorm:"type:varchar(64);not null;column:purpose"`
	Email   string `gorm:"type:varchar(255);not null;column:email"`

	ExpiresAt    time.Time  `gorm:"not null;column:expires_at"`
	ConsumedAt   *time.Time `gorm:"column:consumed_at"`
	AttemptCount int        `gorm:"not null;column:attempt_count"`
	MaxAttempts  int        `gorm:"not null;column:max_attempts"`

	ResendCount int        `gorm:"not null;column:resend_count"`
	MaxResends  int        `gorm:"not null;column:max_resends"`
	LastSentAt  *time.Time `gorm:"column:last_sent_at"`
}

type EmailJob struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`
	UpdatedAt time.Time  `gorm:"not null;column:updated_at"`

	ChallengeID  *uuid.UUID `gorm:"type:uuid;column:challenge_id"`
	ToEmail      string     `gorm:"type:varchar(255);not null;column:to_email"`
	Template     string     `gorm:"type:varchar(64);not null;column:template"`
	TemplateData []byte     `gorm:"type:jsonb;column:template_data"`
	Status       string     `gorm:"type:varchar(32);not null;index;column:status"`

	AttemptCount        int        `gorm:"not null;column:attempt_count"`
	NextAttemptAt       time.Time  `gorm:"not null;column:next_attempt_at"`
	ProcessingStartedAt *time.Time `gorm:"column:processing_started_at"`
	LastError           *string    `gorm:"type:text;column:last_error"`
	SentAt              *time.Time `gorm:"column:sent_at"`
}

type PendingEmailChange struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`

	ChallengeID uuid.UUID `gorm:"type:uuid;not null;column:challenge_id"`
	UserID      uuid.UUID `gorm:"type:uuid;not null;column:user_id"`

	OldEmail string `gorm:"type:varchar(255);not null;column:old_email"`
	NewEmail string `gorm:"type:varchar(255);not null;column:new_email"`
}

type PendingPasswordReset struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`

	ChallengeID  uuid.UUID `gorm:"type:uuid;not null;column:challenge_id"`
	UserID       uuid.UUID `gorm:"type:uuid;not null;column:user_id"`
	PasswordHash string    `gorm:"type:varchar(255);not null;column:password_hash"`
}

type PendingProviderLink struct {
	ID *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`

	UserID      uuid.UUID  `gorm:"type:uuid;not null;column:user_id"`
	SessionID   *uuid.UUID `gorm:"type:uuid;column:session_id"`
	ChallengeID *uuid.UUID `gorm:"type:uuid;column:challenge_id"`
	Provider    string     `gorm:"type:varchar(50);not null;column:provider"`

	ProviderUserID        *string `gorm:"type:varchar(255);column:provider_user_id"`
	ProviderEmail         *string `gorm:"type:varchar(255);column:provider_email"`
	ProviderEmailVerified bool    `gorm:"not null;column:provider_email_verified"`
	Purpose               string  `gorm:"type:varchar(64);not null;column:purpose"`

	ExpiresAt  time.Time  `gorm:"not null;column:expires_at"`
	ConsumedAt *time.Time `gorm:"column:consumed_at"`

	CreatedAt time.Time `gorm:"not null;column:created_at"`
}

type PendingSignupAction struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`

	ChallengeID  uuid.UUID `gorm:"type:uuid;not null;column:challenge_id"`
	Email        string    `gorm:"type:varchar(255);not null;column:email"`
	Username     string    `gorm:"type:varchar(255);not null;column:username"`
	PasswordHash string    `gorm:"type:varchar(255);not null;column:password_hash"`
}

type RefreshToken struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`

	SessionID uuid.UUID `gorm:"type:uuid;not null;column:session_id"`

	TokenHash string `gorm:"type:varchar(512);not null;column:token_hash"`

	ExpiresAt  time.Time  `gorm:"not null;column:expires_at"`
	ConsumedAt *time.Time `gorm:"column:consumed_at"`
}

type Role struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	Name      string     `gorm:"type:text;not null;column:name"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`
}

type Session struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`
	UpdatedAt time.Time  `gorm:"not null;column:updated_at"`

	UserID uuid.UUID `gorm:"type:uuid;not null;column:user_id"`

	ExpiresAt time.Time  `gorm:"not null;column:expires_at"`
	RevokedAt *time.Time `gorm:"column:revoked_at"`

	UserAgent string `gorm:"type:varchar(255);not null;column:user_agent"`
}

type User struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`
	UpdatedAt time.Time  `gorm:"not null;column:updated_at"`

	DisabledAt *time.Time `gorm:"column:disabled_at"`

	Username           string `gorm:"type:varchar(255);not null;column:username"`
	UsernameNormalized string `gorm:"type:varchar(255);not null;column:username_normalized"`
	Email              string `gorm:"type:varchar(255);not null;column:email"`
}

type UserRole struct {
	UserID uuid.UUID `gorm:"type:uuid;not null;column:user_id;primaryKey"`
	RoleID uuid.UUID `gorm:"type:uuid;not null;column:role_id;primaryKey"`

	CreatedAt time.Time `gorm:"not null;column:created_at"`
}

type VerificationCode struct {
	ID        *uuid.UUID `gorm:"type:uuid;primaryKey;column:id;default:gen_random_uuid()"`
	CreatedAt time.Time  `gorm:"not null;column:created_at"`

	ChallengeID uuid.UUID `gorm:"type:uuid;not null;column:challenge_id"`
	CodeHash    string    `gorm:"type:varchar(255);not null;column:code_hash"`
	ExpiresAt   time.Time `gorm:"not null;column:expires_at"`
}