db

type AddUserToTeamParams struct {
	TeamID uuid.NullUUID
	ID     uuid.UUID
}

type CompleteProfileParams struct {
	Email         string
	FirstName     string
	LastName      string
	PhoneNo       pgtype.Text
	Gender        string
	RegNo         *string
	GithubProfile *string
	HostelBlock   *string
	RoomNo        *string
}

type CreateIdeaParams struct {
	ID          uuid.UUID
	Title       string
	Description string
	Track       string
	TeamID      uuid.UUID
	IsSelected  bool
}

type CreateScoreParams struct {
	ID             uuid.UUID
	TeamID         uuid.UUID
	Design         int32
	Implementation int32
	Presentation   int32
	Round          int32
	Innovation     int32
	Teamwork       int32
	Comment        *string
}

type CreateSubmissionParams struct {
	ID          uuid.UUID
	TeamID      uuid.UUID
	Title       string
	Description string
	Track       string
	GithubLink  string
	FigmaLink   string
	OtherLink   string
}

type CreateTeamParams struct {
	ID             uuid.UUID
	Name           string
	NumberOfPeople int32
	RoundQualified pgtype.Int4
	Code           string
	IsBanned       bool
}

type CreateUserParams struct {
	ID                uuid.UUID
	TeamID            uuid.NullUUID
	FirstName         string
	LastName          string
	Email             string
	PhoneNo           pgtype.Text
	Gender            string
	RegNo             *string
	Password          string
	Role              string
	IsLeader          bool
	IsVerified        bool
	IsBanned          bool
	IsProfileComplete bool
}

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type ExportAllTeamsRow struct {
	ID             uuid.UUID
	Name           string
	NumberOfPeople int32
	RoundQualified pgtype.Int4
	Code           string
}

type ExportAllUsersRow struct {
	ID                uuid.UUID
	TeamID            uuid.NullUUID
	FirstName         string
	LastName          string
	Email             string
	PhoneNo           pgtype.Text
	Gender            string
	RegNo             *string
	HostelBlock       *string
	RoomNo            *string
	GithubProfile     *string
	Password          string
	Role              string
	IsLeader          bool
	IsVerified        bool
	IsBanned          bool
	IsProfileComplete bool
	RoundQualified    pgtype.Int4
}

type FindTeamRow struct {
	ID             uuid.UUID
	Name           string
	Code           string
	RoundQualified pgtype.Int4
}

type GetAllIdeasParams struct {
	ID    uuid.UUID
	Limit int32
}

type GetAllUsersParams struct {
	Column1 *string
	ID      uuid.UUID
	Limit   int32
	Column4 interface{}
}

type GetAllUsersRow struct {
	ID                uuid.UUID
	TeamID            uuid.NullUUID
	FirstName         string
	LastName          string
	Email             string
	PhoneNo           pgtype.Text
	Gender            string
	RegNo             *string
	GithubProfile     *string
	Password          string
	Role              string
	IsLeader          bool
	IsVerified        bool
	IsBanned          bool
	IsProfileComplete bool
	IsStarred         bool
	RoomNo            *string
	HostelBlock       *string
	RoundQualified    pgtype.Int4
}

type GetIdeaByTeamIDRow struct {
	ID          uuid.UUID
	Title       string
	Description string
	Track       string
}

type GetIdeasByTrackParams struct {
	Column1 *string
	Column2 uuid.UUID
	Column3 int32
}

type GetLeaderboardWithPaginationParams struct {
	Column1 uuid.UUID
	Column2 string
	Limit   int32
}

type GetLeaderboardWithPaginationRow struct {
	TeamID         uuid.UUID
	Name           string
	Round          int32
	Design         int32
	Implementation int32
	Presentation   int32
	Innovation     int32
	Teamwork       int32
	RoundTotal     int32
	OverallTotal   int64
}

type GetTeamByIdRow struct {
	ID             uuid.UUID
	Name           string
	RoundQualified pgtype.Int4
	Code           string
	IsBanned       bool
	Design         int32
	Implementation int32
	Presentation   int32
	Round          int32
	Title          *string
	Description    *string
	Track          *string
	GithubLink     *string
	FigmaLink      *string
	OtherLink      *string
	Title_2        *string
	Description_2  *string
	Track_2        *string
	IsSelected     pgtype.Bool
}

type GetTeamByTrackRow struct {
	ID             uuid.UUID
	Name           string
	NumberOfPeople int32
	RoundQualified pgtype.Int4
	Code           string
	IsBanned       bool
	Title          *string
	Description    *string
	Track          *string
}

