blog

type Blog struct {
	Metadata       metadata.Metadata `picard:"tablename=blogs"`
	ID             string            `picard:"primary_key,column=id"`
	OrganizationID string            `picard:"multitenancy_key,column=organization_id"`
	Name           string            `picard:"column=name"`
	Tags           []Tag             `picard:"child,foreign_key=BlogID"`
	UserID         string            `picard:"foreign_key,required,related=User,column=user_id"`
	User           User
}

type Tag struct {
	Metadata metadata.Metadata `picard:"tablename=tags"`
	ID       string            `picard:"primary_key,column=id"`
	Name     string            `picard:"column=name"`
	BlogID   string            `picard:"foreign_key,required,related=Blog,column=blog_id"`
	Blog     Blog
}

type User struct {
	Metadata       metadata.Metadata `picard:"tablename=users"`
	ID             string            `picard:"primary_key,column=id"`
	OrganizationID string            `picard:"multitenancy_key,column=organization_id"`
	Name           string            `picard:"column=username"`

	Email    string `picard:"column=email"`
	Password string `picard:"encryptedcolumn=password"`
	Blogs    []Blog `picard:"child,foreign_key=UserID"`
}