database

type CampfireToken struct {
	ID        int       `db:"campfire_token_id"`
	Token     string    `db:"campfire_token_token"`
	ExpiresAt time.Time `db:"campfire_token_expires_at"`
	Email     string    `db:"campfire_token_email"`
}

type Club struct {
	ID                           string          `db:"club_id"`
	Name                         string          `db:"club_name"`
	AvatarURL                    string          `db:"club_avatar_url"`
	CreatorID                    string          `db:"club_creator_id"`
	CreatedByCommunityAmbassador bool            `db:"club_created_by_community_ambassador"`
	ImportedAt                   time.Time       `db:"club_imported_at"`
	RawJSON                      json.RawMessage `db:"club_raw_json"`
	AutoEventImport              bool            `db:"club_auto_event_import"`
	ClubVerificationChannelID    *string         `db:"club_verification_channel_id"`
	LastAutoEventImportedAt      time.Time       `db:"club_last_auto_event_imported_at"`
}

type ClubImportJob struct {
	ID          int                              `db:"club_import_job_id"`
	ClubID      string                           `db:"club_import_job_club_id"`
	CreatedAt   time.Time                        `db:"club_import_job_created_at"`
	CompletedAt time.Time                        `db:"club_import_job_completed_at"`
	LastTriedAt time.Time                        `db:"club_import_job_last_tried_at"`
	Status      ClubImportJobStatus              `db:"club_import_job_status"`
	State       xpgtype.JSON[ClubImportJobState] `db:"club_import_job_state"`
	Error       string                           `db:"club_import_job_error"`
}

type ClubImportJobState struct {
	Events       []EventState `json:"events"`
	EventCursor  *string      `json:"event_cursor"`
	Members      []Member     `json:"members"`
	MemberCursor *string      `json:"member_cursor"`
}

type ClubImportJobStatus string

type ClubImportJobWithClub struct {
	ClubImportJob
	Club
}

type ClubMemberCheckInCount struct {
	MemberID string `db:"member_id"`
	CheckIns int    `db:"check_ins"`
}

type ClubRef struct {
	ID   string `db:"club_id"`
	Name string `db:"club_name"`
}

type ClubStatsEventRow struct {
	Event
	Accepted int `db:"accepted"`
	CheckIns int `db:"check_ins"`
	Declined int `db:"declined"`
	RSVPs    int `db:"rsvps"`
}

type ClubStatsMonthRow struct {
	Month     string `db:"month"`
	Events    int    `db:"events"`
	CheckIns  int    `db:"check_ins"`
	RSVPs     int    `db:"rsvps"`
	NewPeople int    `db:"new_participants"`
}

type ClubStatsTotals struct {
	Events             int       `db:"events"`
	UniqueParticipants int       `db:"unique_participants"`
	TotalRSVPs         int       `db:"total_rsvps"`
	TotalCheckIns      int       `db:"total_check_ins"`
	TotalAccepted      int       `db:"total_accepted"`
	TotalDeclined      int       `db:"total_declined"`
	FirstEventDate     time.Time `db:"first_event_date"`
	LastEventDate      time.Time `db:"last_event_date"`
}

type ClubWithCreator struct {
	Club
	Member
}

type ClubWithEvents struct {
	Club
	Events int `db:"events"`
}

type CodeRequest struct {
	ID        int       `db:"code_request_id"`
	CreatedAt time.Time `db:"code_request_created_at"`
}

type Config struct {
	Host     string `toml:"host"`
	Port     int    `toml:"port"`
	Username string `toml:"username"`
	Password string `toml:"password"`
	Database string `toml:"database"`
	SSLMode  string `toml:"ssl_mode"`
}

type Database struct {
	// contains filtered or unexported fields
}

type DiscordUser struct {
	ID          string    `db:"discord_user_id"`
	Username    string    `db:"discord_user_username"`
	DisplayName string    `db:"discord_user_display_name"`
	AvatarURL   string    `db:"discord_user_avatar_url"`
	ImportedAt  time.Time `db:"discord_user_imported_at"`
}

type Event struct {
	ID                           string          `db:"event_id"`
	Name                         string          `db:"event_name"`
	Details                      string          `db:"event_details"`
	Address                      string          `db:"event_address"`
	Location                     string          `db:"event_location"`
	CreatorID                    string          `db:"event_creator_id"`
	CoverPhotoURL                string          `db:"event_cover_photo_url"`
	Time                         time.Time       `db:"event_time"`
	EndTime                      time.Time       `db:"event_end_time"`
	Finished                     bool            `db:"event_finished"`
	DiscordInterested            int             `db:"event_discord_interested"`
	CreatedByCommunityAmbassador bool            `db:"event_created_by_community_ambassador"`
	CampfireLiveEventID          string          `db:"event_campfire_live_event_id"`
	CampfireLiveEventName        string          `db:"event_campfire_live_event_name"`
	Category                     string          `db:"event_category"`
	ClubID                       string          `db:"event_club_id"`
	ImportedAt                   time.Time       `db:"event_imported_at"`
	RawJSON                      json.RawMessage `db:"event_raw_json"`
	LastAutoImportedAt           time.Time       `db:"event_last_auto_imported_at"`
}

type EventMember struct {
	Member
	EventRSVP
}

type EventNumbers struct {
	CampfireLiveEventID   string `db:"event_campfire_live_event_id"`
	CampfireLiveEventName string `db:"event_campfire_live_event_name"`
	Category              string `db:"event_category"`
	Events                int    `db:"events"`
	CheckIns              int    `db:"check_ins"`
	Accepted              int    `db:"accepted"`
}

