db

type GeoPolygon struct {
	Points []gormGIS.GeoPoint
}

type Group struct {
	ID           string `gorm:"primary_key"`
	DefaultGroup bool   `gorm:"not null"`
	RegionId     string `gorm:"index;not null"`
	Region       Region `gorm:"ForeignKey:RegionId;AssociationForeignKey:Refer"`
	Users        []User `gorm:"many2many:user_groups"`
	AccessRight  string
	Description  string
}

type Matching struct {
	ID        string  `gorm:"primary_key"`
	RegionId  string  `gorm:"index;not null"`
	Region    Region  `gorm:"ForeignKey:RegionId;AssociationForeignKey:Refer"`
	OfferId   string  `gorm:"index;not null"`
	Offer     Offer   `gorm:"ForeignKey:OfferId;AssociationForeignKey:Refer"`
	RequestId string  `gorm:"index;not null"`
	Request   Request `gorm:"ForeignKey:RequestId;AssociationForeignKey:Refer"`
	Invalid   bool    `gorm:"not null"`
}

type MatchingScore struct {
	RegionID      string  `gorm:"primary_key"`
	Region        Region  `gorm:"ForeignKey:RegionID;AssociationForeignKey:Refer"`
	OfferID       string  `gorm:"primary_key"`
	Offer         Offer   `gorm:"ForeignKey:OfferID;AssociationForeignKey:Refer"`
	RequestID     string  `gorm:"primary_key"`
	Request       Request `gorm:"ForeignKey:RequestID;AssociationForeignKey:Refer"`
	MatchingScore float64 `gorm:"not null"`
	Recommended   bool
}

type Notification struct {
	ID        string    `gorm:"primary_key"`
	Type      string    `gorm:"index;not null"`
	UserID    string    `gorm:"not null"`
	ItemID    string    `gorm:"not null"`
	Read      bool      `gorm:"not null"`
	CreatedAt time.Time `gorm:"not null"`
}

type Offer struct {
	ID             string           `gorm:"primary_key"`
	Name           string           `gorm:"index;not null"`
	UserID         string           `gorm:"index;not null"`
	User           User             `gorm:"ForeignKey:UserID;AssociationForeignKey:Refer"`
	Location       gormGIS.GeoPoint `gorm:"not null" sql:"type:geometry(Geometry,4326)"`
	Radius         float64          `gorm:"not null"`
	Tags           []Tag            `gorm:"many2many:offer_tags"`
	Description    string
	Regions        []Region  `gorm:"many2many:region_offers"`
	ValidityPeriod time.Time `gorm:"not null"`
	Matched        bool      `gorm:"not null"`
	Expired        bool      `gorm:"not null"`
}

type OffersByUUID []Offer

type PhoneNumbers []string

type Region struct {
	ID                    string     `gorm:"primary_key"`
	Name                  string     `gorm:"not null"`
	Boundaries            GeoPolygon `gorm:"not null" sql:"type:geometry(Geometry,4326)"`
	Description           string     `gorm:"not null"`
	Matchings             []Matching
	Offers                []Offer   `gorm:"many2many:region_offers"`
	Requests              []Request `gorm:"many2many:region_requests"`
	RecommendationUpdated bool
}

type Request struct {
	ID             string           `gorm:"primary_key"`
	Name           string           `gorm:"index;not null"`
	UserID         string           `gorm:"index;not null"`
	User           User             `gorm:"ForeignKey:UserID;AssociationForeignKey:Refer"`
	Location       gormGIS.GeoPoint `gorm:"not null" sql:"type:geometry(Geometry,4326)"`
	Radius         float64          `gorm:"not null"`
	Tags           []Tag            `gorm:"many2many:request_tags"`
	Description    string
	Regions        []Region  `gorm:"many2many:region_requests"`
	ValidityPeriod time.Time `gorm:"not null"`
	Matched        bool      `gorm:"not null"`
	Expired        bool      `gorm:"not null"`
}

type RequestsByUUID []Request

type Tag struct {
	Name string `gorm:"primary_key"`
}

type TagsByName []Tag

type User struct {
	ID            string       `gorm:"primary_key"`
	Name          string       `gorm:"not null"`
	PreferredName string       `gorm:"not null"`
	Mail          string       `gorm:"index;not null;unique"`
	MailVerified  bool         `gorm:"not null"`
	PhoneNumbers  PhoneNumbers `gorm:"not null" sql:"type:jsonb"`
	PasswordHash  string       `gorm:"not null;unique"`
	Groups        []Group      `gorm:"many2many:user_groups"`
	Enabled       bool         `gorm:"not null"`
}