Table of contents
Example_Sport

• Tables
  • rel_starter_sport
  • sport
  • starter
• Queries
  • count_agegroup_gender
  • count_agegroup_gender_new
  • registration
  • report_gender
  • sportage
• Forms
  • starter
• Index

List of fields by query

Query name	Field name	Field type	Source table	Source field
count_agegroup_gender	age_group			CASEWHEN( ( YEAR( NOW( ) ) - YEAR( "birthday" ) ) > 19, CEILING( ( YEAR( NOW( ) ) - YEAR( "birthday" ) ) / 10 ) * 10, ( YEAR( NOW( ) ) - YEAR( "birthday" ) ) - MOD( ( YEAR( NOW( ) ) - YEAR( "birthday" ) ), 2 ) )
	gender	VARCHAR	starter (Table)	gender
	quantity			COUNT( "ID" )
count_agegroup_gender_new	age_group			CASEWHEN( ( YEAR( NOW( ) ) - YEAR( "birthday" ) ) > 19, LEFT( "gender" || ' ' || CEILING( ( YEAR( NOW( ) ) - YEAR( "birthday" ) ) / 10 ) * 10, 4 ), "gender" || ' ' || ( YEAR( NOW( ) ) - YEAR( "birthday" ) ) - MOD( ( YEAR( NOW( ) ) - YEAR( "birthday" ) ), 2 ) )
	age_group_sort			CASEWHEN( ( YEAR( NOW( ) ) - YEAR( "birthday" ) ) > 19, CEILING( ( YEAR( NOW( ) ) - YEAR( "birthday" ) ) / 10 ) * 10, ( YEAR( NOW( ) ) - YEAR( "birthday" ) ) - MOD( ( YEAR( NOW( ) ) - YEAR( "birthday" ) ), 2 ) )
	gender	VARCHAR	starter (Table)	gender
	quantity			COUNT( "ID" )
registration	age_group			CASEWHEN( "sportage" > 19, CEILING( "sportage" / 10 ) * 10, "sportage" - MOD( "sportage", 2 ) )
	birthday	DATE	sportage (Query)	birthday
	forename	VARCHAR	sportage (Query)	forename
	gender	VARCHAR	sportage (Query)	gender
	sport	VARCHAR	sportage (Query)	sport
	sportage		sportage (Query)	sportage
	surname	VARCHAR	sportage (Query)	surname
report_gender	gender	VARCHAR	starter (Table)	gender
	gender_full			CASE WHEN "gender" = 'f' THEN 'female' ELSE 'male' END
	quantity			COUNT( "ID" )
sportage	birthday	DATE	starter (Table)	birthday
	forename	VARCHAR	starter (Table)	forename
	gender	VARCHAR	starter (Table)	gender
	sport	VARCHAR	sport (Table)	sport
	sportage			YEAR( NOW( ) ) - YEAR( "birthday" )
	surname	VARCHAR	starter (Table)	surname