models

type File struct {
	gorms.Model
	CorpID         string `gorm:"uniqueIndex:files_corp_id_md5sum"`
	MD5Sum         string `gorm:"index;uniqueIndex:files_corp_id_md5sum;not null;default:null"`
	OriginalMD5Sum string `gorm:"index"`
	Name           string
	Ext            string
	Width          int
	Height         int
	Length         int
	Size           int
	ContentType    string
	Content        []byte
}

type Media struct {
	gorms.Model
	CorpID         string `gorm:"uniqueIndex:media_corp_id_sequence_index"`
	MessageID      string `gorm:"index"`
	Sequence       uint64 `gorm:"uniqueIndex:media_corp_id_sequence_index"`
	Index          int    `gorm:"uniqueIndex:media_corp_id_sequence_index"`
	FileName       string
	FileSize       int
	Length         int
	Width          int
	Height         int
	FileID         string
	Ext            string
	MD5Sum         string `gorm:"index"`
	OriginalMD5Sum string `gorm:"index"` // 写入的文件 MD5
}

type Message struct {
	gorms.Model
	CorpID      string    `gorm:"uniqueIndex:messages_corp_id_sequence"`
	MessageID   string    `gorm:"unique"`
	Sequence    uint64    `gorm:"uniqueIndex:messages_corp_id_sequence"`
	MessageTime time.Time `gorm:"index"`
	Type        string
	Action      string
	FromID      string
	ToID        string
	RoomID      string
	Raw         datatypes.JSON
	HasMedia    bool
	Medias      []*Media `gorm:"foreignKey:MessageID;references:MessageID"`
}