sqlite

type Article struct {
	Model
	Slug        string `gorm:"unique_index;not null"`
	Title       string `gorm:"not null"`
	Description string
	Body        string
	Author      User
	AuthorID    int64
	Comments    []Comment
	Favorites   []User `gorm:"many2many:favorites;"`
	Tags        []Tag  `gorm:"many2many:article_tags;association_autocreate:false"`
}

type Comment struct {
	Model
	Article   Article
	ArticleID int64
	User      User
	UserID    int64
	Body      string
}

type Follow struct {
	Follower    User
	FollowerID  int64 `gorm:"primary_key" sql:"type:int not null"`
	Following   User
	FollowingID int64 `gorm:"primary_key" sql:"type:int not null"`
}

type Model struct {
	ID        int64 `gorm:"primary_key"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt *time.Time `sql:"index"`
}

type Storage struct {
	DB *gorm.DB
}

type Tag struct {
	Model
	Tag      string    `gorm:"unique_index"`
	Articles []Article `gorm:"many2many:article_tags;"`
}

type User struct {
	Model
	Username   string `gorm:"unique_index;not null"`
	Email      string `gorm:"unique_index;not null"`
	Password   string `gorm:"not null"`
	Bio        sql.NullString
	Image      sql.NullString
	Followers  []Follow  `gorm:"foreignkey:FollowingID"`
	Followings []Follow  `gorm:"foreignkey:FollowerID"`
	Favorites  []Article `gorm:"many2many:favorites;"`
}