data

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

type Flight struct {
	ID             int            `db:"id"`
	Icao           string         `db:"icao"`
	Callsign       sql.NullString `db:"callsign"`
	FirstSeen      time.Time      `db:"first_seen"`
	LastSeen       pq.NullTime    `db:"last_seen"`
	MsgCount       sql.NullInt64  `db:"msg_count"`
	Registration   sql.NullString
	Owner          sql.NullString
	Airline        sql.NullString `db:"airline"`
	TypeCode       sql.NullString `db:"typecode"`
	MfgYear        sql.NullInt64  `db:"year"`
	Mfg            sql.NullString
	Model          sql.NullString
	Icon           string
	IconX          int
	IconY          int
	Category       sql.NullInt64 `db:"category"`
	CategoryString string
}

type Registration struct {
	Icao, Source string
	Registration sql.NullString
	Typecode     sql.NullString
	Mfg          sql.NullString
	Model        sql.NullString
	Owner        sql.NullString
	City         sql.NullString
	State        sql.NullString
	Country      sql.NullString
	Year         sql.NullInt64
}

type TableSize struct {
	TableName  string `db:"table_name"`
	SizeTable  string `db:"table_size"`
	SizeIndex  string `db:"indexes_size"`
	SizeTotal  string `db:"total_size"`
	ApproxRows int64  `db:"rowcount"`
}

type TrackLog struct {
	ID                           int `db:"id"`
	Time                         time.Time
	Latitude, Longitude          sql.NullFloat64
	Heading, Speed, Altitude, Vs sql.NullInt64
	Callsign                     sql.NullString
}