spider/internal/model/merchant_clean.go

package model

import (
	"time"

	"gorm.io/datatypes"
)

type MerchantClean struct {
	ID           uint           `gorm:"primaryKey;autoIncrement" json:"id"`
	RawID        *uint          `gorm:"index" json:"raw_id"`
	MerchantName string         `gorm:"size:500" json:"merchant_name"`
	TgUsername   string         `gorm:"uniqueIndex;size:255" json:"tg_username"`
	Website      string         `gorm:"size:2048" json:"website"`
	Email        string         `gorm:"size:255" json:"email"`
	Phone        string         `gorm:"size:100" json:"phone"`
	Industry     string         `gorm:"size:100;index" json:"industry"`
	Status       string         `gorm:"type:enum('valid','invalid','bot','duplicate','group');not null;index" json:"status"`
	TgFirstName  string         `gorm:"size:255" json:"tg_first_name"`
	TgLastName   string         `gorm:"size:255" json:"tg_last_name"`
	IsPremium    bool           `gorm:"default:false" json:"is_premium"`
	LastOnline   *time.Time     `json:"last_online"`
	ActiveLevel  string         `gorm:"type:enum('active','moderate','inactive')" json:"active_level"`
	MemberCount  int            `gorm:"default:0" json:"member_count"`
	QualityScore float64        `gorm:"default:0;index" json:"quality_score"`
	SourceCount  int            `gorm:"default:1" json:"source_count"`
	SourceLinks  datatypes.JSON `gorm:"type:json" json:"source_links"`
	CreatedAt    time.Time      `json:"created_at"`
	UpdatedAt    time.Time      `json:"updated_at"`
}