mixin

type AutoIncrementID struct {
	ID uint32 `gorm:"column:id;primaryKey;autoIncrement" json:"id,omitempty"`
}

type CreateBy struct {
	CreateBy *uint32 `gorm:"column:create_by;index;<-:create" json:"create_by,omitempty"`
}

type CreateTime struct {
	CreateTime *time.Time `gorm:"column:create_time;type:datetime" json:"create_time,omitempty"`
}

type CreateTimestamp struct {
	CreateTime *int64 `gorm:"column:create_time;type:bigint" json:"create_time,omitempty"`
}

type CreatedAt struct {
	CreatedAt *time.Time `gorm:"column:created_at;type:datetime" json:"created_at,omitempty"`
}

type CreatedAtTimestamp struct {
	CreatedAt *int64 `gorm:"column:created_at;type:bigint" json:"created_at,omitempty"`
}

type CreatedBy struct {
	CreatedBy *uint32 `gorm:"column:created_by;index;<-:create" json:"created_by,omitempty"`
}

type CreatorID struct {
	CreatorID *uint32 `gorm:"column:creator_id;index;<-:create" json:"creator_id,omitempty"`
}

type DeleteBy struct {
	DeleteBy *uint32 `gorm:"column:delete_by;index" json:"delete_by,omitempty"`
}

type DeleteTime struct {
	DeleteTime *time.Time `gorm:"column:delete_time;type:datetime;index" json:"delete_time,omitempty"`
}

type DeleteTimestamp struct {
	DeleteTime *int64 `gorm:"column:delete_time;type:bigint;index" json:"delete_time,omitempty"`
}

type DeletedAt struct {
	DeletedAt *time.Time `gorm:"column:deleted_at;type:datetime;index" json:"deleted_at,omitempty"`
}

type DeletedAtTimestamp struct {
	DeletedAt *int64 `gorm:"column:deleted_at;type:bigint;index" json:"deleted_at,omitempty"`
}

type DeletedBy struct {
	DeletedBy *uint32 `gorm:"column:deleted_by;index" json:"deleted_by,omitempty"`
}

type Description struct {
	Description *string `gorm:"column:description;type:text" json:"description,omitempty"`
}

type IsEnabled struct {
	IsEnabled *bool `gorm:"column:is_enabled;type:boolean;default:true;index" json:"is_enabled,omitempty"`
}

type Metadata struct {
	Metadata datatypes.JSONMap `gorm:"column:metadata;type:json" json:"metadata,omitempty"`
}

type OperatorID struct {
	CreatedBy
	UpdatedBy
	DeletedBy
}

type ParentID struct {
	ParentID *uint32 `gorm:"column:parent_id;type:int unsigned;index" json:"parent_id,omitempty"`
}

type Remark struct {
	Remark *string `gorm:"column:remark;type:text" json:"remark,omitempty"`
}

type SnowflakeID struct {
	ID uint64 `gorm:"column:id;primaryKey;autoIncrement:false;type:bigint" json:"id,omitempty"`
}

type SoftDelete struct {
	DeletedAt
	DeletedBy
}

type SortOrder struct {
	SortOrder *int32 `gorm:"column:sort_order;type:int;default:0;index" json:"sort_order,omitempty"`
}

type Status struct {
	Status uint8 `gorm:"column:status;type:tinyint unsigned;default:1;not null;index" json:"status"`
}

type StringID struct {
	ID string `gorm:"column:id;type:varchar(25);primaryKey" json:"id,omitempty"`
}

type SwitchStatus struct {
	Status *string `gorm:"column:status;type:varchar(10);default:ON;index" json:"status,omitempty"`
}

type Tag struct {
	Tags *[]string `gorm:"column:tags;type:json;serializer:json" json:"tags,omitempty"`
}

type TenantID struct {
	TenantID *uint32 `gorm:"column:tenant_id;type:int unsigned;index" json:"tenant_id,omitempty"`
}

type Time struct {
	CreateTime
	UpdateTime
	DeleteTime
}

type TimeAt struct {
	CreatedAt
	UpdatedAt
	DeletedAt
}

type Timestamp struct {
	CreateTimestamp
	UpdateTimestamp
	DeleteTimestamp
}

type TimestampAt struct {
	CreatedAtTimestamp
	UpdatedAtTimestamp
	DeletedAtTimestamp
}

type Tree[T any] struct {
	ParentID

	// Parent 指向父节点（可为 nil）
	Parent *T `gorm:"foreignKey:ParentID;references:ID" json:"parent,omitempty"`

	// Children 列表，使用子表的 parent_id 字段作为外键
	Children []T `gorm:"foreignKey:ParentID;references:ID" json:"children,omitempty"`
}

type UpdateBy struct {
	UpdateBy *uint32 `gorm:"column:update_by;index" json:"update_by,omitempty"`
}

type UpdateTime struct {
	UpdateTime *time.Time `gorm:"column:update_time;type:datetime" json:"update_time,omitempty"`
}

type UpdateTimestamp struct {
	UpdateTime *int64 `gorm:"column:update_time;type:bigint" json:"update_time,omitempty"`
}

type UpdatedAt struct {
	UpdatedAt *time.Time `gorm:"column:updated_at;type:datetime" json:"updated_at,omitempty"`
}

type UpdatedAtTimestamp struct {
	UpdatedAt *int64 `gorm:"column:updated_at;type:bigint" json:"updated_at,omitempty"`
}

type UpdatedBy struct {
	UpdatedBy *uint32 `gorm:"column:updated_by;index" json:"updated_by,omitempty"`
}

type UuidID struct {
	ID uuid.UUID `gorm:"column:id;type:char(36);primaryKey" json:"id,omitempty"`
}

type Version struct {
	Version uint32 `gorm:"column:version;type:int unsigned;default:1;not null;index" json:"version"`
}