db

type Bin struct {
	Bin_id     int     `gorm:"column:bin_id;primary_key;AUTO_INCREMENT"`
	Status     int     `gorm:"column:status;"`
	Start_time int     `gorm:"column:start_time;"`
	Ip_address string  `gorm:"column:ip_address;"`
	Angel      float32 `gorm:"column:angel;"`
	Temp       float32 `gorm:"column:temp;"`
	Comments   string  `gorm:"column:comment;"`
}

type BinWasteRelation struct {
	Id       int `gorm:"column:id;primary_key;AUTO_INCREMENT"`
	Bin_id   int `gorm:"column:bin_id;"`
	Waste_id int `gorm:"column:waste_id;"`
}

type DBconfig struct {
	User     string
	Password string
	Host     string
	Port     string
	DBname   string
}

type User struct {
	User_id   string `gorm:"column:user_id;primary_key;AUTO_INCREMENT"`
	User_name string `gorm:"column:name;primary_key;"`
	Password  string `gorm:"column:password;"`
	Score     int    `gorm:"column:score;"`
}

type UserBinRelation struct {
	Id      int `gorm:"column:id;primary_key;AUTO_INCREMENT"`
	Bin_id  int `gorm:"column:bin_id;"`
	User_id int `gorm:"column:user_id;"`
}

type Waste struct {
	Waste_id    int    `gorm:"column:id;primary_key;AUTO_INCREMENT"`
	Bin_id      int    `gorm:"column:bin_id;"`
	Waste_name  string `gorm:"column:waste_name;"`
	Create_time string `gorm:"column:create_time;"`
	Type_id     int    `gorm:"column:type_id;"`
	Image       []byte `gorm:"column:image;"`
}