Table of contents
WorldCup

• Tables
  • Countries
  • Defaults
  • Filter
  • Groupings
  • Matches
  • Pairings
  • Tournaments
  • vCurrentDefaults
  • vFinalRanking
  • vFinals
  • vGroupStageFix
  • vGroupStageRanking
  • vGroupStageTables
  • vMatchofHonour
  • vMergeGroupStage
  • vPointsGoals
  • vRound16
• Queries
  • Finals
  • GroupStageFix
  • GroupStagePairings
  • GroupStageTables
  • MatchOfHonour
  • qCountryPicker
  • qRank_All
  • qRank_Current
  • qReportGroupStage
  • qTournamentPicker
  • Query1
  • Query2
  • Query3
  • Round16
• Forms
  • Group Stage
  • Knock Out Stage
  • Setup/1. Translations and Tournaments
  • Setup/2. Initial Groups
  • Setup/3. Modified Pairings
• Index

List of fields by query

Query name	Field name	Field type	Source table	Source field	Description
Finals	CCA	LONGVARCHAR	vFinals (Table)	Q
	CCB	LONGVARCHAR	vFinals_1	Q
	G	CHAR	vCurrentDefaults (Table)	G
	GA	TINYINT	vCurrentDefaults (Table)	A
	GB	TINYINT	vCurrentDefaults (Table)	B
	ID	TINYINT	vCurrentDefaults (Table)	ID
	TID	INTEGER	vFinals (Table)	TID
GroupStageFix	FIX	BOOLEAN	vGroupStageFix (Table)	FIX
	G	CHAR	vGroupStageFix (Table)	G
	Rank	INTEGER	vGroupStageFix (Table)	Rank
	Status			CASEWHEN( "FIX", '--> GO', '' )
	T	CHAR	vGroupStageFix (Table)	T
	TID	INTEGER	vGroupStageFix (Table)	TID
GroupStagePairings	A	TINYINT	Defaults (Table)	A
	AName	VARCHAR_IGNORECASE	Countries (Table)	N	Localized country name
	B	TINYINT	Defaults (Table)	B
	BName	VARCHAR_IGNORECASE	Countries_1	N
	G	CHAR	Defaults (Table)	G
	ID	TINYINT	Defaults (Table)	ID
	ID1	TINYINT	Defaults (Table)	ID
	TID	INTEGER	Groupings (Table)	TID	Tournament ID (Year number)
GroupStageTables	CNT	INTEGER	vGroupStageRanking (Table)	CNT
	G	CHAR	vGroupStageRanking (Table)	G
	GDIFF	BIGINT	vGroupStageRanking (Table)	GDIFF
	N	VARCHAR_IGNORECASE	Countries (Table)	N	Localized country name
	PTS	DOUBLE	vGroupStageRanking (Table)	PTS
	Rank	INTEGER	vGroupStageRanking (Table)	Rank
	T	CHAR	vGroupStageRanking (Table)	T
	TID	INTEGER	vGroupStageRanking (Table)	TID
MatchOfHonour	CCA	LONGVARCHAR	vMatchofHonour (Table)	Q
	CCB	LONGVARCHAR	vMatchofHonour_1	Q
	G	CHAR	vCurrentDefaults (Table)	G
	GA	TINYINT	vCurrentDefaults (Table)	A
	GB	TINYINT	vCurrentDefaults (Table)	B
	ID	TINYINT	vCurrentDefaults (Table)	ID
	TID	INTEGER	vMatchofHonour (Table)	TID
qCountryPicker	CODE	CHAR	Countries (Table)	CODE	International code
	N	VARCHAR_IGNORECASE	Countries (Table)	N	Localized country name
qRank_All	GAIN			SUM( "vPointsGoals"."GAIN" )
	GDIFF			SUM( "vPointsGoals"."GDIFF" )
	ID	INTEGER	Tournaments (Table)	ID
	LOSS			SUM( - 1 * "LOSS" )
	N	VARCHAR_IGNORECASE	Countries (Table)	N	Localized country name
	PTS			SUM( "vPointsGoals"."PTS" )
	R	INTEGER	vFinalRanking (Table)	R
	T			"Tournaments"."Year" || ' -- ' || "Tournaments"."Host"
qRank_Current	N	VARCHAR_IGNORECASE	Countries (Table)	N	Localized country name
	R	INTEGER	vFinalRanking (Table)	R
qReportGroupStage	Country	VARCHAR_IGNORECASE	Countries (Table)	N	Localized country name
	Goals Diff	BIGINT	vGroupStageRanking (Table)	GDIFF
	Group	CHAR	vGroupStageRanking (Table)	G
	Points	DOUBLE	vGroupStageRanking (Table)	PTS
	Rank	INTEGER	vGroupStageRanking (Table)	Rank
	Tournament			"Tournaments"."Host" || ' ' || "Tournaments"."Year" || ' ' || "Tournaments"."Description"
qTournamentPicker	ID	INTEGER	Tournaments (Table)	ID
	Visible			"Year" || ' - ' || "Host"
Query1	A	TINYINT	G1	A
	B	TINYINT	G1	B
	R			POWER( 2, "F"."ID" ) - 1
Query2	A	TINYINT	Query1 (Query)	A
	B	TINYINT	Query1 (Query)	B
	R		Query1_1	R
Query3	X1			"F1"."ID" - 1
	X2			"F2"."ID" - 1
	X3			"F3"."ID" - 1
	X4			"F4"."ID" - 1
	X5			"F5"."ID" - 1
	X6			"F6"."ID" - 1
Round16	CCA	CHAR	vGroupStageFix_1	T
	CCB	CHAR	vGroupStageFix_2	T
	G	CHAR	vCurrentDefaults (Table)	G
	GA			CHAR( "vCurrentDefaults"."A" )
	GB			CHAR( "vCurrentDefaults"."B" )
	ID	TINYINT	vCurrentDefaults (Table)	ID
	TID	INTEGER	vCurrentDefaults (Table)	TID