bookmark

type Bookmark struct {
	ID                int    `db:"id"                json:"id"`
	URL               string `db:"url"               json:"url"`               // URL of the bookmark.
	Tags              string `db:"tags"              json:"tags"`              // Tags for the bookmark, stored as a comma-separated string.
	Title             string `db:"title"             json:"title"`             // Title of the bookmark, retrieved from the website's metadata.
	Desc              string `db:"desc"              json:"desc"`              // Description of the bookmark.
	Notes             string `db:"notes"             json:"notes"`             // Notes
	CreatedAt         string `db:"created_at"        json:"created_at"`        // Timestamp when the bookmark was created.
	LastVisit         string `db:"last_visit"        json:"last_visit"`        // Timestamp of the last time the bookmark was visited.
	UpdatedAt         string `db:"updated_at"        json:"updated_at"`        // Timestamp of the last time the bookmark record was updated.
	VisitCount        int    `db:"visit_count"       json:"visit_count"`       // The number of times the bookmark has been visited.
	Favorite          bool   `db:"favorite"          json:"favorite"`          // Boolean indicating if the bookmark is marked as a favorite.
	FaviconURL        string `db:"favicon_url"       json:"favicon_url"`       // URL for the bookmark's favicon.
	FaviconLocal      string `db:"favicon_local"     json:"favicon_local"`     // Local path to the cached favicon file.
	Checksum          string `db:"checksum"          json:"checksum"`          // Checksum or hash (URL, Title, Description and Tags)
	ArchiveURL        string `db:"archive_url"       json:"archive_url"`       // Internet Archive URL
	ArchiveTimestamp  string `db:"archive_timestamp" json:"archive_timestamp"` // Internet Archive timestamp
	LastStatusChecked string `db:"last_checked"      json:"last_checked"`      // Last checked timestamp.
	HTTPStatusCode    int    `db:"status_code"       json:"status_code"`       // HTTP status code (200, 404, etc.)
	HTTPStatusText    string `db:"status_text"       json:"status_text"`       // OK, Not Found, etc
	IsActive          bool   `db:"is_active"         json:"is_active"`         // true if the URL is active (200-299)
}

type BookmarkJSON struct {
	// FIX: remove this struct
	ID                int      `json:"id"`
	URL               string   `json:"url"`
	Tags              []string `json:"tags"`
	Title             string   `json:"title"`
	Desc              string   `json:"desc"`
	Notes             string   `json:"notes"`
	CreatedAt         string   `json:"created_at"`
	LastVisit         string   `json:"last_visit"`
	UpdatedAt         string   `json:"updated_at"`
	VisitCount        int      `json:"visit_count"`
	Favorite          bool     `json:"favorite"`
	FaviconURL        string   `json:"favicon_url"`
	FaviconLocal      string   `json:"favicon_local"`
	Checksum          string   `json:"checksum"`
	ArchiveURL        string   `json:"archive_url"`       // Internet Archive URL
	ArchiveTimestamp  string   `json:"archive_timestamp"` // Internet Archive timestamp
	LastStatusChecked string   `json:"last_checked"`      // Last checked timestamp.
	HTTPStatusCode    int      `json:"status_code"`       // HTTP status code (200, 404, etc.)
	HTTPStatusText    string   `json:"status_text"`       // OK, Not Found, etc
	IsActive          bool     `json:"is_active"`         // true if the URL is active (200-299)
}