type EventRSVP struct {
	EventID    string    `db:"event_rsvp_event_id"`
	MemberID   string    `db:"event_rsvp_member_id"`
	Status     string    `db:"event_rsvp_status"`
	ImportedAt time.Time `db:"event_rsvp_imported_at"`
}

type EventState struct {
	Event   Event       `json:"event"`
	Creator Member      `json:"creator"`
	RSVPs   []EventRSVP `json:"rsvps"`
}

type EventWithCheckIns struct {
	Event
	Accepted int `db:"accepted"`
	CheckIns int `db:"check_ins"`
}

type EventWithClub struct {
	Event
	Club
}

type EventWithCreator struct {
	Event
	Member
}

type LiveEventMemberRSVP struct {
	Member
	ClubID      string `db:"club_id"`
	LiveEventID string `db:"live_event_id"`
	StatusRank  int    `db:"status_rank"`
}

type Member struct {
	ID          string          `db:"member_id"`
	Username    string          `db:"member_username"`
	DisplayName string          `db:"member_display_name"`
	AvatarURL   string          `db:"member_avatar_url"`
	ImportedAt  time.Time       `db:"member_imported_at"`
	RawJSON     json.RawMessage `db:"member_raw_json"`
}

type OldEvent struct {
	ID            string    `db:"id"`
	Name          string    `db:"name"`
	Details       string    `db:"details"`
	CoverPhotoURL string    `db:"cover_photo_url"`
	EventTime     time.Time `db:"event_time"`
	EventEndTime  time.Time `db:"event_end_time"`

	CampfireLiveEventID   string `db:"campfire_live_event_id"`
	CampfireLiveEventName string `db:"campfire_live_event_name"`

	ClubID        string `db:"club_id"`
	ClubName      string `db:"club_name"`
	ClubAvatarURL string `db:"club_avatar_url"`

	RawJSON json.RawMessage `db:"raw_json"`
}

type Raffle struct {
	ID            int            `db:"raffle_id"`
	UserID        string         `db:"raffle_user_id"`
	Events        pq.StringArray `db:"raffle_events"`
	WinnerCount   int            `db:"raffle_winner_count"`
	OnlyCheckedIn bool           `db:"raffle_only_checked_in"`
	SingleEntry   bool           `db:"raffle_single_entry"`
	CreatedAt     time.Time      `db:"raffle_created_at"`
}

type RaffleWinner struct {
	RaffleID  int       `db:"raffle_winner_raffle_id"`
	MemberID  string    `db:"raffle_winner_member_id"`
	Confirmed bool      `db:"raffle_winner_confirmed"`
	Past      bool      `db:"raffle_winner_past"`
	CreatedAt time.Time `db:"raffle_winner_created_at"`
}

type RaffleWinnerWithMember struct {
	RaffleWinner
	Member
	Accepted int `db:"accepted"`
	CheckIns int `db:"check_ins"`
}

type Reward struct {
	ID            int    `db:"reward_id"`
	Name          string `db:"reward_name"`
	Description   string `db:"reward_description"`
	CreatedBy     string `db:"reward_created_by"`
	CreatedAt     string `db:"reward_created_at"`
	TotalCodes    int    `db:"reward_total_codes"`
	RedeemedCodes int    `db:"reward_redeemed_codes"`
}

type RewardCode struct {
	ID           int        `db:"reward_code_id"`
	Code         string     `db:"reward_code_code"`
	RewardID     int        `db:"reward_code_reward_id"`
	ImportedAt   time.Time  `db:"reward_code_imported_at"`
	ImportedBy   string     `db:"reward_code_imported_by"`
	RedeemCode   string     `db:"reward_code_redeem_code"`
	RedeemedAt   *time.Time `db:"reward_code_redeemed_at"`
	RedeemedBy   *string    `db:"reward_code_redeemed_by"`
	VisitedCount int        `db:"reward_code_visited_count"`
}

type RewardCodeWithUser struct {
	RewardCode
	ImportedByUser DiscordUser `db:"imported_by_user"`
	RedeemedByUser struct {
		ID          *string `db:"discord_user_id"`
		Username    *string `db:"discord_user_username"`
		DisplayName *string `db:"discord_user_display_name"`
		AvatarURL   *string `db:"discord_user_avatar_url"`
	} `db:"redeemed_by_user"`
}

type RewardSession struct {
	ID           int       `db:"reward_session_id"`
	CreatedAt    time.Time `db:"reward_session_created_at"`
	ExpiresAt    time.Time `db:"reward_session_expires_at"`
	RewardUserID string    `db:"reward_session_reward_user_id"`
}

type RewardUser struct {
	ID           int       `db:"reward_user_id"`
	CreatedAt    time.Time `db:"reward_user_created_at"`
	MemberID     string    `db:"reward_user_member_id"`
	PasswordHash string    `db:"reward_user_password_hash"`
	PasswordSalt string    `db:"reward_user_password_salt"`
}

type Session struct {
	ID        string    `db:"session_id"`
	CreatedAt time.Time `db:"session_created_at"`
	ExpiresAt time.Time `db:"session_expires_at"`
	UserID    string    `db:"session_user_id"`
	Admin     bool      `db:"session_admin"`
}

type SessionWithUser struct {
	Session
	DiscordUser
}

type TopMember struct {
	Member
	Accepted int `db:"accepted"`
	CheckIns int `db:"check_ins"`
}