type GetTeamMembersRow struct {
	FirstName     string
	LastName      string
	IsLeader      bool
	GithubProfile *string
	RegNo         *string
	PhoneNo       pgtype.Text
}

type GetTeamUsersRow struct {
	FirstName string
	LastName  string
}

type GetTeamsParams struct {
	Column1 *string
	ID      uuid.UUID
	Limit   int32
}

type GetTeamsRow struct {
	ID             uuid.UUID
	Name           string
	NumberOfPeople int32
	RoundQualified pgtype.Int4
	Code           string
	IsBanned       bool
	Title          *string
	Description    *string
	Track          *string
}

type GetUsersByTeamIdRow struct {
	FirstName string
	LastName  string
	Email     string
	RegNo     *string
	PhoneNo   pgtype.Text
}

type Idea struct {
	ID          uuid.UUID
	Title       string
	Description string
	Track       string
	TeamID      uuid.UUID
	IsSelected  bool
	CreatedAt   pgtype.Timestamp
	UpdatedAt   pgtype.Timestamp
}

type InfoQueryRow struct {
	ID                uuid.UUID
	Name              string
	NumberOfPeople    int32
	RoundQualified    pgtype.Int4
	Code              string
	IsBanned          bool
	ID_2              uuid.UUID
	TeamID            uuid.NullUUID
	FirstName         string
	LastName          string
	Email             string
	PhoneNo           pgtype.Text
	Gender            string
	RegNo             *string
	GithubProfile     *string
	Password          string
	Role              string
	IsLeader          bool
	IsVerified        bool
	IsBanned_2        bool
	IsProfileComplete bool
	IsStarred         bool
	RoomNo            *string
	HostelBlock       *string
}

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

type RemoveUserFromTeamParams struct {
	TeamID uuid.NullUUID
	ID     uuid.UUID
}

type Score struct {
	ID             uuid.UUID
	TeamID         uuid.UUID
	Design         int32
	Implementation int32
	Presentation   int32
	Round          int32
	Innovation     int32
	Teamwork       int32
	Comment        *string
}

type Submission struct {
	ID          uuid.UUID
	Title       string
	Description string
	Track       string
	GithubLink  string
	FigmaLink   string
	OtherLink   string
	TeamID      uuid.UUID
}

type Team struct {
	ID             uuid.UUID
	Name           string
	NumberOfPeople int32
	RoundQualified pgtype.Int4
	Code           string
	IsBanned       bool
}

type UpdateGitHubParams struct {
	GithubProfile *string
	Email         string
}

type UpdateIdeaParams struct {
	TeamID      uuid.UUID
	Title       string
	Description string
	Track       string
}

type UpdateLeaderParams struct {
	IsLeader bool
	ID       uuid.UUID
}

type UpdatePasswordParams struct {
	Email    string
	Password string
}

type UpdateScoreParams struct {
	TeamID         uuid.UUID
	Design         int32
	Implementation int32
	Presentation   int32
	Round          int32
	Innovation     int32
	Teamwork       int32
	Comment        *string
	ID             uuid.UUID
}

type UpdateStarredParams struct {
	IsStarred bool
	Email     string
}

type UpdateSubmissionParams struct {
	TeamID      uuid.UUID
	GithubLink  string
	FigmaLink   string
	OtherLink   string
	Title       string
	Description string
	Track       string
}

type UpdateTeamNameParams struct {
	Name string
	ID   uuid.UUID
}

type UpdateTeamRoundParams struct {
	RoundQualified pgtype.Int4
	ID             uuid.UUID
}

type UpdateUserParams struct {
	ID            uuid.UUID
	FirstName     string
	LastName      string
	PhoneNo       pgtype.Text
	Gender        string
	RegNo         *string
	GithubProfile *string
	HostelBlock   *string
	RoomNo        *string
}

type UpdateUserTeamParams struct {
	TeamID   uuid.NullUUID
	IsLeader bool
	ID       uuid.UUID
}

type User struct {
	ID                uuid.UUID
	TeamID            uuid.NullUUID
	FirstName         string
	LastName          string
	Email             string
	PhoneNo           pgtype.Text
	Gender            string
	RegNo             *string
	GithubProfile     *string
	Password          string
	Role              string
	IsLeader          bool
	IsVerified        bool
	IsBanned          bool
	IsProfileComplete bool
	IsStarred         bool
	RoomNo            *string
	HostelBlock       *string
}