go-template/business/model/report_peccancy.go

package model

import (
	"time"
)

/**
CREATE TABLE `report_peccancy` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NOT NULL COMMENT '松果APP端用户ID',
  `op_worker_id` bigint(20) NOT NULL COMMENT '运维用户编号(反馈)',
  `operate_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作处理违章运维人员ID',
  `user_mobile` varchar(15) DEFAULT '' COMMENT '用户手机号',
  `user_name` varchar(15) DEFAULT '' COMMENT '用户名称',
  `city_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户所在城市ID',
  `bike_sn` varchar(15) DEFAULT '' COMMENT '车辆编号',
  `bike_qr_code` varchar(10) NOT NULL DEFAULT '' COMMENT '车辆二维码编号',
  `peccancy_type_id` bigint(20) NOT NULL COMMENT '违章类型id(0表示其他)',
  `template_id` int(11) DEFAULT '0' COMMENT '违章类型模板id',
  `type_name` varchar(2047) DEFAULT '' COMMENT '违章类型',
  `peccancy_type_name` varchar(2047) DEFAULT '' COMMENT '违章影响',
  `discovery_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '发现时间',
  `remark` varchar(1024) DEFAULT NULL COMMENT '举报违章-备注信息',
  `discovery_place` varchar(255) NOT NULL DEFAULT '' COMMENT '发现地点',
  `images` varchar(3072) NOT NULL DEFAULT '' COMMENT '图片，json格式，"[{},{}]"',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '罚金金额',
  `limit_time` int(11) NOT NULL DEFAULT '0' COMMENT '限制用车时间，单位：天(9999代表永久)',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '违章处理状态，0 未处理 1不处罚 2处罚',
  `user_fine_detail_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '罚金记录ID',
  `is_warning` tinyint(4) NOT NULL DEFAULT '0' COMMENT '违章是否为警告 0 否 1 是',
  `warning_type` tinyint(2) DEFAULT '0' COMMENT '警告类型 1 用户初始警告 2 循环周期免罚占比警告 3 单项警告  4 可答题的警告',
  `influence_image` varchar(2048) DEFAULT '' COMMENT '违章实例图片及描述 json[{}]',
  `black_id` int(11) NOT NULL DEFAULT '0' COMMENT '黑名单记录表主键ID',
  `from` tinyint(4) NOT NULL DEFAULT '0' COMMENT '数据来源 0 代表运维正常举报 1 代表从违规骑行得到',
  `follow_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '跟进状态：1,未跟进 2，跟进中 3，误判  4，非误判',
  `follow_method` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1客服抽查跟进 2安全合规抽查跟进 3客户投诉跟进 4系统跟进',
  `pay_fine_status` tinyint(4) DEFAULT '0' COMMENT '缴纳罚金状态 0 否 1 是',
  `is_answer_reduction` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否通过答题免缴 0 否 1 是',
  `user_show` tinyint(4) DEFAULT '1' COMMENT '用户端是否显示 0 否 1 是',
  `create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `operate_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '操作时间',
  `start_cycle_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '循环周期开始时间',
  `end_cycle_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '循环周期结束时间',
  PRIMARY KEY (`id`),
  KEY `idx_cid_bsn` (`city_id`,`bike_sn`),
  KEY `idx_status_operate_time` (`status`,`operate_time`),
  KEY `idx_status_user_name` (`status`,`user_name`),
  KEY `idx_user_name` (`user_name`),
  KEY `idx_ufid` (`user_fine_detail_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_user_operate_time` (`user_id`,`operate_time`),
  KEY `idx_cityid_discoverytime` (`city_id`,`discovery_time`),
  KEY `idx_discovery_time` (`discovery_time`),
  KEY `idx_opworkerid_createtime` (`op_worker_id`,`create_time`),
  KEY `index_update_time` (`update_time`),
  KEY `idx_bid` (`black_id`),
  KEY `idx_bike_sn` (`bike_sn`)
) ENGINE=InnoDB AUTO_INCREMENT=517412 DEFAULT CHARSET=utf8mb4 COMMENT='举报违章'
*/

type ReportPeccancy struct {
	ID                uint64    `xorm:"pk autoincr id"`
	UserID            uint64    `xorm:"user_id"`
	OpWorkerID        uint64    `xorm:"op_worker_id"`
	OperateID         uint64    `xorm:"operate_id"`
	UserMobile        string    `xorm:"user_mobile"`
	UserName          string    `xorm:"user_name"`
	CityID            uint64    `xorm:"city_id"`
	BikeSn            string    `xorm:"bike_sn"`
	BikeQrCode        string    `xorm:"bike_qr_code"`
	PeccancyTypeID    uint64    `xorm:"peccancy_type_id"`
	TemplateID        int       `xorm:"template_id"`
	TypeName          string    `xorm:"type_name"`
	PeccancyTypeName  string    `xorm:"peccancy_type_name"`
	DiscoveryTime     time.Time `xorm:"discovery_time"`
	Remark            string    `xorm:"remark"`
	DiscoveryPlace    string    `xorm:"discovery_place"`
	Images            string    `xorm:"images"`
	Amount            int       `xorm:"amount"`
	LimitTime         int       `xorm:"limit_time"`
	Status            uint8     `xorm:"status"`
	UserFineDetailID  uint64    `xorm:"user_fine_detail_id"`
	IsWarning         uint8     `xorm:"is_warning"`
	WarningType       uint8     `xorm:"warning_type"`
	InfluenceImage    string    `xorm:"influence_image"`
	BlackID           int       `xorm:"black_id"`
	From              uint8     `xorm:"from"`
	FollowType        uint8     `xorm:"follow_type"`
	FollowMethod      uint8     `xorm:"follow_method"`
	PayFineStatus     uint8     `xorm:"pay_fine_status"`
	IsAnswerReduction uint8     `xorm:"is_answer_reduction"`
	UserShow          uint8     `xorm:"user_show"`
	CreateTime        time.Time `xorm:"created create_time"`
	UpdateTime        time.Time `xorm:"updated update_time"`
	OperateTime       time.Time `xorm:"operate_time"`
	StartCycleTime    time.Time `xorm:"start_cycle_time"`
	EndCycleTime      time.Time `xorm:"end_cycle_time"`
}

func (*ReportPeccancy) TableName() string {
	return "report_peccancy"
}