common

type Book struct {
	Id        int       `db:"id,key,auto"`
	Title     string    `db:"title"`
	Author    string    `db:"author"`
	Published time.Time `db:"published"`
	Version   int       `db:"version,oplock"`
}

type BooksWithInventories struct {
	Book          `db:",rel=books"`
	InventoryPart `db:",rel=inventories"`
}

type CountByAuthor struct {
	Author string `db:"author"`
	Count  int    `db:"count"`
}

type Inventory struct {
	Id            int       `db:"id,key,auto"`
	BookId        int       `db:"book_id"`
	LastInventory time.Time `db:"last_inventory"`
	Counting      int       `db:"counting"`
}

type InventoryPart struct {
	Id       sql.NullInt64 `db:"id"`
	Counting sql.NullInt64 `db:"counting"`
}