models

type EmailVerification struct {
	ID               uint      `gorm:"primary_key"`
	Email            string    `gorm:"type:varchar(255);index:email_expiredat"`
	VerificationCode string    `gorm:"type:char(6)"` // verificationCodeLength
	ExpiredAt        time.Time `gorm:"index:email_expiredat"`
}

type NotificationMethod struct {
	ID        int64  `gorm:"primary_key;auto_increment:false"` // use snowflake for this ID
	Name      string `gorm:"type:varchar(100)"`
	UserID    int64  `gorm:"index"` // foreignkey: User.ID
	Type      string `gorm:"type:varchar(16)"`
	Setting   string // json
	CreatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`
}

type RunningState int64

type Sentry struct {
	ID             int64  `gorm:"primary_key;auto_increment:false"` // use snowflake for this ID
	Name           string `gorm:"type:varchar(100)"`
	UserID         int64  `gorm:"index"` // foreignkey: User.ID
	RunningState   RunningState
	NotificationID int64  // foreignkey: NotificationMethod.ID
	Trigger        string // json
	LastCheckTime  *time.Time
	NextCheckTime  time.Time `gorm:"index"`
	Interval       int
	CheckCount     int
	NotifyCount    int
	LatestImageID  *uint  // foreignkey: SentryImage.ID
	Task           string // json
	CreatedAt      time.Time
	DeletedAt      gorm.DeletedAt `gorm:"index"`
}

type SentryImage struct {
	ID        uint      `gorm:"primary_key"`
	SentryID  int64     `gorm:"index:sentryid_createdat"` // foreignkey: Sentry.ID
	File      string    `gorm:"type:varchar(40)"`
	CreatedAt time.Time `gorm:"index:sentryid_createdat"`
}

type SystemSetting struct {
	Key   string `gorm:"primary_key;type:varchar(64)"`
	Value string
}

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

type Trigger struct {
	SimilarityThreshold float64 `json:"similarityThreshold"`
}

type User struct {
	ID        int64  `gorm:"primary_key;auto_increment:false"` // use snowflake for this ID
	Email     string `gorm:"type:varchar(255);unique_index"`   // lower case
	Password  string `gorm:"type:char(60)"`                    // bcrypt
	Language  string `gorm:"type:varchar(10)"`
	TimeZone  string `gorm:"type:varchar(64)"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`
}