locallife_info.go 5.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. package gorm_model
  2. import (
  3. "time"
  4. )
  5. type YounggeeLocalLifeInfo struct {
  6. Id int `gorm:"column:id;type:int(11);primary_key;AUTO_INCREMENT;comment:本地生活表主键ID" json:"id"`
  7. LocalId string `gorm:"column:local_id;type:varchar(10);comment:项目id;NOT NULL" json:"local_id"`
  8. LocalType int64 `gorm:"column:local_type;type:tinyint(4);comment:项目类型,1代表公开项目,2代表定向项目" json:"local_type"`
  9. LocalPlatform int `gorm:"column:local_platform;type:tinyint(4);comment:项目平台,1-7分别代表小红书、抖音、微博、快手、b站、大众点评、知乎" json:"local_platform"`
  10. ServiceChargeRate float64 `gorm:"column:service_charge_rate;type:decimal(10,2);default:0.00;comment:公开服务费率;NOT NULL" json:"service_charge_rate"`
  11. StoreId int `gorm:"column:store_id;type:int(11);comment:关联门店id" json:"store_id"`
  12. StoreRelatedAt *time.Time `gorm:"column:store_related_at;type:timestamp;comment:关联门店时间" json:"store_related_at"`
  13. TeamBuyingId int `gorm:"column:team_buying_id;type:int(11);comment:关联团购id" json:"team_buying_id"`
  14. TeamBuyingRelatedAt *time.Time `gorm:"column:team_buying_related_at;type:timestamp;comment:关联团购时间" json:"team_buying_related_at"`
  15. PromoteBody int `gorm:"column:promote_body;type:int(11);comment:推广主体(1门店 2团购)" json:"promote_body"`
  16. Donate int `gorm:"column:donate;type:int(11);comment:赠送达人套餐(1有赠送 2无赠送)" json:"donate"`
  17. LocalName string `gorm:"column:local_name;type:varchar(50);comment:任务标题" json:"local_name"`
  18. TalentType string `gorm:"column:talent_type;type:text;comment:达人类型(,分隔)" json:"talent_type"`
  19. RecruitDdl *time.Time `gorm:"column:recruit_ddl;type:timestamp;comment:招募截止时间" json:"recruit_ddl"`
  20. TaskForm int `gorm:"column:task_form;type:tinyint(4);comment:任务形式,1-2分别代表线下探店,素材分发" json:"task_form"`
  21. ContentType int `gorm:"column:content_type;type:tinyint(4);comment:内容形式,1代表图文,2代表视频" json:"content_type"`
  22. TaskDetail string `gorm:"column:task_detail;type:varchar(1000);comment:任务详情" json:"task_detail"`
  23. TaskStatus int `gorm:"column:task_status;type:tinyint(4);comment:项目状态,1-10分别代表创建中、待审核、审核通过、招募中、招募完毕、待支付、已支付、执行中、失效、已结案" json:"task_status"`
  24. EnterpriseId string `gorm:"column:enterprise_id;type:varchar(10);comment:所属企业id" json:"enterprise_id"`
  25. SubAccountId int `gorm:"column:sub_account_id;type:int(11);default:0;comment:子账号id;NOT NULL" json:"sub_account_id"`
  26. OperatorType int `gorm:"column:operator_type;type:int(11);comment:创建者类型,1商家主账号,2商家子账号" json:"operator_type"`
  27. ApplyNum int64 `gorm:"column:apply_num;type:int(11);default:0;comment:报名人数;NOT NULL" json:"apply_num"`
  28. RecruitNum int64 `gorm:"column:recruit_num;type:int(11);default:0;comment:已招募人数;NOT NULL" json:"recruit_num"`
  29. SettleNum int64 `gorm:"column:settle_num;type:int(11);default:0;comment:结案人数;NOT NULL" json:"settle_num"`
  30. CreatedAt *time.Time `gorm:"column:created_at;type:timestamp;comment:创建时间" json:"created_at"`
  31. UpdatedAt *time.Time `gorm:"column:updated_at;type:timestamp;comment:修改时间" json:"updated_at"`
  32. AutoFailAt *time.Time `gorm:"column:auto_fail_at;type:timestamp;comment:失效自动处理时间" json:"auto_fail_at"`
  33. AutoTaskId int `gorm:"column:auto_task_id;type:int(11);default:0;comment:定时任务id;NOT NULL" json:"auto_task_id"`
  34. AutoDefaultId int `gorm:"column:auto_default_id;type:int(11);default:0;comment:违约状态id;NOT NULL" json:"auto_default_id"`
  35. PaymentAmount float64 `gorm:"column:payment_amount;type:float;comment:支付金额" json:"payment_amount"`
  36. PayAt *time.Time `gorm:"column:pay_at;type:timestamp;comment:支付时间" json:"pay_at"`
  37. SubmitAt *time.Time `gorm:"column:submit_at;type:timestamp;comment:提交审核时间" json:"submit_at"`
  38. PassAt *time.Time `gorm:"column:pass_at;type:timestamp;comment:审核通过时间" json:"pass_at"`
  39. FinishAt *time.Time `gorm:"column:finish_at;type:timestamp;comment:结案时间" json:"finish_at"`
  40. EstimatedCost float64 `gorm:"column:estimated_cost;type:decimal(10,2);comment:预估成本" json:"estimated_cost"`
  41. SettlementAmount float64 `gorm:"column:settlement_amount;type:decimal(10,2);comment:结算金额" json:"settlement_amount"`
  42. TotalRecruitNum int `gorm:"column:total_recruit_num;type:int(11);comment:此任务各策略招募人数总和" json:"total_recruit_num"`
  43. Tools string `gorm:"column:tools;type:varchar(255);comment:工具选择,1邀约招募 2样品物流 3审稿工具 4作品审查 5数据巡检 6结算账单(,分隔);NOT NULL" json:"tools"`
  44. NeedReview int `gorm:"column:need_review;type:int(11);default:0;comment:待审稿;NOT NULL" json:"need_review"`
  45. NeedQuality int `gorm:"column:need_quality;type:int(11);default:0;comment:待质检;NOT NULL" json:"need_quality"`
  46. NeedCalculate int `gorm:"column:need_calculate;type:int(11);default:0;comment:待结算;NOT NULL" json:"need_calculate"`
  47. InvoiceStatus int `gorm:"column:invoice_status;type:int(11);default:0;comment:开票状态(1开票中 2已开票);NOT NULL" json:"invoice_status"`
  48. NeedPay float64 `gorm:"column:need_pay"`
  49. SettleFlag int `gorm:"column:settle_flag"`
  50. }
  51. func (m *YounggeeLocalLifeInfo) TableName() string {
  52. return "younggee_local_life_info"
  53. }