package models import "time" // PlatformSchedule 日程主表: yz_platform_schedule type PlatformSchedule struct { ID uint64 `orm:"column(id);pk;auto" json:"id"` Title string `orm:"column(title);size(255)" json:"title"` Content string `orm:"column(content);type(text)" json:"content"` ScheduleTime time.Time `orm:"column(schedule_time);type(datetime)" json:"schedule_time"` UserID uint64 `orm:"column(user_id)" json:"user_id"` } func (m *PlatformSchedule) TableName() string { return "yz_platform_schedule" } // PlatformScheduleReminder 日程提醒主表: yz_platform_schedule_reminder type PlatformScheduleReminder struct { ID uint64 `orm:"column(id);pk;auto" json:"id"` ScheduleID uint64 `orm:"column(schedule_id)" json:"schedule_id"` RemindChannel string `orm:"column(remind_channel);size(20)" json:"remind_channel"` // SMS/EMAIL/BARK/SITE_MSG AdvanceMinutes int `orm:"column(advance_minutes);default(0)" json:"advance_minutes"` RepeatIntervalMinutes int `orm:"column(repeat_interval_minutes);default(0)" json:"repeat_interval_minutes"` NextRemindTime time.Time `orm:"column(next_remind_time);type(datetime)" json:"next_remind_time"` SendCount int `orm:"column(send_count);default(0)" json:"send_count"` MaxSendCount int `orm:"column(max_send_count);default(1)" json:"max_send_count"` AckToken *string `orm:"column(ack_token);size(64);null" json:"ack_token"` AckStatus int8 `orm:"column(ack_status);default(0)" json:"ack_status"` // 0-未确认 1-已确认 AckTime *time.Time `orm:"column(ack_time);type(datetime);null" json:"ack_time"` ReceiverUserID uint64 `orm:"column(receiver_user_id)" json:"receiver_user_id"` ReceiverTarget *string `orm:"column(receiver_target);size(255);null" json:"receiver_target"` RemindStatus int8 `orm:"column(remind_status);default(0)" json:"remind_status"` // 0-待提醒 1-提醒中 2-已结束 ScanLock string `orm:"column(scan_lock);size(64);default('')" json:"scan_lock"` IsDeleted int8 `orm:"column(is_deleted);default(0)" json:"is_deleted"` CreateTime time.Time `orm:"column(create_time);auto_now_add;type(datetime)" json:"create_time"` UpdateTime time.Time `orm:"column(update_time);auto_now;type(datetime)" json:"update_time"` } func (m *PlatformScheduleReminder) TableName() string { return "yz_platform_schedule_reminder" } // PlatformScheduleReminderSendLog 提醒实际发送流水: yz_platform_schedule_reminder_send_log type PlatformScheduleReminderSendLog struct { ID uint64 `orm:"column(id);pk;auto" json:"id"` ReminderID uint64 `orm:"column(reminder_id)" json:"reminder_id"` SendTime time.Time `orm:"column(send_time);type(datetime)" json:"send_time"` SendResult int8 `orm:"column(send_result)" json:"send_result"` // 0-失败 1-成功 FailReason *string `orm:"column(fail_reason);size(255);null" json:"fail_reason"` } func (m *PlatformScheduleReminderSendLog) TableName() string { return "yz_platform_schedule_reminder_send_log" }