text: CREATE TYPE tournament_level AS ENUM ('G', 'F', 'L', 'M', 'O', 'A', 'B', 'C', 'U', 'E', 'H', 'D', 'T');
  CREATE TYPE surface AS ENUM ('H', 'C', 'G', 'P');
  CREATE TYPE draw_type AS ENUM ('KO', 'RR');
  CREATE TYPE player_hand AS ENUM ('R', 'L');
  CREATE TYPE player_backhand AS ENUM ('1', '2');
  CREATE TYPE tournament_event_result AS ENUM ('RR', 'R128', 'R64', 'R32', 'R16', 'QF', 'SF', 'BR', 'F', 'W');
  CREATE TYPE match_round AS ENUM ('RR', 'R128', 'R64', 'R32', 'R16', 'QF', 'SF', 'BR', 'F');
  CREATE TYPE tournament_entry AS ENUM ('Q', 'WC', 'LL', 'PR', 'SE', 'AL');
  CREATE TYPE match_outcome AS ENUM ('RET', 'W/O', 'DEF', 'ABD');
  CREATE TYPE rank_points AS (
  	rank INTEGER,
  	rank_points INTEGER
  );
  CREATE TYPE elo_ratings AS (
  	overall INTEGER,
  	recent INTEGER,
  	surface INTEGER,
  	in_out INTEGER,
  	set INTEGER
  );