database

type BookStore struct {
	BookstoreID uint
	Location    string
	CreatedAt   time.Time
	UpdatedAt   time.Time
	DeletedAt   *time.Time
}

type BundleDetail struct {
	BundleID  uint
	BookID    int
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt *time.Time
}

type BundleMaster struct {
	ID         uint `gorm:"AUTO_INCREMENT"`
	BundleName string
	Note       string
	CreatedAt  time.Time
	UpdatedAt  time.Time
	DeletedAt  *time.Time
}

type Product struct {
	ID              uint
	ProductCategory string
	ProductName     string
	Price           string
	Good            bool
	LongTerm        bool
	Risk            bool
	Due             time.Time
	CreatedAt       time.Time
	UpdatedAt       time.Time
	DeletedAt       *time.Time
}

type Products []Product

type RecommendBook struct {
	RecommendID uint
	BookID      uint
	CreatedAt   time.Time
	UpdatedAt   time.Time
	DeletedAt   *time.Time
}

type RecommendBundle struct {
	RecommendID uint
	BundleID    uint
	CreatedAt   time.Time
	UpdatedAt   time.Time
	DeletedAt   *time.Time
}

type RecommendMaster struct {
	ID            uint `gorm:"AUTO_INCREMENT"`
	RecommendName string
	BookstoreID   uint
	Capacity      uint
	DayLow        uint
	DayHigh       uint
	WeekLow       uint
	WeekHigh      uint
	MonthLow      uint
	MonthHigh     uint
	StackLow      uint
	StackHigh     uint
	StockLow      uint
	StockHigh     uint
	CreatedAt     time.Time
	UpdatedAt     time.Time
	DeletedAt     *time.Time
}

type SalesStatus struct {
	ProductID   uint
	BookstoreID uint
	Day         uint
	Week        uint
	Month       uint
	CreatedAt   time.Time
	UpdatedAt   time.Time
	DeletedAt   *time.Time
}

type StoreStatus struct {
	ProductID   uint
	BookstoreID uint
	Stack       uint
	Stock       uint
	CreatedAt   time.Time
	UpdatedAt   time.Time
	DeletedAt   *time.Time
}