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{} }