postgres

type AgendaEntry struct {
	Event *events.GenconEvent
	Tier  string
}

type CalendarEventCluster struct {
	EventId          string
	Title            string
	StartTime        time.Time
	EndTime          time.Time
	GenconUrl        string
	PlannerUrl       string
	ShortCategory    string
	ShortDescription string
	SimilarCount     int
	Location         string
	RoomName         string
	TableNumber      string
}

type CategorySummary struct {
	Name  string
	Code  string
	Count int
}

type EventGroup struct {
	Name              string
	EventId           string
	Description       string
	ShortCategory     string
	GameSystem        string
	OrgGroup          string
	OrgId             int
	Count             int
	TotalTickets      int
	WedEvents         int
	WedTotalTickets   int
	WedTickets        int
	ThursEvents       int
	ThursTotalTickets int
	ThursTickets      int
	FriEvents         int
	FriTotalTickets   int
	FriTickets        int
	SatEvents         int
	SatTotalTickets   int
	SatTickets        int
	SunEvents         int
	SunTotalTickets   int
	SunTickets        int
}

type EventOrgMetadata struct {
	OrgGroup string
	Title    string
	Year     int
	GmNames  string
	Email    string
	Website  string
}

type FamilySyncInfo struct {
	BggId      int64
	GameIds    []int64
	LastUpdate time.Time
}

type Game struct {
	Name          string
	Type          string // Will be game, or expansion
	BggId         int64
	FamilyIds     []int64
	LastUpdate    time.Time
	NumRatings    int64
	AvgRatings    float64
	NumWeights    int64
	AvgWeight     float64
	MinPlayers    int64
	MaxPlayers    int64
	BestPlayers   string
	Description   string
	YearPublished int64
}

type GameFamily struct {
	Name       string
	BggId      int64
	GameIds    []int64
	LastUpdate time.Time
}

type GameSyncInfo struct {
	BggId          int64
	FamilyIds      []int64
	LastUpdate     time.Time
	HasDescription bool
}

type MemberInterest struct {
	Email       string `json:"email"`
	DisplayName string `json:"displayName"`
	Tier        string `json:"tier"`
}

type Organizer struct {
	Id        int64
	Aliases   []string
	NumEvents int64
}

type ParsedQuery struct {
	// TODO(alek): make a significantly more robust query parser
	// add exact match on fields,
	TextQueries     []string
	Year            int
	DaysOfWeek      map[string]bool
	RawQuery        string
	StartBeforeHour int
	StartAfterHour  int
	EndBeforeHour   int
	EndAfterHour    int
	OrgId           int
}

type Party struct {
	Id          int64
	Name        string
	Year        int64
	LeaderEmail string
	ShortCode   string
	Members     []*User
}

type PartyTicket struct {
	TicketId            string    `json:"ticketId"`
	PartyId             int64     `json:"partyId"`
	EventId             string    `json:"eventId"`
	Year                int       `json:"year"`
	PurchaserEmail      string    `json:"purchaserEmail"`
	GenconPurchaserName string    `json:"genconPurchaserName"`
	GenconTicketId      string    `json:"genconTicketId"`
	GenconRecipientName string    `json:"genconRecipientName"`
	GenconRecipientId   string    `json:"genconRecipientId"`
	HolderEmail         string    `json:"holderEmail"`
	HolderDisplayName   string    `json:"holderDisplayName"`
	TicketType          string    `json:"ticketType"`
	TicketStatus        string    `json:"ticketStatus"`
	TransferStatus      string    `json:"transferStatus"`
	CreatedAt           time.Time `json:"createdAt"`
	LastModified        time.Time `json:"lastModified"`
	// Enriched fields from events table
	EventTitle     string `json:"eventTitle,omitempty"`
	EventStartTime string `json:"eventStartTime,omitempty"`
	EventEndTime   string `json:"eventEndTime,omitempty"`
	EventLocation  string `json:"eventLocation,omitempty"`
	RoomName       string `json:"roomName,omitempty"`
	TableNumber    string `json:"tableNumber,omitempty"`
	EventCategory  string `json:"eventCategory,omitempty"`
	EventMapLink   string `json:"eventMapLink,omitempty"`
}

type PersistedEventInfo struct {
	LastModified     time.Time
	TicketsAvailable int
}

type SearchQuery struct {
	Year              int
	CategoryShortCode string
	MinWedTickets     int
	MinThuTickets     int
	MinFriTickets     int
	MinSatTickets     int
	MinSunTickets     int
	RawQuery          string
	OrgId             int
	OnlyFree          bool
	UserEmail         string
}

type SharedInterestGroup struct {
	ClusterId       string           `json:"clusterId"`
	RepEventId      string           `json:"repEventId"`
	AllEventIds     []string         `json:"allEventIds"`
	Title           string           `json:"title"`
	ShortCategory   string           `json:"shortCategory"`
	GameSystem      string           `json:"gameSystem"`
	TotalSessions   int              `json:"totalSessions"`
	TotalTickets    int              `json:"totalTickets"`
	MemberInterests []MemberInterest `json:"memberInterests"`
	GroupScore      int              `json:"groupScore"`
}

type StarredEvent struct {
	EventId    string
	Level      string // "group" or "event"
	Tier       string // "must_have", "very_interested", "somewhat_interested", "not_interested"
	GroupTier  string
	IsOverride bool
}

type TicketSyncInput struct {
	EventId           string `json:"eventId"`
	GenconTicketId    string `json:"genconTicketId"`
	PurchaserGenconId string `json:"purchaserGenconId"`
	PurchaserName     string `json:"purchaserName"`
	RecipientGenconId string `json:"recipientGenconId"`
	RecipientName     string `json:"recipientName"`
	TicketType        string `json:"ticketType"`
	Status            string `json:"status"` // "active" or "returned"
}

type TicketTransfer struct {
	TransferId   string    `json:"transferId"`
	TicketId     string    `json:"ticketId"`
	PartyId      int64     `json:"partyId"`
	FromEmail    string    `json:"fromEmail"`
	ToEmail      string    `json:"toEmail"`
	TransferType string    `json:"transferType"`
	Status       string    `json:"status"`
	CreatedAt    time.Time `json:"createdAt"`
	UpdatedAt    time.Time `json:"updatedAt"`
}

type UpdateStats struct {
	Seen      int
	Inserted  int
	Updated   int
	Deleted   int
	Unchanged int
}

type User struct {
	Email       string
	DisplayName string
	GenconName  string
	GenconId    string
	GenconEmail string
}

type UserStarredEvents struct {
	Email         string
	StarredEvents []StarredEvent
}

type WishlistCacheItem struct {
	EventId   string
	Rank      int
	Status    string
	Reasoning []string
	Score     float64
}

type WishlistConstraint struct {
	DayOfWeek          int // -1 for Every Day, 0-6 for Sun-Sat
	StartHour          int
	StartMinute        int
	EndHour            int
	EndMinute          int
	MinDurationMinutes int // 0 means hard block, > 0 means flexible block
}