Recursive Belongs-to Model Structure

[muellerluke]

Has anyone been able to achieve a clean, recursive, belongs-to structure? I can't seem to find a solution anywhere.

For some context, I'm using mysql. Here's what I'm working with so far:

package models

import (
	"gorm.io/gorm"
)

type Entity struct {
	gorm.Model
	Level        int     `json:"level"`
	Parent       *Entity `json:"parent" gorm:"foreignKey:ID;references:ID"`
	Name         string  `json:"name"`
	InheritGroup int     `json:"inherit_group"`
}

But I keep getting the error: invalid field found for struct x/internal/database/models.UserEntity's field Parent: define a valid foreign key for relations or implement the Valuer/Scanner interface

Any ideas?