models

type Equipment struct {
	Id   uint64 `db:"id"`
	Name string `json:"name" db:"name"`
}

type Event struct {
	Id          uint64    `db:"id"`
	Title       string    `json:"title" db:"title"`
	Description string    `json:"description" db:"description"`
	Start_date  time.Time `json:"start_date" db:"start_date"`
	End_date    time.Time `json:"end_date" db:"end_date"`
	OwnerID     uint64    `json:"owner" db:"owner"`
	ImageID     uint64    `json:"image" db:"image"`
}

type File struct {
	Id          uint64 `json:"-" db:"id"`
	Permission  uint32 `json:"-" db:"permission"` // 0 is public, 1 is private
	OwnerID     uint64 `json:"owner" db:"owner_id"`
	GroupID     uint64 `json:"-" db:"group_id"` // TODO: Could be many groups
	EquipmentID uint64 `json:"-" db:"equipment_id"`

	// file path is ./files/$(file_hash)$(file_name)
	Filename string `json:"filename" db:"file_name"`
	Filehash []byte `json:"-" db:"file_hash"`
}

type Group struct {
	Id   uint64 `json:"-" db:"id"`
	Name string `json:"name" db:"name"`
}

type Inventory struct {
	Id      uint64 `db:"id"`
	GroupID uint64 `json:"groupId" db:"group_id"`
	Name    string `json:"name" db:"name"`
	Amount  uint64 `json:"amount" db:"amount"`
}

type Participant struct {
	Id      uint64 `db:"id"`
	EventID uint64 `json:"eventId" db:"event_id"`
	UserID  uint64 `json:"userId" db:"user_id"`
}

type User struct {
	Id        uint64 `json:"-" db:"id"`
	Email     string `json:"email" db:"email"`
	FirstName string `json:"firstname" db:"first_name"`
	LastName  string `json:"lastname" db:"last_name"`
}

type UserGroup struct {
	Id      uint64 `db:"id"`
	UserId  uint64 `db:"userID"`
	GroupId uint64 `db:"groupID"`
}