From 16b34c939d6790fe6ebe61f8f0e85fe80ee52224 Mon Sep 17 00:00:00 2001 From: sunty <1172534965@qq.com> Date: 星期三, 29 五月 2024 14:44:16 +0800 Subject: [PATCH] 修改准备数据流程,适应较大数据量的操作 --- db/models.go | 26 +++++++++++++------------- 1 files changed, 13 insertions(+), 13 deletions(-) diff --git a/db/models.go b/db/models.go index 6420353..9348dda 100644 --- a/db/models.go +++ b/db/models.go @@ -78,18 +78,19 @@ } type PersonStatus struct { - Id uint `gorm:"column:id;primary_key;auto_increment;not null;"` - OrgId string `gorm:"column:org_id;type:varchar(299);not null;default:''"` // 娲惧嚭鎵�id - CommunityID string `gorm:"uniqueIndex:idx_document_number_community_id;index:community_id_last_appearance_time;column:community_id;type:varchar(299);not null;default:''"` // 灏忓尯id - DocumentNumber string `gorm:"uniqueIndex:idx_document_number_community_id;column:document_number;type:varchar(299);not null;default:''"` // 妗f缂栧彿 - DaysAppeared int `gorm:"column:days_appeared;type:int(11);not null;default:0" json:"daysAppeared"` // 鍑虹幇澶╂暟 - Count int `gorm:"column:count;type:int;not null;default:0"` // 鎶撴媿娆℃暟 - Status string `gorm:"column:status;type:varchar(255);not null;default:''"` //鏍囩 - LastAppearanceTime int64 `gorm:"index:community_id_last_appearance_time;column:last_appearance_time;type:int;not null;default:0" json:"lastAppearanceTime"` //鏈�鍚庡嚭鐜版椂闂� - LastLocation string `gorm:"column:last_location;type:varchar(255);not null;default:''" json:"lastLocation"` //鏈�鍚庡嚭鐜板湴鐐� - FrequentAddress string `gorm:"column:frequent_address;type:varchar(255);not null;default:''" json:"frequentAddress"` //甯稿嚭鐜板湴鐐� - CreatedAt time.Time - UpdatedAt time.Time + Id uint `gorm:"column:id;primary_key;auto_increment;not null;"` + OrgId string `gorm:"column:org_id;type:varchar(299);not null;default:''"` // 娲惧嚭鎵�id + CommunityID string `gorm:"uniqueIndex:idx_document_number_community_id;index:community_id_last_appearance_time;column:community_id;type:varchar(299);not null;default:''"` // 灏忓尯id + DocumentNumber string `gorm:"uniqueIndex:idx_document_number_community_id;column:document_number;type:varchar(299);not null;default:''"` // 妗f缂栧彿 + DaysAppeared int `gorm:"column:days_appeared;type:int(11);not null;default:0" json:"daysAppeared"` // 鍑虹幇澶╂暟 + Count int `gorm:"column:count;type:int;not null;default:0"` // 鎶撴媿娆℃暟 + Status string `gorm:"column:status;type:varchar(255);not null;default:''"` //鏍囩 + LastAppearanceTime int64 `gorm:"index:community_id_last_appearance_time;column:last_appearance_time;type:int;not null;default:0" json:"lastAppearanceTime"` //鏈�鍚庡嚭鐜版椂闂� + LastAppearanceStatusTime int64 `gorm:"column:last_appearance_status_time"` + LastLocation string `gorm:"column:last_location;type:varchar(255);not null;default:''" json:"lastLocation"` //鏈�鍚庡嚭鐜板湴鐐� + FrequentAddress string `gorm:"column:frequent_address;type:varchar(255);not null;default:''" json:"frequentAddress"` //甯稿嚭鐜板湴鐐� + CreatedAt time.Time + UpdatedAt time.Time ////OrgId string `gorm:"column:org_id"` //CommunityID string `gorm:"column:communityID"` //DocumentNumber string `gorm:"column:documentNumber"` @@ -139,7 +140,6 @@ } type CaptureInfo struct { - OrgId string `json:"orgId"` //娲惧嚭鎵�Id DocumentNumber string `json:"documentNumber"` CaptureDays int `json:"captureDays"` //鎶撴媿澶╂暟 OvernightStays int `json:"overnightStays"` //杩囧澶╂暟 -- Gitblit v1.8.0