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 table

Table name	Field name	Field type	Primary key	Index #01	Index #02	Index #03	Description	% not Null	Average	Most positive	Most negative	Longest string
Countries	CODE	CHAR	✔				International code	100				3
	H	BOOLEAN					Boolean to permanently hide certain countries	100
	N	VARCHAR_IGNORECASE		ASC			Localized country name	100				26
Defaults	A	TINYINT		ASC				100		72
	B	TINYINT		ASC				100		72
	G	CHAR		ASC				100				1
	ID	TINYINT	✔					100		64
Filter	CHAR1	CHAR						100				1
	ID	INTEGER	✔				Row number for one filter	100		4
	INT1	INTEGER					Some integer value used for filtering	100		6
	INT2	INTEGER						60		3
	REM	VARCHAR					Remarks	20				28
Groupings	CC	CHAR		ASC	ASC		Country code	100				3
	G	CHAR	✔				Group (A-H)	100				1
	N	TINYINT	✔				ID within group (1-4)	100		4
	TID	INTEGER	✔	ASC		ASC	Tournament ID (Year number)	100		6
Matches	A	CHAR	✔		ASC			100				3
	B	CHAR	✔					100				3
	G	CHAR	✔					100				1
	MID	TINYINT		ASC				100		64
	TID	INTEGER	✔	ASC		ASC		100		4
	X	TINYINT						100		8
	Y	TINYINT						100		7
Pairings	A	TINYINT		ASC				100		72
	B	TINYINT		ASC				100		72
	G	CHAR		ASC				100				1
	ID	TINYINT	✔		ASC			100		62
	TID	INTEGER	✔	ASC		ASC		100		1
Tournaments	Description	VARCHAR						83				15
	Host	VARCHAR_IGNORECASE						100				13
	ID	INTEGER	✔					100		6
	Year	SMALLINT						100		2018
vCurrentDefaults	A	TINYINT						100		72
	B	TINYINT						100		72
	G	CHAR						100				1
	ID	TINYINT						100		64
	TID	INTEGER						100		6
vFinalRanking	CC	LONGVARCHAR						100				3
	D	INTEGER						100		4	-12
	R	INTEGER						100		8
	TID	INTEGER						100		4
	X	TINYINT						100		8
	Y	TINYINT						100		12
vFinals	G	CHAR						100				1
	MID	TINYINT						100		62
	Q	LONGVARCHAR						100				3
	TID	INTEGER						100		4
vGroupStageFix	CNT	INTEGER						100		3
	FIX	BOOLEAN						100
	G	CHAR						100				1
	GDIFF	BIGINT						100
	GN	INTEGER						100		72
	MAX	DOUBLE						100	4,09375	9
	PTS	DOUBLE						100	4,09375	9
	R	DOUBLE						100	40979,3	98113	-11988
	Rank	INTEGER						100		4
	T	CHAR						100				3
	TID	INTEGER						100		4
vGroupStageRanking	CNT	INTEGER						100		3
	G	CHAR						100				1
	GAIN	BIGINT						100
	GDIFF	BIGINT						100
	LOSS	BIGINT						100
	MAX	DOUBLE						100	4,09375	9
	PTS	DOUBLE						100	4,09375	9
	R	DOUBLE						100	40979,3	98113	-11988
	Rank	INTEGER						100		4
	T	CHAR						100				3
	TID	INTEGER						100		4
vGroupStageTables	CNT	INTEGER						100		3
	G	CHAR						100				1
	GAIN	BIGINT						100
	GDIFF	BIGINT						100
	LOSS	BIGINT						100
	MAX	DOUBLE						100	4,09375	9
	PTS	DOUBLE						100	4,09375	9
	R	DOUBLE						100	40979,3	98113	-11988
	T	CHAR						100				3
	TID	INTEGER						100		4
vMatchofHonour	G	CHAR						100				1
	MID	TINYINT						100		62
	Q	LONGVARCHAR						100				3
	TID	INTEGER						100		4
vMergeGroupStage	CCA	CHAR						100				3
	CCB	CHAR						100				3
	G	CHAR						100				1
	MID	TINYINT						100		48
	TID	INTEGER						100		6
	X	TINYINT						0
	Y	TINYINT						0
vPointsGoals	G	CHAR						100				1
	GAIN	TINYINT						100		8
	GDIFF	INTEGER						100		8	-8
	LOSS	TINYINT						100		8
	PTS	DOUBLE						100	1,36458333333333	3
	T	CHAR						100				3
	TID	INTEGER						100		4
vRound16	G	CHAR						100				1
	GA	VARCHAR						100				1
	GB	VARCHAR						100				1
	ID	TINYINT						100		56
	TID	INTEGER						100		6