添加公租房表

zhangzengfei

2024-09-05 da38fef02e9d37703bc1f68ffbe2c4efd434df86

添加公租房表

 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
}

 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"
}