package model

import "time"

type Reminder struct {
	ID          uint       `json:"id" gorm:"primaryKey"`
	UserID      uint       `json:"user_id" gorm:"not null;index;uniqueIndex:uq_reminder_identity,priority:1"`
	AssetID     uint       `json:"asset_id" gorm:"not null;index;uniqueIndex:uq_reminder_identity,priority:2"`
	RemindAt    time.Time  `json:"remind_at" gorm:"not null;index:idx_reminders_status_remind_at,priority:2;uniqueIndex:uq_reminder_identity,priority:3"`
	Channel     string     `json:"channel" gorm:"size:32;not null;default:in_app;uniqueIndex:uq_reminder_identity,priority:4"`
	Status      string     `json:"status" gorm:"size:16;not null;default:pending;check:status IN ('pending','sending','sent','failed');index:idx_reminders_status_remind_at,priority:1;index:idx_reminders_next_retry_status,priority:2;index:idx_reminders_status_next_retry,priority:1"`
	DedupeKey   string     `json:"dedupe_key" gorm:"size:128;not null;uniqueIndex"`
	RetryCount  int        `json:"retry_count" gorm:"not null;default:0"`
	NextRetryAt *time.Time `json:"next_retry_at,omitempty" gorm:"index:idx_reminders_next_retry_status,priority:1;index:idx_reminders_status_next_retry,priority:2"`
	LastError   string     `json:"last_error" gorm:"size:500"`
	SentAt      *time.Time `json:"sent_at,omitempty"`
	CreatedAt   time.Time  `json:"created_at"`
	UpdatedAt   time.Time  `json:"updated_at"`
}