From da38fef02e9d37703bc1f68ffbe2c4efd434df86 Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期四, 05 九月 2024 18:10:53 +0800
Subject: [PATCH] 添加公租房表
---
db/database.go | 3 +++
db/models.go | 15 +++++++++++++++
2 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/db/database.go b/db/database.go
index 01e3bd7..43ef00e 100644
--- a/db/database.go
+++ b/db/database.go
@@ -34,6 +34,9 @@
sqlDb.SetMaxOpenConns(1)
sqlDb.SetConnMaxLifetime(time.Duration(120) * time.Second)
sqlDb.SetConnMaxIdleTime(time.Duration(1800) * time.Second)
+
+ db.AutoMigrate(&PublicHouse{})
+
DB = db
return nil
}
diff --git a/db/models.go b/db/models.go
index d6125f2..b30308a 100644
--- a/db/models.go
+++ b/db/models.go
@@ -155,3 +155,18 @@
CaptureAddress string `json:"captureAddress"`
Direction string `json:"direction"`
}
+
+type PublicHouse struct {
+ ID int `gorm:"primaryKey;autoIncrement" json:"id"` // 涓婚敭ID
+ CommunityID string `gorm:"column:community_id;type:varchar(255)" json:"community_id"` // 灏忓尯ID
+ Applicant string `gorm:"column:applicant;type:varchar(255)" json:"applicant"` // 鐢宠浜�
+ IdCard string `gorm:"column:id_card;type:varchar(50)" json:"id_card"` // 璇佷欢缂栧彿
+ PhoneNumber string `gorm:"column:phone_number;type:varchar(20)" json:"phone_number"` // 鑱旂郴鐢佃瘽
+ Address string `gorm:"column:address;type:varchar(255)" json:"address"` // 鎴垮眿鍦板潃
+ ApplicationTime string `gorm:"column:application_time" json:"application_time"` // 鐢宠鏃堕棿
+ EndTime string `gorm:"column:end_time" json:"end_time"` // 缁撴潫鏃堕棿
+}
+
+func (PublicHouse) TableName() string {
+ return "public_house"
+}
--
Gitblit v1.8.0