package db
|
|
import (
|
"time"
|
|
"gorm.io/gorm"
|
)
|
|
type BaseEntity struct {
|
ID string `gorm:"primary_key;column:id;type:varchar(255);" json:"id"`
|
CreatedAt time.Time
|
UpdatedAt time.Time
|
DeletedAt gorm.DeletedAt `gorm:"index" json:"-"`
|
}
|
|
type DbPersons struct {
|
BaseEntity
|
TableId string `gorm:"column:table_id"`
|
FaceFeature string `gorm:"column:face_feature"`
|
PersonPicUrl string `gorm:"column:person_pic_url"`
|
PersonName string `gorm:"column:person_name"`
|
Age string `gorm:"column:age"`
|
Sex string `gorm:"column:sex"`
|
IdCard string `gorm:"column:id_card"`
|
PhoneNum string `gorm:"column:phone_num"`
|
MonitorLevel string `gorm:"column:monitor_level"`
|
PicDesc string `gorm:"column:pic_desc"`
|
Reserved string `gorm:"column:reserved"`
|
FromServerId string `gorm:"column:from_server_id"`
|
LastAppearanceTime int64 `gorm:"column:last_appearance_time"`
|
SnapshotCount int `gorm:"column:snapshot_count"`
|
DaysAppeared int `gorm:"column:days_appeared"`
|
Location string `gorm:"column:location"`
|
LastLocation string `gorm:"column:last_location"`
|
FaceAngleYaw int32 `gorm:"column:face_angle_yaw"`
|
FaceAngleRoll int32 `gorm:"column:face_angle_roll"`
|
FaceAnglePitch int32 `gorm:"column:face_angle_pitch"`
|
CommunityID string `gorm:"column:community_id"` // 常住小区 domain unit ID
|
CommunityName string `gorm:"column:community_name"`
|
OrgID string `gorm:"column:org_id"` // 常住派出所 domain unit ID
|
OrgName string `gorm:"column:community"`
|
FrontFaceScore float64 `gorm:"column:front_face_score"`
|
ImageQuality float64 `gorm:"column:image_quality"`
|
SimilarPersonId string `gorm:"column:similar_person_id"`
|
PersonalStatus string `gorm:"column:personal_status"`
|
NonHuman bool `gorm:"column:non_human"` // 非活体（1非多体 0活体）
|
IdPicUrl string `gorm:"column:id_pic_url"`
|
IsDelete int `gorm:"column:is_delete"` // 0 未删除 1已删除
|
FaceUpdateTime int64 `gorm:"column:face_update_time"`
|
}
|
|
func (dp *DbPersons) TableName() string {
|
return "person"
|
}
|
