mysql

type BaseDao struct {
	ID        string `gorm:"column:id;type:varchar(36);primary_key;<-:create"`
	CreatedAt int64  `gorm:"column:created_at;autoCreateTime:milli;<-:create"`
	UpdatedAt int64  `gorm:"column:updated_at;autoUpdateTime:milli"`
	CreatedBy string `gorm:"column:created_by;column:created_by;type:varchar(64);<-:create"`
	UpdatedBy string `gorm:"column:updated_by;column:updated_by;type:varchar(64)"`
}

type LinkDao struct {
	ID           string `gorm:"column:id;type:varchar(36);primary_key;<-:create"`
	UserID       string `gorm:"column:campaign_id;type:varchar(36);not null;<-:create"`
	Code         string `gorm:"column:code;type:varchar(64);not null"`
	OriginalLink string `gorm:"column:original_link;type:text;not null"`
	TrackingLink string `gorm:"column:tracking_link;type:text;not null"`
	ShortLink    string `gorm:"column:short_link;type:text;not null"`
	ShortLinkId  string `gorm:"column:short_link_id;type:varchar(36)"`
	UtmCampaign  string `gorm:"column:utm_campaign;type:text;not null"`
	CreatedAt    int64  `gorm:"autoCreateTime:milli;<-:create"`
	UpdatedAt    int64  `gorm:"autoUpdateTime:milli"`
}

type RewardDao struct {
	CustomerId   string  `gorm:"column:customer_id;type:varchar(36);primaryKey"`
	TotalOrder   int64   `gorm:"column:total_order;type:bigint;not null;default:0"`
	TotalRevenue float64 `gorm:"column:total_revenue;type:double;not null;default:0"`
	RewardTikiXu float64 `gorm:"column:reward_tiki_xu;type:double;not null;default:0"`
	CreatedAt    int64   `gorm:"column:created_at;autoCreateTime:milli;<-:create"`
	UpdatedAt    int64   `gorm:"column:updated_at;autoUpdateTime:milli"`
}