magic_admin/model/biz_modules/daytask/dt_music.go

package daytask

// DtMusicGroup 歌单分组表
type DtMusicGroup struct {
	Id        int64  `json:"id" gorm:"column:id;type:bigint;primarykey;comment:歌单ID"`
	Name      string `json:"name" gorm:"column:name;type:varchar(64);not null;comment:歌单名称"`
	Cover     string `json:"cover" gorm:"column:cover;type:varchar(255);comment:封面图"`
	Sort      int    `json:"sort" gorm:"column:sort;type:int;default:0;comment:排序"`
	Status    int8   `json:"status" gorm:"column:status;type:tinyint;default:1;comment:状态: 0=禁用 1=启用"`
	CreatedAt int64  `json:"createdAt" gorm:"column:created_at;type:bigint;autoCreateTime;comment:创建时间"`
	UpdatedAt int64  `json:"updatedAt" gorm:"column:updated_at;type:bigint;autoUpdateTime;comment:更新时间"`
}

func (*DtMusicGroup) TableName() string {
	return "dt_music_group"
}

func NewDtMusicGroup() *DtMusicGroup {
	return &DtMusicGroup{}
}

// DtMusic 歌曲表
type DtMusic struct {
	Id        int64  `json:"id" gorm:"column:id;type:bigint;primarykey;comment:歌曲ID"`
	GroupId   int64  `json:"groupId" gorm:"column:group_id;type:bigint;index:idx_group_id;comment:歌单ID"`
	Title     string `json:"title" gorm:"column:title;type:varchar(100);not null;comment:歌曲名称"`
	Artist    string `json:"artist" gorm:"column:artist;type:varchar(100);comment:歌手"`
	Url       string `json:"url" gorm:"column:url;type:varchar(500);not null;comment:音频文件地址"`
	CoverUrl  string `json:"coverUrl" gorm:"column:cover_url;type:varchar(500);comment:封面图"`
	Duration  int    `json:"duration" gorm:"column:duration;type:int;default:0;comment:时长(秒)"`
	Sort      int    `json:"sort" gorm:"column:sort;type:int;default:0;comment:排序"`
	Status    int8   `json:"status" gorm:"column:status;type:tinyint;default:1;comment:状态: 0=禁用 1=启用"`
	CreatedAt int64  `json:"createdAt" gorm:"column:created_at;type:bigint;autoCreateTime;comment:创建时间"`
	UpdatedAt int64  `json:"updatedAt" gorm:"column:updated_at;type:bigint;autoUpdateTime;comment:更新时间"`
}

func (*DtMusic) TableName() string {
	return "dt_music"
}

func NewDtMusic() *DtMusic {
	return &DtMusic{}
}