db

type Account struct {
	ClientKey   string `db:"client_key" json:"clientKey"`
	DisplayName string `db:"display_name" json:"displayName"`
}

type FileData struct {
	FilePath  string
	FileName  string
	IsDir     bool
	Size      uint
	ModTime   time.Time
	FileCount uint
	Md5Hash   string
}

type MessageMetadata struct {
	MessageId    string
	ThreadId     string
	LabelIds     []string
	From         string
	To           string
	Subject      string
	Date         time.Time
	SizeEstimate int64
}

type MessageMetadataRead struct {
	Id           int            `db:"id" json:"message_metadata_id"`
	ScanId       int            `db:"scan_id"`
	MessageId    sql.NullString `db:"message_id"`
	ThreadId     sql.NullString `db:"thread_id"`
	LabelIds     sql.NullString `db:"labels"`
	From         sql.NullString `db:"mail_from"`
	To           sql.NullString `db:"mail_to"`
	Subject      sql.NullString
	Date         sql.NullString
	SizeEstimate sql.NullInt64 `db:"size_estimate"`
}

type PhotosMediaItem struct {
	MediaItemId            string
	ProductUrl             string
	MimeType               string
	Filename               string
	Size                   int64
	FileModTime            time.Time
	Md5hash                string
	ContributorDisplayName string
	AlbumIds               []string
	CameraMake             string
	CameraModel            string
	FocalLength            float32
	FNumber                float32
	Iso                    int
	ExposureTime           string
	Fps                    float32
}

type PhotosMediaItemRead struct {
	Id                     int            `db:"id" json:"photos_media_item_id"`
	ScanId                 int            `db:"scan_id"`
	MediaItemId            string         `db:"media_item_id" json:"media_item_id"`
	ProductUrl             string         `db:"product_url"`
	MimeType               sql.NullString `db:"mime_type"`
	Filename               string
	Size                   sql.NullInt64
	ModifiedTime           sql.NullTime `db:"file_mod_time"`
	Md5hash                sql.NullString
	ContributorDisplayName sql.NullString `db:"contributor_display_name"`
}

type PrivateToken struct {
	Id           int       `db:"id" json:"scan_id"`
	AccessToken  string    `db:"access_token"`
	RefreshToken string    `db:"refresh_token"`
	Client_key   string    `db:"client_key"`
	CreatedOn    time.Time `db:"created_on"`
	DisplayName  string    `db:"display_name"`
	Scope        string    `db:"scope"`
	ExpiresIn    int       `db:"expires_in"`
	TokenType    string    `db:"token_type"`
}

type Scan struct {
	Id            int          `db:"id" json:"scan_id"`
	ScanType      string       `db:"scan_type"`
	CreatedOn     time.Time    `db:"created_on"`
	ScanStartTime time.Time    `db:"scan_start_time"`
	ScanEndTime   sql.NullTime `db:"scan_end_time"`
	Metadata      string       `db:"metadata"`
	Duration      string       `db:"duration"`
}

type ScanData struct {
	Id           int            `db:"id" json:"scan_data_id"`
	Name         sql.NullString `db:"name"`
	Path         sql.NullString `db:"path"`
	Size         sql.NullInt64  `db:"size"`
	ModifiedTime sql.NullTime   `db:"file_mod_time"`
	Md5Hash      sql.NullString `db:"md5hash"`
	IsDir        sql.NullBool   `db:"is_dir"`
	FileCount    sql.NullInt32  `db:"file_count"`
	ScanId       int            `db:"scan_id"`
}