models

type Category struct {
	ID   string `db:"id,primaryKey,size:36"`
	Name string `db:"name"`
}

type Post struct {
	ID        int64                   `db:"id,primaryKey,autoIncrement"`
	UserID    int64                   `db:"user_id"`
	Title     string                  `db:"title,size:200"`
	Content   string                  `db:"content"`
	Metadata  sqlc.JSON[PostMetadata] `db:"metadata,type:json"` // JSON field with type:json tag
	CreatedAt time.Time               `db:"created_at"`
	UpdatedAt time.Time               `db:"updated_at"`
}

type PostMetadata struct {
	ViewCount    int      `json:"view_count"`
	LikeCount    int      `json:"like_count"`
	Tags         []string `json:"tags"`
	IsFeatured   bool     `json:"is_featured"`
	CategoryName string   `json:"category_name"`
}

type User struct {
	ID        int64     `db:"id,primaryKey,autoIncrement"`
	Username  string    `db:"username,size:100,unique"`
	Email     string    `db:"email,size:255,index"`
	CreatedAt time.Time `db:"created_at"`
}