go 一对多入库的结构设置

最新推荐文章于 2024-05-22 12:25:23 发布

木子火羊

最新推荐文章于 2024-05-22 12:25:23 发布

阅读量93

点赞数

文章标签： golang 开发语言

本文链接：https://blog.csdn.net/lxy_star/article/details/128422167

版权

同时加入两张表

type QuestionnaireDetail struct {
	Id                         int                          `json:"id"`
	FormId                     int                          `json:"formId"`
	Title                      string                       `json:"title"`
	State                      uint                         `json:"state"`
	CreateTime                 uint32                       `json:"create_time"`
	UpdateTime                 uint32                       `json:"update_time"`
	QuestionnaireDetailOptions []QuestionnaireDetailOptions `gorm:"foreignKey:topic_id"`
}
关联 id = topic_id
type QuestionnaireDetailOptions struct {
	//gorm.Model
	Id         int    `json:"id"`
	TopicId    int    `json:"topic_id"`
	Answer     string `json:"answer"`
	Sort       uint   `json:"sort"`
	CreateTime uint32 `json:"create_time"`
}

数据类型

 	[
        {
            "id": 0,
            "formId": 0,
            "title": "题目内容",
            "topicType": 1,
            "sort": 1,
            "state": 0,
            "create_time": 1671788306,
            "update_time": 0,
            "QuestionnaireDetailOptions": []
        },
        {
            "id": 0,
            "formId": 0,
            "title": "1+1=?",
            "topicType": 2,
            "sort": 2,
            "state": 0,
            "create_time": 1671788306,
            "update_time": 0,
            "QuestionnaireDetailOptions": [
                {
                    "id": 0,
                    "topic_id": 0,
                    "answer": "asd",
                    "sort": 1,
                    "create_time": 1671788306
                },
                {
                    "id": 0,
                    "topic_id": 0,
                    "answer": "2",
                    "sort": 2,
                    "create_time": 1671788306
                }
            ]
        }
    ]