{"columns":[{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"ct_accessed","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"data","type":"mediumtext","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"data_length","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"expires","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"last_accessed","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"last_updated","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"saved_with_cache","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"url","type":"varchar(255)","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"ct_attention","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"ct_games","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"ct_verification_status_complete","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"ct_verification_status_enhanced","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"ct_verification_status_none","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"ct_verification_status_partial","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"last_updated","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"avg_allowed","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"avg_mov","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"avg_scored","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_attention","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_count_in_stats","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_games","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_played","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_seasons","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_team_decision_L","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_team_decision_NULL","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_team_decision_T","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_team_decision_W","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_team_decision_X","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_verification_status_complete","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_verification_status_enhanced","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_verification_status_none","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"ct_verification_status_partial","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"last_updated","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"sum_allowed","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"sum_scored","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"avg_allowed","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"avg_mov","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"avg_scored","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_attention","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_count_in_stats","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_games","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_played","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_team_decision_L","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_team_decision_NULL","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_team_decision_T","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_team_decision_W","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_team_decision_X","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_verification_status_complete","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_verification_status_enhanced","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_verification_status_none","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"ct_verification_status_partial","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"game_type_code","type":"varbinary(4)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"last_updated","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"sum_allowed","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"sum_scored","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"avg_allowed","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"avg_mov","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"avg_scored","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_attention","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_count_in_stats","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_games","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_played","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_team_decision_L","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_team_decision_NULL","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_team_decision_T","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_team_decision_W","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_team_decision_X","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_verification_status_complete","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_verification_status_enhanced","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_verification_status_none","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"ct_verification_status_partial","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"last_updated","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"manual_opponent_name","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"opponent_key","type":"varbinary(120)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"opponent_school_code","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"opponent_section_code","type":"varbinary(8)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"sum_allowed","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"sum_scored","type":"mediumint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"avg_allowed","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"avg_mov","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"avg_scored","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_attention","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_count_in_stats","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_games","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_played","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_team_decision_L","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_team_decision_NULL","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_team_decision_T","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_team_decision_W","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_team_decision_X","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_verification_status_complete","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_verification_status_enhanced","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_verification_status_none","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"ct_verification_status_partial","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"last_updated","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"season_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"sum_allowed","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"sum_scored","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"avg_allowed","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"avg_mov","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"avg_scored","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"conference_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_attention","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_count_in_stats","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_games","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_played","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_team_decision_L","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_team_decision_NULL","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_team_decision_T","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_team_decision_W","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_team_decision_X","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_verification_status_complete","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_verification_status_enhanced","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_verification_status_none","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"ct_verification_status_partial","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"last_updated","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"season_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"sum_allowed","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"sum_scored","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"avg_allowed","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"avg_mov","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"avg_scored","type":"float","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_attention","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_count_in_stats","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_games","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_played","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_team_decision_L","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_team_decision_NULL","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_team_decision_T","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_team_decision_W","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_team_decision_X","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_verification_status_complete","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_verification_status_enhanced","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_verification_status_none","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"ct_verification_status_partial","type":"tinyint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"game_type_code","type":"varbinary(4)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"last_updated","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"season_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"sum_allowed","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"sum_scored","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"ct_attention","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"ct_games","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"ct_verification_status_complete","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"ct_verification_status_enhanced","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"ct_verification_status_none","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"ct_verification_status_partial","type":"smallint unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"last_updated","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"season_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"game_id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"verification_status","type":"enum('None','Partial','Complete','Enhanced')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"verified_attendance","type":"enum('Primary','Secondary','None')","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"verified_date","type":"enum('Primary','Secondary','None')","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"verified_participants","type":"enum('Primary','Secondary','None')","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"verified_score","type":"enum('Primary','Secondary','None')","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"verified_site","type":"enum('Primary','Secondary','None')","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"verified_venue","type":"enum('Primary','Secondary','None')","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"award","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"class","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"grade","type":"varbinary(4)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"height","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"organization","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"player_name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"position","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"season_name","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"selection","type":"varbinary(4)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"source","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"team_name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"weight","type":"varbinary(3)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_authority","name":"authority_code","type":"varbinary(4)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_authority","name":"authority_name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_authority","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"bracket_position","type":"tinyint","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"division","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"informal","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"organization","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"season_name","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"seed","type":"varbinary(24)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"class","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"organization","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"season_name","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"team_name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"conference_champion","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"conference_championship_vacated","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"conference_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"ineligible","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"non_participant","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"remarks","type":"tinytext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"school_code","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"season_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"subconference","type":"varbinary(50)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"suspended","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"team_name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"abbrv","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"conference_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"conference_name","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"cross_count","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"end_season_code","type":"varbinary(8)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"remarks","type":"mediumtext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"start_season_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"status","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_seasons","name":"conference_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_seasons","name":"conference_name","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_seasons","name":"cross_count","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_seasons","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_seasons","name":"remarks","type":"tinytext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_seasons","name":"season_name","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","name":"conference_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","name":"conference_name","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","name":"remarks","type":"mediumtext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","name":"wikipedia_link","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"area","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"division","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"ineligible","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"organization","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"remarks","type":"mediumtext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"school_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"season_name","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"seed","type":"varbinary(24)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_priority","name":"division","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_priority","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_priority","name":"organization","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_priority","name":"priority","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"closed","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"closed_by","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"closed_on","type":"date","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"flag_title","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"notes","type":"varbinary(2000)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"page_link","type":"varbinary(200)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"page_title","type":"varbinary(200)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"reported_by","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"reported_on","type":"date","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_category","name":"description","type":"varbinary(256)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_category","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_category","name":"name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_category","name":"priority","type":"tinyint","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_category","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"announcement","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"answered","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"closed","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"closed_by_id","type":"int unsigned","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"closed_on","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"created_by_id","type":"int unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"created_on","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"flagged","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"locked","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"question","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"soft_deleted","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"topic","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"edit_notes","type":"text","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"open_edit","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"post","type":"mediumtext","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"post_search_text","type":"mediumtext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"posted_by_id","type":"int unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"posted_on","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"soft_deleted","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"topic_id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_bookmarked","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_bookmarked","name":"topic_id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_bookmarked","name":"user_id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","name":"last_viewed","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","name":"topic_id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","name":"total_views","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","name":"user_id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"_original_id","type":"int","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"_paired_id","type":"int","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"allowed","type":"smallint unsigned","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"attendance","type":"int","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"attention","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"count_in_stats","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"game_date","type":"date","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"game_name","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"game_type_code","type":"varbinary(4)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"location","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"manual_opponent_coach_code","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"manual_opponent_decision","type":"enum('W','L','T','X')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"manual_opponent_location","type":"enum('A','H','N')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"manual_opponent_name","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"manual_team_coach_code","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"manual_team_decision","type":"enum('W','L','T','X')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"manual_team_location","type":"enum('A','H','N')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"manual_team_name","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"opponent_admin_decision","type":"enum('f','v','x')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"opponent_admin_decision_date","type":"date","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"opponent_conference_designation","type":"enum('+','-')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"opponent_decision","type":"enum('W','L','T','X')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"opponent_school_code","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"opponent_section_code","type":"varbinary(8)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"overtime","type":"varbinary(2)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"played","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"progress","type":"enum('Canceled','Suspended','Called')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"remarks","type":"text","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"scored","type":"smallint unsigned","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"season_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"site_code","type":"varbinary(8)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"team_admin_decision","type":"enum('f','v','x')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"team_admin_decision_date","type":"date","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"team_conference_designation","type":"enum('+','-')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"team_decision","type":"enum('W','L','T','X')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"team_school_code","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"team_section_code","type":"varbinary(8)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"conference_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"designation","type":"varbinary(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"game_date","type":"date","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"opponent_name","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"school_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"season_name","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"entered_by","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"entered_on","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"game_id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"imageId","type":"int unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"quality","type":"enum('Primary','Secondary')","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"remarks","type":"tinytext","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"verified_attendance","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"verified_date","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"verified_participants","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"verified_score","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"verified_site","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"verified_venue","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"abbrv","type":"varbinary(4)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"count_in_record","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"count_in_regular_season","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"game_bracket","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"game_type","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"game_type_code","type":"varbinary(4)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"playoff_progress_value","type":"smallint","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"country","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"county","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"location","type":"varchar(35)","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"state","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"wikidata_item_id","type":"varchar(12)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"wikipedia_label","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"wikipedia_page_id","type":"varchar(12)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"wikipedia_title","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"wikipedia_url","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"action","type":"varbinary(15)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"changes","type":"mediumtext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"date_only","type":"date","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"entered","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"new_values","type":"mediumtext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"prev_values","type":"mediumtext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"row_number","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"section_code","type":"varbinary(8)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"table","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"user_id","type":"int unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"ip_address","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"last_page_title","type":"varbinary(255)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"last_uri","type":"varbinary(255)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"member_id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"session_end","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"session_id","type":"varbinary(32)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"session_prev_end","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"session_start","type":"datetime","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"college","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"draft_order","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"draft_round","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"draft_team","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"draft_year","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"PFR_id","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"position","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"birth_date","type":"date","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"birth_place","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"college","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"college_class","type":"smallint unsigned","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"draft_order","type":"smallint unsigned","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"draft_round","type":"tinyint unsigned","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"draft_team","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"draft_year","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"PFR_id","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"position","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"school_class","type":"smallint unsigned","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"school_name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"teams","type":"varbinary(200)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"years_active","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"dab","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"date_of_birth","type":"date","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"date_of_death","type":"date","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"expires","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"flag_deceased","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"last_updated","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"person_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"person_formal_name","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"person_name","type":"varchar(100)","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"person_name_dab","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"person_sort_name","type":"varchar(100)","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"place_of_birth","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"place_of_death","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"wikidata_item_id","type":"varchar(12)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"wikipedia_label","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"wikipedia_page_id","type":"varchar(12)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"wikipedia_title","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"end_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"person_code","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"remarks","type":"text","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"start_season_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"person","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"relation","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"rev_relation","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"target","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority","type":"varchar(50)","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"division","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"first","type":"tinyint","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"first_frac_denom","type":"tinyint","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"first_frac_num","type":"tinyint","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"poll_date","type":"date","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"poll_num","type":"tinyint","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"poll_rank","type":"tinyint","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"poll_type","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"season_name","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"team_name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"total","type":"smallint","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"total_frac_denom","type":"tinyint","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"total_frac_num","type":"tinyint","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"country","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"county","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"expires","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"last_updated","type":"datetime","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"state","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"wikidata_item_id","type":"varchar(12)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"wikipedia_label","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"wikipedia_page_id","type":"varchar(12)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"wikipedia_title","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"colors","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"end_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"remarks","type":"tinytext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"start_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"enrollment","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"season_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"source","type":"varchar(100)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"end_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"remarks","type":"tinytext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"start_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"venue","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"address","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"city","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"county","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"county_code","type":"varbinary(4)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"end_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"latitude","type":"double","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"location","type":"varchar(100)","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"longitude","type":"double","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"remarks","type":"tinytext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"start_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"state_code","type":"varbinary(2)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"zip","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"dab","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"end_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"remarks","type":"tinytext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"school_name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"school_name_dab","type":"varbinary(120)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"start_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"end_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"nickname","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"remarks","type":"tinytext","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"start_season_code","type":"varbinary(6)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"predecessor_school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"predecessor_section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"season_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"successor_school_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"successor_section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_seasons","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_seasons","name":"is_complete","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_seasons","name":"no_team","type":"tinyint(1)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_seasons","name":"no_team_notes","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_seasons","name":"school_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_seasons","name":"season_name","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"active","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"season_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"season_name","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","name":"predecessor_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","name":"successor_code","type":"varbinary(6)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"active","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"admin_review","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"default_section","type":"tinyint(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"full_name","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"geo_component","type":"enum('State','County')","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"icon","type":"varbinary(20)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"image","type":"varbinary(50)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"menu_name","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"section_code","type":"varbinary(16)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"short_name","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"subject","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_about","name":"about_entry","type":"mediumtext","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_about","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_about","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","name":"action_call","type":"varchar(60)","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","name":"menu_position","type":"int","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","name":"permission","type":"enum('admin','editor','member','anon')","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","name":"section_code","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"action_call","type":"varchar(60)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"max_parameters","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"menu_position","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"method","type":"varchar(20)","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"min_parameters","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"model","type":"varchar(20)","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"permission","type":"enum('admin','editor','anon')","nullable":false,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_favorite","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_favorite","name":"member_id","type":"int unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_favorite","name":"section_code","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","name":"bookmark_title","type":"varbinary(255)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","name":"bookmark_uri","type":"varbinary(255)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","name":"member_id","type":"int unsigned","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","name":"section_code","type":"varbinary(16)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","name":"imageId","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","name":"pageTitle","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","name":"pageUrl","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","name":"publicationId","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","name":"publishedDate","type":"date","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_publication","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_publication","name":"location","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_publication","name":"publicationCoordinates","type":"point","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_publication","name":"publicationId","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_publication","name":"publicationTitle","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_publication","name":"publicationUrl","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"FIPS_code","type":"char(2)","nullable":true,"collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"HASC","type":"varbinary(5)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"id","type":"tinyint","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"state_abbreviation","type":"varbinary(12)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"state_code","type":"varbinary(2)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"state_name","type":"varbinary(50)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"wikipedia_pageid","type":"int unsigned","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"county_code","type":"varbinary(5)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"county_HASC","type":"varbinary(8)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"county_name","type":"varbinary(40)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"LSAD","type":"varbinary(20)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"state_code","type":"varbinary(2)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"state_HASC","type":"varbinary(5)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"type","type":"varbinary(1)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"wikipedia_pageid","type":"varbinary(12)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","name":"country","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","name":"county","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","name":"entry","type":"varbinary(100)","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","name":"id","type":"int","nullable":false,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","name":"name","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","name":"state","type":"varbinary(100)","nullable":true,"collation":""},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","name":"wikipedia_pageid","type":"varchar(12)","nullable":true,"collation":"utf8mb4_general_ci"}],"indexes":[{"schema":"ghsfhaco_cfbhadb","table":"sa_authority","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_authority","name":"authority_name","size":"16384","column":"authority_name","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_authority","name":"authority_code","size":"16384","column":"authority_code","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"year_school","size":"16384","column":"season_name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"year_school","size":"16384","column":"team_name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"year_school_name_team","size":"16384","column":"season_name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"year_school_name_team","size":"16384","column":"team_name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"year_school_name_team","size":"16384","column":"player_name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"year_school_name_team","size":"16384","column":"selection","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"season","size":"16384","column":"season_name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"class","size":"16384","column":"class","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"selection","size":"16384","column":"selection","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","name":"source","size":"16384","column":"source","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":848,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"season_name_organization_class","size":"49152","column":"season_name","index_type":"btree","cardinality":46,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"season_name_organization_class","size":"49152","column":"organization","index_type":"btree","cardinality":46,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","name":"season_name_organization_class","size":"49152","column":"division","index_type":"btree","cardinality":56,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":30,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"School_season_date_opponent","size":"16384","column":"school_code","index_type":"btree","cardinality":11,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"School_season_date_opponent","size":"16384","column":"season_name","index_type":"btree","cardinality":25,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"School_season_date_opponent","size":"16384","column":"game_date","index_type":"btree","cardinality":30,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"School_season_date_opponent","size":"16384","column":"opponent_name","index_type":"btree","cardinality":30,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"season_name","size":"16384","column":"season_name","index_type":"btree","cardinality":13,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"season_team_code","size":"16384","column":"season_name","index_type":"btree","cardinality":13,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"season_team_code","size":"16384","column":"school_code","index_type":"btree","cardinality":25,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","name":"team_code","size":"16384","column":"school_code","index_type":"btree","cardinality":11,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":74694,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"season_name","size":"2637824","column":"season_name","index_type":"btree","cardinality":138,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"school_code","size":"2637824","column":"school_code","index_type":"btree","cardinality":1064,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"season_school","size":"3686400","column":"season_name","index_type":"btree","cardinality":129,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","name":"season_school","size":"3686400","column":"school_code","index_type":"btree","cardinality":78355,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_priority","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":15,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_priority","name":"organization_class","size":"16384","column":"organization","index_type":"btree","cardinality":5,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_priority","name":"organization_class","size":"16384","column":"division","index_type":"btree","cardinality":15,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"team_name","size":"16384","column":"team_name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"season_name","size":"16384","column":"season_name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"class","size":"16384","column":"class","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","name":"organization","size":"16384","column":"organization","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","name":"name","size":"16384","column":"name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"name","size":"16384","column":"name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","name":"school_name","size":"16384","column":"school_name","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"person_target","size":"16384","column":"person","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"person_target","size":"16384","column":"target","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"person","size":"16384","column":"person","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"relation","size":"16384","column":"relation","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"target","size":"16384","column":"target","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","name":"rev_relation","size":"16384","column":"rev_relation","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":4776,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority_date_team","size":"360448","column":"authority","index_type":"btree","cardinality":2,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority_date_team","size":"360448","column":"poll_date","index_type":"btree","cardinality":141,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority_date_team","size":"360448","column":"team_name","index_type":"btree","cardinality":4543,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"season_name","size":"114688","column":"season_name","index_type":"btree","cardinality":15,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"team_name","size":"147456","column":"team_name","index_type":"btree","cardinality":186,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"rank","size":"98304","column":"poll_rank","index_type":"btree","cardinality":21,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"class","size":"98304","column":"division","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"poll_num","size":"131072","column":"poll_num","index_type":"btree","cardinality":12,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority","size":"163840","column":"authority","index_type":"btree","cardinality":2,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"poll_type","size":"163840","column":"poll_type","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"poll_date","size":"114688","column":"poll_date","index_type":"btree","cardinality":136,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"season_team","size":"360448","column":"season_name","index_type":"btree","cardinality":15,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"season_team","size":"360448","column":"team_name","index_type":"btree","cardinality":898,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"season_team","size":"360448","column":"authority","index_type":"btree","cardinality":947,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority_date","size":"196608","column":"authority","index_type":"btree","cardinality":2,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority_date","size":"196608","column":"poll_date","index_type":"btree","cardinality":141,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority_team","size":"294912","column":"authority","index_type":"btree","cardinality":2,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority_team","size":"294912","column":"team_name","index_type":"btree","cardinality":240,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority_season","size":"212992","column":"authority","index_type":"btree","cardinality":2,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","name":"authority_season","size":"212992","column":"season_name","index_type":"btree","cardinality":16,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_seasons","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":9327,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_category","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_category","name":"forum_name","size":"16384","column":"section_code","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_category","name":"forum_name","size":"16384","column":"name","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"topic_id","size":"16384","column":"topic_id","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","name":"sa_forum_category__idx_posted_on","size":"16384","column":"posted_on","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","name":"user_topic","size":"16384","column":"user_id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","name":"user_topic","size":"16384","column":"topic_id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","name":"topic_id","size":"16384","column":"topic_id","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_bookmarked","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_bookmarked","name":"user_topic","size":"16384","column":"user_id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_bookmarked","name":"user_topic","size":"16384","column":"topic_id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_bookmarked","name":"topic_id","size":"16384","column":"topic_id","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"category_topic","size":"16384","column":"section_code","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"category_topic","size":"16384","column":"topic","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"sa_forum_category__idx_soft_deleted_category_id","size":"16384","column":"soft_deleted","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"sa_forum_category__idx_soft_deleted_category_id","size":"16384","column":"section_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"sa_forum_category__idx_id_category_id","size":"16384","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","name":"sa_forum_category__idx_id_category_id","size":"16384","column":"section_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":9,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"game_type","size":"16384","column":"game_type","index_type":"btree","cardinality":9,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"game_type_code","size":"16384","column":"game_type_code","index_type":"btree","cardinality":9,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","name":"playoff_progress_value","size":"16384","column":"playoff_progress_value","index_type":"btree","cardinality":9,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"sa_log_idx_entered","size":"16384","column":"entered","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"date_only","size":"16384","column":"date_only","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","name":"sa_log_idx_state_code","size":"16384","column":"section_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_seasons","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":14,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":141,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","name":"sa_season_lineage_idx_section_predecessor","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","name":"sa_season_lineage_idx_section_predecessor","size":"16384","column":"predecessor_code","index_type":"btree","cardinality":141,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","name":"sa_season_lineage_idx_section_sucessor","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","name":"sa_season_lineage_idx_section_sucessor","size":"16384","column":"successor_code","index_type":"btree","cardinality":141,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_publication","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_publication","name":"publicationId","size":"16384","column":"publicationId","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_about","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_about","name":"section_code","size":"16384","column":"section_code","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_favorite","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":3,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_favorite","name":"sa_section_favorite_idx_section_code_user","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_favorite","name":"sa_section_favorite_idx_section_code_user","size":"16384","column":"member_id","index_type":"btree","cardinality":3,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_favorite","name":"sa_section_favorite_idx_member_id","size":"16384","column":"member_id","index_type":"btree","cardinality":3,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_favorite","name":"sa_section_favorite_idx_section_code","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":35,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","name":"sa_section_page_bookmark_idx_member_bookmark","size":"16384","column":"member_id","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","name":"sa_section_page_bookmark_idx_member_bookmark","size":"16384","column":"bookmark_uri","index_type":"btree","cardinality":35,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","name":"sa_section_page_bookmark_idx_section_code","size":"16384","column":"section_code","index_type":"btree","cardinality":2,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":54,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"sa_section_idx_full_name","size":"16384","column":"full_name","index_type":"btree","cardinality":54,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"sa_section_idx_short_name","size":"16384","column":"short_name","index_type":"btree","cardinality":54,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","name":"sa_section_idx_section_code","size":"16384","column":"section_code","index_type":"btree","cardinality":54,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","name":"imageId","size":"16384","column":"imageId","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","name":"sa_source_newspaperdotcom_page_ibfk","size":"16384","column":"publicationId","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":2,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"game_id_newspaperdotcom_image_id","size":"16384","column":"game_id","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"game_id_newspaperdotcom_image_id","size":"16384","column":"imageId","index_type":"btree","cardinality":2,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","name":"newspaperdotcom_image_id","size":"16384","column":"imageId","index_type":"btree","cardinality":2,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","name":"game_id","size":"16384","column":"game_id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","name":"section","size":"16384","column":"section_code","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"section_school_season_game_type","size":"16384","column":"section_code","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"section_school_season_game_type","size":"16384","column":"school_code","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"section_school_season_game_type","size":"16384","column":"season_code","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","name":"section_school_season_game_type","size":"16384","column":"conference_code","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":3142,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"county_name_lsad","size":"114688","column":"county_name","index_type":"btree","cardinality":1834,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"county_name_lsad","size":"114688","column":"LSAD","index_type":"btree","cardinality":1879,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"county_name_lsad","size":"114688","column":"state_code","index_type":"btree","cardinality":3142,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"county_code","size":"65536","column":"county_code","index_type":"btree","cardinality":1010,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","name":"state_code","size":"65536","column":"state_code","index_type":"btree","cardinality":51,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":69,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"state_code","size":"16384","column":"state_code","index_type":"btree","cardinality":69,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"state_name","size":"16384","column":"state_name","index_type":"btree","cardinality":69,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"state_abbrv","size":"16384","column":"state_abbreviation","index_type":"btree","cardinality":69,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"sa_state_idx_state_code_state_name","size":"16384","column":"state_code","index_type":"btree","cardinality":69,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","name":"sa_state_idx_state_code_state_name","size":"16384","column":"state_name","index_type":"btree","cardinality":69,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":2382,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","name":"entry","size":"163840","column":"entry","index_type":"btree","cardinality":2382,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":39,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"member","size":"16384","column":"member_id","index_type":"btree","cardinality":4,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","name":"member","size":"16384","column":"ip_address","index_type":"btree","cardinality":39,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":72468,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"section_school_season_game_type","size":"4734976","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"section_school_season_game_type","size":"4734976","column":"school_code","index_type":"btree","cardinality":1089,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"section_school_season_game_type","size":"4734976","column":"season_code","index_type":"btree","cardinality":46619,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"section_school_season_game_type","size":"4734976","column":"game_type_code","index_type":"btree","cardinality":65950,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"sa_#_game_count_by_section_school_season_game_type_ibfk_2","size":"2637824","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"sa_#_game_count_by_section_school_season_game_type_ibfk_2","size":"2637824","column":"season_code","index_type":"btree","cardinality":129,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","name":"sa_#_game_count_by_section_school_season_game_type_ibfk_3","size":"1589248","column":"game_type_code","index_type":"btree","cardinality":7,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":77207,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"section_school_season","size":"3686400","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"section_school_season","size":"3686400","column":"school_code","index_type":"btree","cardinality":1035,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"section_school_season","size":"3686400","column":"season_code","index_type":"btree","cardinality":67104,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"sa_#_game_count_by_section_school_season_ibfk_2","size":"2637824","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","name":"sa_#_game_count_by_section_school_season_ibfk_2","size":"2637824","column":"season_code","index_type":"btree","cardinality":124,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":85688,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_code_sch","size":"6832128","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_code_sch","size":"6832128","column":"school_code","index_type":"btree","cardinality":1100,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_code_sch","size":"6832128","column":"opponent_key","index_type":"btree","cardinality":85688,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_school_opponent","size":"5783552","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_school_opponent","size":"5783552","column":"school_code","index_type":"btree","cardinality":1074,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_school_opponent","size":"5783552","column":"opponent_section_code","index_type":"btree","cardinality":2054,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_school_opponent","size":"5783552","column":"opponent_school_code","index_type":"btree","cardinality":73203,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_school_opponent","size":"5783552","column":"manual_opponent_name","index_type":"btree","cardinality":85688,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_opponent","size":"2637824","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","name":"section_opponent","size":"2637824","column":"opponent_school_code","index_type":"btree","cardinality":1075,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":2277,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"section_school_game_type","size":"81920","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"section_school_game_type","size":"81920","column":"school_code","index_type":"btree","cardinality":885,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"section_school_game_type","size":"81920","column":"game_type_code","index_type":"btree","cardinality":2277,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","name":"sa_#_game_count_by_section_school_game_type_ibfk_2","size":"65536","column":"game_type_code","index_type":"btree","cardinality":8,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":1135,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"section_school","size":"49152","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","name":"section_school","size":"49152","column":"school_code","index_type":"btree","cardinality":1135,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":142,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"section_code_season_code","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","name":"section_code_season_code","size":"16384","column":"season_code","index_type":"btree","cardinality":142,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":34,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","name":"action_call","size":"16384","column":"action_call","index_type":"btree","cardinality":34,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":10,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","name":"section_code_action_call","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","name":"section_code_action_call","size":"16384","column":"action_call","index_type":"btree","cardinality":10,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","name":"sa_section_action_call_ibfk_2","size":"16384","column":"action_call","index_type":"btree","cardinality":10,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":2368,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"location","size":"98304","column":"location","index_type":"btree","cardinality":2368,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"wikipedia_page_id","size":"65536","column":"wikipedia_page_id","index_type":"btree","cardinality":2368,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","name":"wikidata_item_id","size":"65536","column":"wikidata_item_id","index_type":"btree","cardinality":2368,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":213,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","name":"conference_name","size":"16384","column":"conference_name","index_type":"btree","cardinality":213,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","name":"conference_code","size":"16384","column":"conference_code","index_type":"btree","cardinality":213,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":52120,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"season_name","size":"1589248","column":"season_code","index_type":"btree","cardinality":112,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"team_name","size":"2637824","column":"team_name","index_type":"btree","cardinality":1139,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"season_team","size":"2637824","column":"season_code","index_type":"btree","cardinality":190,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"season_team","size":"2637824","column":"team_name","index_type":"btree","cardinality":49559,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"season_organization_classification_subclassification_region","size":"2637824","column":"season_code","index_type":"btree","cardinality":120,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"season_organization_classification_subclassification_region","size":"2637824","column":"conference_code","index_type":"btree","cardinality":5893,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"sa_affiliations_idx_section_co_school_cod_season_cod","size":"1589248","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"sa_affiliations_idx_section_co_school_cod_season_cod","size":"1589248","column":"school_code","index_type":"btree","cardinality":920,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","name":"sa_affiliations_idx_section_co_school_cod_season_cod","size":"1589248","column":"season_code","index_type":"btree","cardinality":50280,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":10,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"team_name","size":"16384","column":"school_code","index_type":"btree","cardinality":10,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"team_coach","size":"16384","column":"school_code","index_type":"btree","cardinality":10,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"sa_coach_tenure_idx_team_name_start_season","size":"16384","column":"school_code","index_type":"btree","cardinality":10,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"sa_coach_tenure_idx_team_name_start_season","size":"16384","column":"start_season_code","index_type":"btree","cardinality":10,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"sa_coach_idx_section_code_school_code","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","name":"sa_coach_idx_section_code_school_code","size":"16384","column":"school_code","index_type":"btree","cardinality":10,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":1163,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"49152","column":"school_code","index_type":"btree","cardinality":1144,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"49152","column":"start_season_code","index_type":"btree","cardinality":1163,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"49152","column":"end_season_code","index_type":"btree","cardinality":1163,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_school_history__idx_school_code_end_season","size":"49152","column":"school_code","index_type":"btree","cardinality":1144,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_school_history__idx_school_code_end_season","size":"49152","column":"end_season_code","index_type":"btree","cardinality":1163,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_school_history_location_ibfk_5","size":"16384","column":"state_code","index_type":"btree","cardinality":53,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_school_history__idx_start_season","size":"49152","column":"start_season_code","index_type":"btree","cardinality":134,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_school_history__idx_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":108,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_history_idx_school_cod_city_state_code","size":"65536","column":"school_code","index_type":"btree","cardinality":1144,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_history_idx_school_cod_city_state_code","size":"65536","column":"city","index_type":"btree","cardinality":1163,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_history_idx_school_cod_city_state_code","size":"65536","column":"state_code","index_type":"btree","cardinality":1163,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_history_idx_school_code_end_code","size":"49152","column":"school_code","index_type":"btree","cardinality":1144,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_history_idx_school_code_end_code","size":"49152","column":"end_season_code","index_type":"btree","cardinality":1163,"direction":"desc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_history_idx_section_code_school_code","size":"49152","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","name":"sa_history_idx_section_code_school_code","size":"49152","column":"school_code","index_type":"btree","cardinality":1143,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":142,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"sa_season_idx_section_season","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"sa_season_idx_section_season","size":"16384","column":"season_code","index_type":"btree","cardinality":142,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"sa_season_idx_section_code","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"sa_season_idx_active","size":"16384","column":"active","index_type":"btree","cardinality":2,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"sa_season_idx_active_section_co_season_cod","size":"16384","column":"active","index_type":"btree","cardinality":2,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"sa_season_idx_active_section_co_season_cod","size":"16384","column":"section_code","index_type":"btree","cardinality":2,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","name":"sa_season_idx_active_section_co_season_cod","size":"16384","column":"season_code","index_type":"btree","cardinality":142,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":352387,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"site_name","size":"21577728","column":"location","index_type":"btree","cardinality":2146,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_code_opponent_code","size":"11026432","column":"opponent_school_code","index_type":"btree","cardinality":1255,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_game_type_code","size":"5783552","column":"game_type_code","index_type":"btree","cardinality":7,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_attention_season_name","size":"5783552","column":"season_code","index_type":"btree","cardinality":128,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_code_season_name","size":"14204928","column":"opponent_school_code","index_type":"btree","cardinality":1457,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_code_season_name","size":"14204928","column":"season_code","index_type":"btree","cardinality":65462,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_team_code","size":"11026432","column":"team_school_code","index_type":"btree","cardinality":1163,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_season_name","size":"15253504","column":"team_school_code","index_type":"btree","cardinality":1410,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_season_name","size":"15253504","column":"season_code","index_type":"btree","cardinality":67426,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_season_nam_opponent_code","size":"14204928","column":"manual_opponent_coach_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_season_nam_opponent_code","size":"14204928","column":"season_code","index_type":"btree","cardinality":159,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_season_nam_opponent_code","size":"14204928","column":"opponent_school_code","index_type":"btree","cardinality":67979,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_opponent_code_season_nam","size":"14204928","column":"manual_opponent_coach_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_opponent_code_season_nam","size":"14204928","column":"opponent_school_code","index_type":"btree","cardinality":1130,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_opponent_code_season_nam","size":"14204928","column":"season_code","index_type":"btree","cardinality":70611,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_team_code_season_nam","size":"15253504","column":"manual_opponent_coach_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_team_code_season_nam","size":"15253504","column":"team_school_code","index_type":"btree","cardinality":1379,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_team_code_season_nam","size":"15253504","column":"season_code","index_type":"btree","cardinality":59408,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coach_team_code","size":"4734976","column":"manual_opponent_coach_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coach_opponent_code","size":"4734976","column":"manual_opponent_coach_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_site_code","size":"4734976","column":"site_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_season_nam_team_name_opponent","size":"11026432","column":"season_code","index_type":"btree","cardinality":126,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_season_nam_team_name_opponent","size":"11026432","column":"manual_team_name","index_type":"btree","cardinality":133,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_season_nam_team_name_opponent","size":"11026432","column":"manual_opponent_name","index_type":"btree","cardinality":17506,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_season_nam_team_code","size":"14204928","column":"manual_team_coach_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_season_nam_team_code","size":"14204928","column":"season_code","index_type":"btree","cardinality":152,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_manual_coa_season_nam_team_code","size":"14204928","column":"team_school_code","index_type":"btree","cardinality":70771,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_team_decision","size":"12075008","column":"team_school_code","index_type":"btree","cardinality":986,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_team_decision","size":"12075008","column":"team_decision","index_type":"btree","cardinality":2672,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_code_opponent_decision","size":"11026432","column":"opponent_school_code","index_type":"btree","cardinality":1075,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_code_opponent_decision","size":"11026432","column":"opponent_decision","index_type":"btree","cardinality":3282,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_team_decis_opponent","size":"14204928","column":"team_school_code","index_type":"btree","cardinality":1202,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_team_decis_opponent","size":"14204928","column":"team_decision","index_type":"btree","cardinality":2896,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_team_decis_opponent","size":"14204928","column":"opponent_school_code","index_type":"btree","cardinality":84787,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_code_opponent_decis_team","size":"14204928","column":"opponent_school_code","index_type":"btree","cardinality":1043,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_code_opponent_decis_team","size":"14204928","column":"opponent_decision","index_type":"btree","cardinality":2888,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_code_opponent_decis_team","size":"14204928","column":"team_school_code","index_type":"btree","cardinality":72130,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_section_code_opponent_section_code","size":"7880704","column":"team_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_section_code_opponent_section_code","size":"7880704","column":"opponent_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_section_code_team_section_code","size":"7880704","column":"opponent_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_section_code_team_section_code","size":"7880704","column":"team_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_section_code_team_school_code_team_decision","size":"14204928","column":"team_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_section_code_team_school_code_team_decision","size":"14204928","column":"team_school_code","index_type":"btree","cardinality":1056,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_section_code_team_school_code_team_decision","size":"14204928","column":"team_decision","index_type":"btree","cardinality":2940,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opp_section_code_opp_school_code_opp_decision","size":"14204928","column":"opponent_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opp_section_code_opp_school_code_opp_decision","size":"14204928","column":"opponent_school_code","index_type":"btree","cardinality":1174,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opp_section_code_opp_school_code_opp_decision","size":"14204928","column":"opponent_decision","index_type":"btree","cardinality":3559,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_season_cod_team_code","size":"18399232","column":"team_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_season_cod_team_code","size":"18399232","column":"team_school_code","index_type":"btree","cardinality":959,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_code_season_cod_team_code","size":"18399232","column":"season_code","index_type":"btree","cardinality":73332,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_season_cod_opponent","size":"17350656","column":"opponent_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_season_cod_opponent","size":"17350656","column":"opponent_school_code","index_type":"btree","cardinality":1294,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponent_season_cod_opponent","size":"17350656","column":"season_code","index_type":"btree","cardinality":78078,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_co_team_co_opponen_manual","size":"17350656","column":"team_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_co_team_co_opponen_manual","size":"17350656","column":"team_school_code","index_type":"btree","cardinality":1073,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_co_team_co_opponen_manual","size":"17350656","column":"opponent_school_code","index_type":"btree","cardinality":49901,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_team_co_team_co_opponen_manual","size":"17350656","column":"manual_opponent_name","index_type":"btree","cardinality":56448,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponen_opponen_team_co_manual","size":"16302080","column":"opponent_section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponen_opponen_team_co_manual","size":"16302080","column":"opponent_school_code","index_type":"btree","cardinality":1295,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponen_opponen_team_co_manual","size":"16302080","column":"team_school_code","index_type":"btree","cardinality":44436,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_opponen_opponen_team_co_manual","size":"16302080","column":"manual_team_name","index_type":"btree","cardinality":64397,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_season_code_team_section_code","size":"7880704","column":"season_code","index_type":"btree","cardinality":130,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_season_code_team_section_code","size":"7880704","column":"team_section_code","index_type":"btree","cardinality":149,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_season_code_opponent_section_code","size":"9977856","column":"season_code","index_type":"btree","cardinality":137,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","name":"sa_game_idx_season_code_opponent_section_code","size":"9977856","column":"opponent_section_code","index_type":"btree","cardinality":253,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":275,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","name":"school_code","size":"16384","column":"conference_code","index_type":"btree","cardinality":214,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":1145,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"sa_school_idx_school_code","size":"49152","column":"school_code","index_type":"btree","cardinality":1145,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"sa_school_idx_section_code_school_code","size":"49152","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"sa_school_idx_section_code_school_code","size":"49152","column":"school_code","index_type":"btree","cardinality":1145,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"wikipedia_page_id","size":"49152","column":"wikipedia_page_id","index_type":"btree","cardinality":1020,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"wikibase_item_id","size":"49152","column":"wikidata_item_id","index_type":"btree","cardinality":1020,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","name":"sa_school_idx_section_code","size":"16384","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":3,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"person_name","size":"16384","column":"person_name","index_type":"btree","cardinality":3,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"person_code","size":"16384","column":"person_code","index_type":"btree","cardinality":3,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"person_name_dab","size":"16384","column":"person_name","index_type":"btree","cardinality":3,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"person_name_dab","size":"16384","column":"dab","index_type":"btree","cardinality":3,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"wikipedia_page_id","size":"16384","column":"wikipedia_page_id","index_type":"btree","cardinality":3,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","name":"wikidata_item_id","size":"16384","column":"wikidata_item_id","index_type":"btree","cardinality":3,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":1459,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"url","size":"294912","column":"url","index_type":"btree","cardinality":1459,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","name":"last_accessed","size":"49152","column":"last_accessed","index_type":"btree","cardinality":977,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":6,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"lineage","size":"16384","column":"predecessor_school_code","index_type":"btree","cardinality":6,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"lineage","size":"16384","column":"successor_school_code","index_type":"btree","cardinality":6,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","name":"lineage","size":"16384","column":"season_code","index_type":"btree","cardinality":6,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":253,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"16384","column":"school_code","index_type":"btree","cardinality":253,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"16384","column":"start_season_code","index_type":"btree","cardinality":253,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":253,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"sa_school_history__idx_school_code_end_season","size":"16384","column":"school_code","index_type":"btree","cardinality":253,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"sa_school_history__idx_school_code_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":253,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"sa_school_history__idx_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","name":"sa_school_history__idx_start_season","size":"16384","column":"start_season_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":249,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"sa_school_history__idx_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"sa_school_history__idx_school_code_end_season","size":"16384","column":"school_code","index_type":"btree","cardinality":249,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"sa_school_history__idx_school_code_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":249,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"16384","column":"school_code","index_type":"btree","cardinality":249,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"16384","column":"start_season_code","index_type":"btree","cardinality":249,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":249,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","name":"sa_school_history__idx_start_season","size":"16384","column":"start_season_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"sa_school_history__idx_school_code_season","size":"16384","column":"school_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"sa_school_history__idx_school_code_season","size":"16384","column":"season_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","name":"sa_school_history__idx_season","size":"16384","column":"season_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":0,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"16384","column":"school_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"16384","column":"start_season_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"sa_school_history__idx_school_code_end_season","size":"16384","column":"school_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"sa_school_history__idx_school_code_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"sa_school_history__idx_end_season","size":"16384","column":"end_season_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","name":"sa_school_history__idx_start_season","size":"16384","column":"start_season_code","index_type":"btree","cardinality":0,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"PRIMARY","size":"-1","column":"id","index_type":"btree","cardinality":1827,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_school_name_dab","size":"81920","column":"school_name","index_type":"btree","cardinality":1712,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_school_name_dab","size":"81920","column":"dab","index_type":"btree","cardinality":1808,"direction":"asc","unique":true},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"81920","column":"school_code","index_type":"btree","cardinality":1144,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"81920","column":"start_season_code","index_type":"btree","cardinality":1827,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_school_history__idx_school_cod_start_seas_end_season","size":"81920","column":"end_season_code","index_type":"btree","cardinality":1827,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_school_history__idx_end_season","size":"49152","column":"end_season_code","index_type":"btree","cardinality":126,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_school_history__idx_start_season","size":"49152","column":"start_season_code","index_type":"btree","cardinality":140,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_school_code_end_code","size":"81920","column":"school_code","index_type":"btree","cardinality":1144,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_school_code_end_code","size":"81920","column":"end_season_code","index_type":"btree","cardinality":1827,"direction":"desc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_school_name_end_code","size":"81920","column":"school_name","index_type":"btree","cardinality":1712,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_school_name_end_code","size":"81920","column":"end_season_code","index_type":"btree","cardinality":1812,"direction":"desc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_school_code_school_name","size":"81920","column":"school_code","index_type":"btree","cardinality":1144,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_school_code_school_name","size":"81920","column":"school_name_dab","index_type":"btree","cardinality":1813,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_section_school_code_school_name","size":"81920","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_section_school_code_school_name","size":"81920","column":"school_code","index_type":"btree","cardinality":1143,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_section_school_code_school_name","size":"81920","column":"school_name","index_type":"btree","cardinality":1809,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_section_code_school_dab","size":"81920","column":"section_code","index_type":"btree","cardinality":1,"direction":"asc","unique":false},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","name":"sa_history_idx_section_code_school_dab","size":"81920","column":"school_name_dab","index_type":"btree","cardinality":1808,"direction":"asc","unique":false}],"tables":[{"schema":"ghsfhaco_cfbhadb","table":"sa_!_open_api_cache","rows":1459,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school","rows":1135,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_game_type","rows":2277,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_opponent","rows":85688,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season","rows":77207,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_conference","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_school_season_game_type","rows":72468,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_count_by_section_season","rows":142,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_#_game_source_verifications","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_all_americans","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_authority","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_brackets","rows":848,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_champion_national","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_affiliations","rows":52120,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_history_name","rows":275,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_conference_seasons","rows":14,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_conferences","rows":213,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_affiliations","rows":74694,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_division_priority","rows":15,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_flags","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_category","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_post","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_bookmarked","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_forum_topic_user_viewed","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game","rows":352387,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_conference_designations","rows":30,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_source_newspapersdotcom_image","rows":2,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_game_type","rows":9,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_location","rows":2368,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_log","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_member_online","rows":24,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_draft","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_nfl_player","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person","rows":3,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_coach_tenure","rows":10,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_person_relations","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_poll_results","rows":4776,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school","rows":1145,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_colors","rows":249,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_enrollment","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_home_venue","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_location","rows":1163,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_name","rows":1827,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_history_nickname","rows":253,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_lineage","rows":6,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_school_seasons","rows":9327,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_season","rows":142,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_season_lineage","rows":141,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section","rows":54,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_about","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_call","rows":10,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_action_model_method","rows":34,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_favorite","rows":3,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_section_page_bookmark","rows":35,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_image","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_source_newspapersdotcom_publication","rows":0,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_state","rows":69,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county","rows":3142,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"},{"schema":"ghsfhaco_cfbhadb","table":"sa_state_county_city","rows":2382,"type":"BASE TABLE","engine":"InnoDB","collation":"utf8mb4_general_ci"}]}