57 lines
954 B
Go
57 lines
954 B
Go
package db
|
|
|
|
// enums
|
|
type PackingStage int
|
|
type Category int
|
|
|
|
const (
|
|
Essentials PackingStage = iota
|
|
StageOne
|
|
StageTwo
|
|
StageThree
|
|
)
|
|
|
|
const (
|
|
Bedroom Category = iota
|
|
Bathroom
|
|
Kitchen
|
|
Office
|
|
LivingRoom
|
|
Other
|
|
)
|
|
|
|
// entities
|
|
type Item struct {
|
|
ID int `json:"id"`
|
|
Name string `json:"name"`
|
|
Notes *string `json:"notes"`
|
|
Description *string `json:"description"`
|
|
Stage PackingStage `json:"stage"`
|
|
Category Category `json:"category"`
|
|
}
|
|
|
|
type Box struct {
|
|
ID int `json:"id"`
|
|
Name string `json:"name"`
|
|
Notes *string `json:"notes"`
|
|
Description *string `json:"description"`
|
|
Stage PackingStage `json:"stage"`
|
|
Category Category `json:"category"`
|
|
}
|
|
|
|
// joining tables and derivative data types
|
|
type BoxItem struct {
|
|
ID int
|
|
BoxID int
|
|
ItemID int
|
|
}
|
|
|
|
type BoxItemWithItemInfo struct {
|
|
ID int
|
|
Name string
|
|
Stage PackingStage
|
|
Category Category
|
|
Description *string
|
|
Notes *string
|
|
}
|