sqlite3

type DBEntry struct {
	ID   int       `db:"id"`
	Date time.Time `db:"date"`

	SubmissionID int `db:"submission_id"`
}

type DBSubmission struct {
	ID int `db:"id"`

	SubredditID int `db:"subreddit_id"`

	// Reddit post metadata
	Author    string    `db:"author"`
	Permalink string    `db:"permalink"`
	PostID    string    `db:"post_id"`
	PostedAt  time.Time `db:"created_utc"`
	Score     int       `db:"score"`
	Title     string    `db:"title"`

	// Attached image metadata
	ImageDomain string `db:"domain"`
	ImageURL    string `db:"url"`
	ImageNSFW   bool   `db:"over_18"`

	// Local image metadata
	ImageFilename string `db:"image_filename"`
	ImageHeightPx int    `db:"image_height_px"`
	ImageWidthPx  int    `db:"image_width_px"`
}

type Repository struct {
	// contains filtered or unexported fields
}